Automate Daily Purchase Updates

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.