Generate weekly AI business digest from Google Sheets with GPT-4o and send to Slack and email
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets, OpenAI, Slack and Gmail.
How it runs
Trigger: On a schedule (every week at 08:00).
- Set report config variables (Edit Fields (Set)): sets 5 fields: googleSheetId, sheetName, slackChannel…
- Fetch metrics from Google Sheets (Google Sheets): read
- Calculate weekly comparisons (Code): runs custom JavaScript code
- Generate AI performance digest (OpenAI): work with chat
- Format digest for Slack and email (Code): runs custom JavaScript code
- Post digest to Slack channel (Slack): work with message
- Email digest to team (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
Who is this for Founders, marketing managers, and ops teams who track weekly business metrics in Google Sheets and want an automated AI-generated performance report delivered to Slack and email every Monday. Perfect for agencies, e-commerce businesses, and…