I maintain a sales-tracking Google Sheet that now needs a tidy overhaul. I’ll send you a CSV feed of fresh sales figures each week, and I want you to import those numbers while also keeping historical rows current—so both inserting new records and updating any that change. While you work, please bring consistent structure to the file: create clear custom headers and a footer summary, apply conditional formatting so under-performing SKUs and exceptional spikes stand out at a glance, and lock in data-validation rules that prevent typos (for example, restricting dates to valid months and product IDs to our existing catalogue). The result should be a sheet that a non-technical teammate can open, paste new sales, and immediately see accurate, visually flagged insights without breaking formulas. Deliverables: • A fully formatted Google Sheet with the latest sales data loaded • Documented steps (or an App Script, if you prefer) that show me how to repeat the add/update flow • Brief note outlining each conditional rule and validation you applied If something in my current structure will cause future headaches, flag it—I’m open to tweaks that make the sheet faster or easier to maintain.