Automate Google Sheets Data Flow

I’m juggling customer information across several Google Sheets and need a hands-free system that pulls data from multiple spreadsheets, cleans and validates it, then routes each record to the correct destination sheet automatically. Manual copy-paste is wasting hours and introducing errors, so the goal is a smooth, fully scripted workflow.

All sources and targets are Google Sheets, and the only data involved is customer information—names, contact details, account status, notes, the usual fields. I’m flexible on the plumbing: Google Apps Script, the Sheets API, or even Zapier/Make if it keeps things maintainable and transparent. What matters is that I end up with one clear, documented solution I can tweak on my own later.

Core deliverables
• A working automation that fetches, deduplicates, formats, and writes customer data between the specified Sheets.
• Trigger options (time-based or on-edit) I can toggle without touching code.
• Inline comments and a short read-me so future edits are straightforward.

Acceptance criteria
1. Installable in my Google Workspace with a single authorization prompt.
2. Processes at least 5,000 rows in under two minutes.
3. Logs every change in a dedicated sheet and flags any skipped or conflicting rows.

Share your preferred approach, the tools you’ll use, and a rough timeline, and we can get rolling right away.