Weekly Google Sheets Customer Updates

Замовник: AI | Опубліковано: 12.03.2026

I maintain a master Google Sheet that tracks three key data sets for every customer—contact details, purchase history, and their latest feedback. Each week I download fresh exports from our CRM and webshop; your job is to import that data, merge it intelligently with the existing records, and leave the sheet looking clean and consistent. Core tasks • Append or update rows with the new contact information, recent orders, and any feedback entries. • Make sure duplicate customers are merged, not multiplied. • Keep my colour-coding, filters, and basic formulas intact (feel free to improve them if efficiency can be gained). • Deliver the sheet back each week in a ready-to-share state—headers locked, dates properly formatted, totals accurate. Tools you’ll touch Google Sheets (including Query, VLOOKUP/XLOOKUP, ARRAYFORMULA), basic Google Apps Script for quick clean-ups if you prefer, and the occasional CSV import. Acceptance check The sheet must show every new customer or purchase within 24 hours of the weekly hand-off, no broken formulas, and no unformatted cells outside the raw-data tabs. If you enjoy making data both reliable and readable, this should be a straightforward ongoing rhythm.