Google Sheets Analysis Automation Script

I keep all of my raw data inside Google Sheets and I’m ready to replace the manual formulas, filters, and copy-paste routines with a Google Apps Script that runs everything for me automatically. The only pieces I definitely need are: • Automated data analysis that crunches the existing sheets on demand (or on a set trigger) and writes clean, structured results to a separate “Report” tab. • A reporting routine that summarises the latest results and makes them instantly readable—pivot-style tables or a custom summary, whatever is most efficient in Apps Script. Everything lives in Google Sheets, so the script can stay entirely in‐file; no external databases or add-ons are required right now. As long as the code is tidy, commented, and easy for me to tweak later, I’m happy. When you deliver, I’ll test by running the script on a copy of my spreadsheet and checking that the numbers in the generated report match a manual calculation. If you can meet that acceptance test and show me where to adjust ranges or add future metrics, we’re good to go.