Automating client campaign stat reports with Gemini Gems and Google Apps Script

Sebastien Bosse-Platiere Lyon, France · 1H AGO

As an agency, we have to report the work we do for our clients and how efficient it is. Building these presentations by hand is very time consuming and boring, and there is little value in making them. At Le Trefle à 5 Feuilles we decided to automate this recurring task. Before, it took about 3 hours to gather every stats report, make the presentation available to the client, and interpret the stats and recommend further actions. I keep a human in the loop, because someone has to read the report before it is sent. Since we work in Google Workspace, I built the workflow with several Gemini Gems: 1. Google Apps Script watches one folder on Google Drive and detects when a new statistics report is posted. 2. The first Gem decodes the report and inserts the variables into it. 3. The second Gem interprets and sums up all the statistics. 4. The third Gem merges those statistics into the template the workflow calculated. 5. I review the finished presentation before sending it to the client. It now takes only 3 minutes to produce the report, so the consultant can focus on the real value: their analysis of the campaign.