I keep my sales and purchase transactions in separate CSV files and upload them regularly. Each time I add a new file, I want my master Google Sheets workbook to refresh both the Sales and Purchase tabs automatically—no copy-paste, no broken formulas, just clean, up-to-date numbers. Here’s what I have in mind: • When I drop a new CSV into Drive (or trigger an Upload button), a script or workflow should detect it, clear the old data in the matching tab, import the fresh rows, and leave every existing pivot, chart, and summary intact. • Sales and Purchase data must stay in their own tabs, but share one unified date format and consistent column order. • The process should finish in seconds and log a short “last updated” timestamp so I can see that everything ran correctly. Feel free to use Google Apps Script, AppSheet automation, or another lightweight tool that suits the job—as long as I’m not tied to paid third-party platforms. Deliverables 1. Working import/refresh script or workflow connected to my spreadsheet 2. Short setup guide so I can add new CSV mappings myself 3. Quick hand-off call or Loom video walking through the trigger and rollback steps I’ll share a copy of the workbook plus sample CSVs once we kick off. Let me know if you’ve done similar Google Sheets automation before and can turn this around quickly.