I keep a master Google Sheet that tracks each customer’s purchase history, but right now I have to import a fresh CSV every morning and rearrange columns by hand. I’d like a small, reliable automation that takes the daily CSV file I receive, pushes the relevant fields into the sheet, and overwrites or appends data without breaking existing formulas. The flow I picture is simple: drop the CSV into Drive (or share a link), trigger an Apps Script—or another lightweight approach of your choice—and see the purchase history area update instantly. Field-to-field mapping must stay intact, duplicates handled gracefully, and a quick log of the latest sync timestamp added somewhere on the sheet so I always know it ran. Deliverables I need: • A working script or no-code workflow wired to the sheet • Clear setup instructions so I can reconnect it if the file path changes • One short call or screen-share (recorded is fine) to walk me through the first live run If you’ve built similar Google Sheets + CSV automations, feel free to suggest optimisations; otherwise, straightforward and dependable will do the job.