Freelance › Projects › Web development › Automate weekly reporting in Google Sheets with Apps Script
Automate weekly reporting in Google Sheets with Apps Script
Employer
Mykola
Project parameters
Type of cooperationOne-time project
SectionWeb development
Prepaymentwithout prepayment
Payment methodsCash, Bank transfer
Acceptance of requestsfrom today, 21:20 until Aug 26, 2026
Project description
Our small team currently spends far too much time every week building the same operational report by hand. Someone opens three or four different source spreadsheets, copies ranges into a master workbook, cleans up the columns, rebuilds a couple of pivot summaries and then screenshots the result into an email for the managers. It works, but it eats several hours, it breaks whenever a column moves, and mistakes slip in because everything is manual copy-paste. We are looking for a specialist who can turn this whole routine into a reliable, hands-off process built on Google Sheets and Google Apps Script, so the report simply appears on schedule without anyone touching it.
Concretely, we want a script that automatically gathers data from our existing source sheets (some in the same spreadsheet, some in separate files we will share with you), consolidates the rows into a clean working tab, and drives the calculated formulas and pivot-style summaries that feed our dashboard. The output should be a formatted summary tab plus a scheduled email that goes out to a small distribution list every week, containing the key figures and a link to the live workbook. We would like the automation to be robust: if a source is empty or a tab is renamed, it should log the problem rather than fail silently, and it must be easy for a non-technical person to adjust the recipient list and the run time. Clean, commented code and a short written explanation of how to maintain it are important to us, because we want to own and extend this ourselves later.
Please describe your relevant experience with Apps Script automation and roughly how long you expect the work to take. Deliverables we expect:
— Working Apps Script that consolidates data from the specified source sheets into a master tab
— Automated formulas and pivot/summary tables feeding a formatted report tab
— A time-driven trigger that emails the weekly report to a configurable recipient list
— Basic error handling and logging so failures are visible, not silent
— Commented code and a short maintenance guide handed over at the end
Concretely, we want a script that automatically gathers data from our existing source sheets (some in the same spreadsheet, some in separate files we will share with you), consolidates the rows into a clean working tab, and drives the calculated formulas and pivot-style summaries that feed our dashboard. The output should be a formatted summary tab plus a scheduled email that goes out to a small distribution list every week, containing the key figures and a link to the live workbook. We would like the automation to be robust: if a source is empty or a tab is renamed, it should log the problem rather than fail silently, and it must be easy for a non-technical person to adjust the recipient list and the run time. Clean, commented code and a short written explanation of how to maintain it are important to us, because we want to own and extend this ourselves later.
Please describe your relevant experience with Apps Script automation and roughly how long you expect the work to take. Deliverables we expect:
— Working Apps Script that consolidates data from the specified source sheets into a master tab
— Automated formulas and pivot/summary tables feeding a formatted report tab
— A time-driven trigger that emails the weekly report to a configurable recipient list
— Basic error handling and logging so failures are visible, not silent
— Commented code and a short maintenance guide handed over at the end
