{"product_id":"n8n-workflow-gemini-gmail-email-google-sheets-dashboards","title":"n8n Workflow: Gemini \u0026 Gmail Email Google Sheets Dashboards","description":"\u003ch3\u003eAutomate executive email dashboards from Google Sheets using n8n + Google Gemini\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Google Sheets registrations every 15 minutes, analyzes your separate \u003cstrong\u003eSalesData\u003c\/strong\u003e sheet with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, generates executive recommendations, builds a branded HTML dashboard, and emails it to each new registrant via \u003cstrong\u003eGmail\u003c\/strong\u003e—then marks the registration as processed to prevent repeat sends.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e A \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e starts the workflow every 15 minutes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds new registrants:\u003c\/strong\u003e Reads rows from your registrations Google Sheets tab (\u003cstrong\u003e“Form Responses 1”\u003c\/strong\u003e) and filters out entries where the \u003cstrong\u003eProcessed\u003c\/strong\u003e field is already set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads the latest dataset:\u003c\/strong\u003e For each new registration, it pulls data from the \u003cstrong\u003eSalesData\u003c\/strong\u003e tab (referenced as a separate Google Sheets tab).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProfiles the dataset:\u003c\/strong\u003e Computes metrics such as row count, numeric summaries, and top category breakdowns, and extracts the registrant’s \u003cstrong\u003eName\u003c\/strong\u003e (optional) and \u003cstrong\u003eEmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates recommendations with Gemini:\u003c\/strong\u003e Sends a dataset profile and a sample of rows to the \u003cstrong\u003eGoogle Gemini API\u003c\/strong\u003e to produce concise executive recommendations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an HTML dashboard:\u003c\/strong\u003e Combines key metrics and Gemini’s recommendations into an HTML dashboard.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail + updates status:\u003c\/strong\u003e Emails the dashboard to the registrant, then updates the matching row in Google Sheets (by \u003cstrong\u003eEmail\u003c\/strong\u003e) by setting \u003cstrong\u003eProcessed\u003c\/strong\u003e to \u003cstrong\u003e“Sent”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend “executive summary” dashboards to new SaaS users or report subscribers.\u003c\/li\u003e\n  \u003cli\u003eAutomatically deliver analysis-driven insights after spreadsheet-based registrations.\u003c\/li\u003e\n  \u003cli\u003eOps teams: reduce manual reporting by emailing Gemini-generated recommendations on a recurring schedule.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ integrations:\u003c\/strong\u003e Schedule Trigger, Google Sheets, Code, Split in Batches, HTTP Request, Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired tabs:\u003c\/strong\u003e “Form Responses 1” for registrations and “SalesData” for the dataset.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup notes:\u003c\/strong\u003e Add Google Sheets credentials and set \u003cstrong\u003eREGISTRATION_SHEET_ID\u003c\/strong\u003e and \u003cstrong\u003eDATA_SHEET_ID\u003c\/strong\u003e. Provide a Gemini API key in the Gemini API request URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029474791603,"sku":"N8N-19590","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jK4GJ16sJ8PxOzv7qAi9X_DAHSYBlD.png?v=1789463678","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-gemini-gmail-email-google-sheets-dashboards","provider":"N8N Commerce","version":"1.0","type":"link"}