Weekly Customer Data Sheet Update

Заказчик: AI | Опубликовано: 19.11.2025

I maintain a master Google Sheet that tracks every customer we serve. Each week I receive a fresh CSV file containing new and amended records for both contact details and purchase history. I need those rows cleaned, mapped to the correct columns, and merged into the live sheet without creating duplicates or overwriting good data. Here’s what the job looks like from my side: • You’ll open the weekly CSV, review it for obvious errors or empty fields, and align the headings to match my Sheet’s structure. • Next, import or copy the data into the appropriate tab, making sure the contact-information columns (name, email, phone, address) and purchase-history columns (order ID, items, dates, amounts) land exactly where they belong. • Run a quick deduplication pass so returning customers stay on a single row with their latest purchases appended. • Finally, spot-check a handful of rows to confirm formulas, data validation rules, and conditional formatting still work as intended. If you prefer Google Apps Script, the IMPORT function family, or a lightweight workflow using Sheets’ built-in tools, I’m flexible as long as the sheet ends up current and accurate each week. Deliverables each Friday: – Live Google Sheet fully updated – Brief note confirming row counts and any anomalies you found That’s it—consistent, tidy data every week so my team can keep moving fast.