I keep a central Google Sheet that tracks all of our product sales, and I need it to refresh every day without fail. The figures come from three places: the POS terminals in our store, our e-commerce platform, and a small batch of manual counter sales that still arrive in a spreadsheet. Right now I merge these sources by hand, which is slow and error-prone, so I want the process fully automated. What I’m after is a tidy, self-maintaining workflow—Apps Script, API pulls, Zapier, Python, or whatever stack you prefer—that each day grabs the latest data from the POS and e-commerce systems, appends or updates the correct tabs, and leaves me with one clean, reconciled view by the start of business. Manual entries should slot in just as smoothly, either through an import routine or a simple form you set up inside the sheet. Deliverables • A working Google Sheet (or Excel file if you have a better approach) that refreshes daily with product sales from all three sources. • Commented code or connectors so I can adjust endpoints or column mappings later. • Brief hand-off notes outlining how to rerun or troubleshoot the job. If you’ve built similar daily sales dashboards or have experience wrangling data from mixed retail systems, you’ll be a perfect fit.