Google Sheets Progress Report Automation

via Freelancer ·

Budget / Salary₹1,500–12,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I need a streamlined Google Sheets solution that transforms raw project data into clear, up-to-date progress reports and summaries. The job covers designing the sheet layout, writing Google Apps Script macros to pull and aggregate figures, and setting up triggers so the reports refresh on a schedule.

Please structure the file so I can see percent complete, overdue items, and upcoming deadlines at a glance, with any charts or conditional formatting that make trends obvious. Code should be efficient and well-commented so I can tweak it later.

When you respond, focus on your experience building similar reporting or dashboard systems in Google Sheets and Apps Script.

Deliverables:
• A fully functional Google Sheet template
• All associated Apps Script files, cleanly commented
• A brief walkthrough (video or document) explaining how to maintain or extend the setup

Include your estimated turnaround and any clarifying questions you may have.
php javascript visual basic project management excel data visualization google sheets automation
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.