n8n Workflow: Gemini & Gmail Email Google Sheets Dashboards

Automate executive email dashboards from Google Sheets using n8n + Google Gemini

This n8n workflow scans your Google Sheets registrations every 15 minutes, analyzes your separate SalesData sheet with Google Gemini, generates executive recommendations, builds a branded HTML dashboard, and emails it to each new registrant via Gmail—then marks the registration as processed to prevent repeat sends.

What this workflow does

• Runs on a schedule: A Schedule Trigger starts the workflow every 15 minutes.
• Finds new registrants: Reads rows from your registrations Google Sheets tab (“Form Responses 1”) and filters out entries where the Processed field is already set.
• Loads the latest dataset: For each new registration, it pulls data from the SalesData tab (referenced as a separate Google Sheets tab).
• Profiles the dataset: Computes metrics such as row count, numeric summaries, and top category breakdowns, and extracts the registrant’s Name (optional) and Email.
• Generates recommendations with Gemini: Sends a dataset profile and a sample of rows to the Google Gemini API to produce concise executive recommendations.
• Creates an HTML dashboard: Combines key metrics and Gemini’s recommendations into an HTML dashboard.
• Sends via Gmail + updates status: Emails the dashboard to the registrant, then updates the matching row in Google Sheets (by Email) by setting Processed to “Sent”.

Use cases

• Send “executive summary” dashboards to new SaaS users or report subscribers.
• Automatically deliver analysis-driven insights after spreadsheet-based registrations.
• Ops teams: reduce manual reporting by emailing Gemini-generated recommendations on a recurring schedule.

Technical details

• n8n nodes / integrations: Schedule Trigger, Google Sheets, Code, Split in Batches, HTTP Request, Gmail.
• Required tabs: “Form Responses 1” for registrations and “SalesData” for the dataset.
• Setup notes: Add Google Sheets credentials and set REGISTRATION_SHEET_ID and DATA_SHEET_ID. Provide a Gemini API key in the Gemini API request URL.