Weekly KPI Email Report: Google Sheets + Gemini + Gmail (n8n)

Automate your weekly KPI reporting in minutes—Google Sheets metrics + Gemini insights, delivered by Gmail

This n8n workflow automatically pulls your latest KPI data from Google Sheets, calculates totals and averages, generates a weekly executive summary with Google Gemini, and emails a styled HTML report to your recipients using Gmail.

What this workflow does

• Runs on a weekly schedule using a Schedule Trigger.
• Reads metrics from Google Sheets, pulling the latest rows from your chosen worksheet.
• Aggregates results to compute per-metric totals and averages, and formats them into a text summary.
• Generates an executive summary with Google Gemini (PaLM) by sending the computed metrics to the LLM step.
• Builds an HTML email report that includes the Gemini summary and a KPI table.
• Sends the report via Gmail to the specified recipient email address.

Use cases

• SaaS operators who need a consistent weekly performance brief across KPIs stored in Google Sheets.
• Automation engineers standardizing executive reporting without manual copy/paste from spreadsheets.
• Teams tracking weekly metrics who want a single email that blends numbers (totals/averages) with narrative context from Gemini.

Technical details

• Schedule Trigger to run the workflow weekly.
• Google Sheets integration to read KPI rows from your selected spreadsheet and worksheet.
• Code node to aggregate metrics (totals/averages) and prepare the summary data.
• Google Gemini (PaLM) API credential for generating the executive summary.
• HTML rendering to create the email layout and KPI table.
• Gmail to send the final HTML report to recipients.

Setup checklist

• Connect Google Sheets OAuth and select the spreadsheet/worksheet with metric rows (e.g., Metric and Value columns).
• Add a Google Gemini (PaLM) API credential for the summary step.
• Add Gmail OAuth2 and set recipients.
• Adjust the weekly schedule (day/hour) and customize the email subject/template as needed.