{"product_id":"weekly-kpi-email-report-google-sheets-gemini-gmail-n8n","title":"Weekly KPI Email Report: Google Sheets + Gemini + Gmail (n8n)","description":"\u003ch3\u003eAutomate your weekly KPI reporting in minutes—Google Sheets metrics + Gemini insights, delivered by Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls your latest KPI data from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates totals and averages, generates a weekly \u003cstrong\u003eexecutive summary with Google Gemini\u003c\/strong\u003e, and emails a styled HTML report to your recipients using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a weekly schedule\u003c\/strong\u003e using a Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads metrics from Google Sheets\u003c\/strong\u003e, pulling the latest rows from your chosen worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates results\u003c\/strong\u003e to compute \u003cstrong\u003eper-metric totals and averages\u003c\/strong\u003e, and formats them into a text summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an executive summary with Google Gemini (PaLM)\u003c\/strong\u003e by sending the computed metrics to the LLM step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds an HTML email report\u003c\/strong\u003e that includes the Gemini summary and a KPI table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the report via Gmail\u003c\/strong\u003e to the specified recipient email address.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e who need a consistent weekly performance brief across KPIs stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e standardizing executive reporting without manual copy\/paste from spreadsheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTeams tracking weekly metrics\u003c\/strong\u003e who want a single email that blends numbers (totals\/averages) with narrative context from Gemini.\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 to run the workflow weekly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration to read KPI rows from your selected spreadsheet and worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e node to aggregate metrics (totals\/averages) and prepare the summary data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM) API\u003c\/strong\u003e credential for generating the executive summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTML\u003c\/strong\u003e rendering to create the email layout and KPI table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to send the final HTML report to recipients.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect Google Sheets OAuth and select the spreadsheet\/worksheet with metric rows (e.g., \u003cstrong\u003eMetric\u003c\/strong\u003e and \u003cstrong\u003eValue\u003c\/strong\u003e columns).\u003c\/li\u003e\n  \u003cli\u003eAdd a \u003cstrong\u003eGoogle Gemini (PaLM) API\u003c\/strong\u003e credential for the summary step.\u003c\/li\u003e\n  \u003cli\u003eAdd \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e and set recipients.\u003c\/li\u003e\n  \u003cli\u003eAdjust the weekly schedule (day\/hour) and customize the email subject\/template as needed.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761005945011,"sku":"N8N-17827","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Fzjz1_o6Obhh_0K5k2yQ3_Rsy3repz.png?v=1785921038","url":"https:\/\/buyflowscripts.com\/products\/weekly-kpi-email-report-google-sheets-gemini-gmail-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}