{"product_id":"n8n-weekly-client-performance-reports-via-gemini-gmail","title":"n8n Weekly Client Performance Reports via Gemini \u0026 Gmail","description":"\u003ch3\u003eSend polished weekly client performance reports automatically—using n8n, Google Gemini, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation runs every Monday at 8:00 AM to generate a per-client weekly performance summary with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, then emails a formatted plain-text report to each client via \u003cstrong\u003eGmail\u003c\/strong\u003e. No manual writing, no copy\/paste—just consistent, client-ready reporting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules the report\u003c\/strong\u003e: triggers on a cron schedule every \u003cstrong\u003eMonday at 8:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your client list\u003c\/strong\u003e: reads client objects (clientName, contactEmail, company, industry) from a configurable list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds weekly metrics\u003c\/strong\u003e: attaches weekly performance metrics and channel breakdowns (initially placeholder data you can replace with your real sources).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a narrative summary with Gemini\u003c\/strong\u003e: sends the metrics to \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e to produce a \u003cstrong\u003e150–200 word\u003c\/strong\u003e second-person weekly summary including an \u003cstrong\u003eactionable recommendation\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCombines AI output + original metrics\u003c\/strong\u003e: extracts the report text and merges it with the underlying metric details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail\u003c\/strong\u003e: sends a \u003cstrong\u003eformatted plain-text\u003c\/strong\u003e email report to each client using a Gmail OAuth2 credential.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAgency operators who need automated \u003cstrong\u003eweekly client performance reporting\u003c\/strong\u003e without drafting emails every week.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable \u003cstrong\u003eGemini + email reporting workflow\u003c\/strong\u003e inside n8n.\u003c\/li\u003e\n  \u003cli\u003eSaaS teams that want consistent, client-facing summaries derived from marketing metrics (e.g., channel breakdowns) and delivered through Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e: runs every Monday at 8:00 AM.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e: generates the 150–200 word second-person report with recommendations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends the final plain-text email to each client.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e: handles report text extraction and assembling the final email content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n-nodes-langchain \/ Google Gemini node\u003c\/strong\u003e (as used in the AI summary step): configured with the selected Gemini model.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd \u003cstrong\u003eGoogle Gemini API credentials\u003c\/strong\u003e and choose the Gemini model in the AI summary step.\u003c\/li\u003e\n  \u003cli\u003eAdd a \u003cstrong\u003eGmail OAuth2 credential\u003c\/strong\u003e and authorize the sending mailbox.\u003c\/li\u003e\n  \u003cli\u003eReplace the hardcoded client list and placeholder metrics with your real client objects and weekly metric fields.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741404422323,"sku":"N8N-17621","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/LagDUQOLnMtSrO2OrR9PX_zgj1Rbuy.png?v=1785315682","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-client-performance-reports-via-gemini-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}