Daily Google Sheet Update

I maintain a master Google Sheet that tracks both customer information and individual sales transactions. Every day new records arrive in separate CSV files, and I need those files parsed and the fresh rows appended to the correct tabs of the Sheet—customers on one tab, sales on another—without overwriting existing data or breaking my formulas.

Here’s what I already have: the Google Sheet structure is in place, column headers are consistent with the incoming CSV exports, and the files land in a dedicated Google Drive folder each morning. What I’m missing is the automation layer that:

• Detects each new CSV as it appears (or runs on a set schedule),
• Imports the data, performing any basic cleansing needed (trim blanks, normalise dates, de-duplicate by customer ID),
• Appends the rows in the right order, and
• Sends me a quick confirmation email or Slack message once the update succeeds.

You’re free to use Google Apps Script, AppSheet, Zapier, Make/Integromat, or another lightweight solution—as long as the workflow runs reliably in the background and I can adjust it later without major re-coding. When you hand it over I’ll need:

• A working automation connected to my Sheet and Drive folder,
• Clear, step-by-step documentation inside the script or a short README on how to modify file paths, column mappings, and the daily schedule,
• A brief loom/video or screenshot walkthrough so I can see it in action.

Acceptance criteria: after the job is complete I should be able to drop a brand-new customer CSV and a sales CSV into the folder, wait for the daily trigger, and find those rows perfectly integrated—no duplicates, no missing columns.