I’m setting up an end-to-end automation that lets each of my 1-5 retail branches log their daily takings and instantly rolls everything into a master dashboard. The data entry can come from either a Google Form or an AppSheet app—I’m flexible as long as it feels quick and intuitive for my staff. Behind the scenes, the master Google Sheet must calculate branch totals and a consolidated figure, then—every evening—push a neatly formatted sales summary to my WhatsApp number via Interakt or the official WhatsApp Cloud API. The whole flow needs to run on time without manual nudges, so solid App Script (or AppSheet automation) is essential. Deliverables I’m expecting • A branded Google Form or AppSheet front end for each branch • Master Google Sheet with live formulas and clear visual totals • App Script / automation that schedules and sends the nightly WhatsApp report • Basic documentation so I can tweak branch names or add new outlets later I’d like this up and running ASAP, with a clean design my non-tech staff won’t trip over. If you’ve wired Google Sheets, AppScript, AppSheet, and WhatsApp APIs together before, I’m ready to get started.