Google Sheets Cleanup & Automation
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
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.
• 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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.