Google Sheets Automation Specialist | Vendor Tracking & Apps Script

Job Description We are looking for an experienced Google Sheets and Google Apps Script developer to build a simple but reliable automation for our accounting workflow. Project Overview We receive vendor names from bank transactions each month. We need a Google Sheet that automatically identifies only vendors that have never been seen before. Scope of Work Create a Google Sheet with two tabs: Tab 1: Vendor Import Paste a list of vendor names into Column A each month. The list may contain duplicates. Tab 2: New Vendors Automatically identify vendors that have never appeared before. Ignore duplicate names. Compare names regardless of capitalization. Append only brand new vendors to the bottom of the list. Previously identified vendors should never appear again. Requirements Google Sheets expert Google Apps Script experience Clean, well documented code Ability to make the solution easy for non technical users Strong communication skills Deliverables Fully functional Google Sheet Google Apps Script automation One click button or menu item to run the process Brief instructions explaining how to use and maintain the solution