Google Sheets Cleanup & Automation

I have several live Google Sheets that have grown messy and time-consuming to manage. I need a specialist to jump in and: • Clean the data – remove duplicates, fix inconsistent formats (dates, currencies, text case), and track down any errors that are throwing off calculations. • Build light-weight automations for repetitive work: structured data-entry forms, one-click analysis summaries, and scheduled report generation that lands in a separate “Reports” tab or emails a PDF snapshot. • Package everything into reusable templates so I can launch a fresh, clean copy for each project without rebuilding formulas or Apps Script triggers. Must-haves: – Native Google Sheets skills (ARRAYFORMULA, QUERY, REGEX, pivot tables). – Comfortable writing and documenting Apps Script. – Clear comments or a short Loom walkthrough so I can maintain the file once you’re done. Acceptance check: 1. No duplicate rows and consistent formatting across all historic data. 2. Automated workflows run successfully on a test dataset without manual intervention. 3. A template file is delivered with instructions and working triggers. If this is in your wheelhouse, let’s make my Sheets run themselves.