n8n Weekly KPI Executive Summary: Gemini + Sheets to Gmail & Slack

Automate your weekly KPI exec update—Gemini + Google Sheets to Gmail & Slack

This n8n workflow automatically reads your weekly KPI rows from Google Sheets, enriches them with benchmark KPI data from an HTTP API, generates an executive-style summary using Google Gemini, then delivers it via Gmail and Slack—and logs the result back to Google Sheets.

What this workflow does

• Runs weekly on a schedule to start your reporting cycle.
• Pulls KPI input data from a Google Sheets spreadsheet (including fields such as week_start, channel, metric_name, current_value, previous_value, target_value, and notes).
• Fetches benchmark KPIs from a configurable HTTP endpoint.
• Normalizes and merges the KPI sources into a consistent structure for reporting.
• Calculates week-over-week movement: absolute change, percentage change, trend direction, and whether each metric is above/below target.
• Uses Google Gemini (PaLM) to create a concise executive summary from the consolidated KPI results.
• Formats and distributes the AI summary, then sends it via Gmail and Slack.
• Appends a copy to a KPI log sheet in Google Sheets for historical tracking.

Use cases

• SaaS operators who need a weekly exec update without manually compiling KPI tables.
• Automation engineers building an internal performance reporting pipeline for KPIs.
• Teams comparing internal performance vs benchmarks and sharing results in email + Slack.

Technical details

• Schedule Trigger for weekly execution.
• Google Sheets for KPI input and KPI logging.
• HTTP endpoint for benchmark KPI data.
• Code / Set / Merge steps to normalize, merge, and calculate KPI movement metrics.
• Google Gemini (PaLM) to generate the executive summary.
• Gmail and Slack for delivery.
• Sticky Note nodes for workflow documentation/clarity.

Perfect for anyone looking to streamline Google Sheets KPI reporting, AI-generated weekly summaries, and Slack + Gmail distribution with n8n.