I keep two Google Sheets—one tracks every customer comment or review I receive, the other records each sale. At the moment I paste everything in by hand and it’s becoming unmanageable. I need the data in both sheets refreshed every day without fail. Here’s what I’m after: • A reliable workflow (Apps Script, API pull, importer – whatever you recommend) that moves my manually collected feedback and sales figures into their dedicated tabs. • Automatic de-duplication and a quick validation step so bad rows never slip in. • Time-stamped entries plus a running daily summary row that I can link to existing charts. • Clear, short instructions so I can adjust column names or add a new data source later. I’ll provide the current spreadsheets and a sample of the raw files I receive each day. Once your solution is in place I should be able to drop the new file in a folder (or fire a simple form) and see both sheets update within minutes. Acceptance criteria: 1. Both “Feedback” and “Sales” tabs show the new day’s data after one click or a scheduled trigger. 2. No duplicate IDs in either sheet. 3. All formulas and charts already in the file keep working. 4. Setup notes are complete enough that I can replicate the process on another sheet. If you have questions about the source format or column mapping, let me know and I’ll send samples right away.