n8n Weekly Client Performance Reports via Gemini & Gmail

Send polished weekly client performance reports automatically—using n8n, Google Gemini, and Gmail

This n8n automation runs every Monday at 8:00 AM to generate a per-client weekly performance summary with Google Gemini, then emails a formatted plain-text report to each client via Gmail. No manual writing, no copy/paste—just consistent, client-ready reporting.

What this workflow does

• Schedules the report: triggers on a cron schedule every Monday at 8:00 AM.
• Loads your client list: reads client objects (clientName, contactEmail, company, industry) from a configurable list.
• Builds weekly metrics: attaches weekly performance metrics and channel breakdowns (initially placeholder data you can replace with your real sources).
• Generates a narrative summary with Gemini: sends the metrics to Google Gemini (PaLM) to produce a 150–200 word second-person weekly summary including an actionable recommendation.
• Combines AI output + original metrics: extracts the report text and merges it with the underlying metric details.
• Sends via Gmail: sends a formatted plain-text email report to each client using a Gmail OAuth2 credential.

Use cases

• Agency operators who need automated weekly client performance reporting without drafting emails every week.
• Automation engineers building a repeatable Gemini + email reporting workflow inside n8n.
• SaaS teams that want consistent, client-facing summaries derived from marketing metrics (e.g., channel breakdowns) and delivered through Gmail.

Technical details

• Schedule Trigger: runs every Monday at 8:00 AM.
• Google Gemini (PaLM): generates the 150–200 word second-person report with recommendations.
• Gmail: sends the final plain-text email to each client.
• Code: handles report text extraction and assembling the final email content.
• n8n-nodes-langchain / Google Gemini node (as used in the AI summary step): configured with the selected Gemini model.

Setup checklist

• Add Google Gemini API credentials and choose the Gemini model in the AI summary step.
• Add a Gmail OAuth2 credential and authorize the sending mailbox.
• Replace the hardcoded client list and placeholder metrics with your real client objects and weekly metric fields.