Track Slack EOD updates and post executive summaries with Google Sheets and Gemini
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 23 nodes and runs on a schedule (every day at 15:00) (plus 2 other triggers). Along the way it connects Slack, Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: On a schedule (every day at 15:00) (plus 2 other triggers).
- Fetch Manager Details (Google Sheets): uses Google Sheets
- Parse Slack Payload (Code): runs custom JavaScript code
- Read Today Submissions (Google Sheets): uses Google Sheets
- Read Submission Data to Edit (Google Sheets): uses Google Sheets
- Check If Person Is On Leave (If): checks a condition and branches into true / false
- Confirm Slack Action Received (HTTP Request): calls an HTTP API (POST)
- Merge: merges the data from its input branches
- Prepare Submission Fields (Edit Fields (Set)): sets 2 fields: user_id, Yesterday's Plans
- Send EOD Prompt to Slack (Slack): uses Slack
- If: checks a condition and branches into true / false
…plus 9 more steps. See the full node list below.
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Slack
n8n-nodes-base.slack - Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Aggregate
n8n-nodes-base.aggregate
From the author
Quick overview Youtube Video: https://youtu.be/AbkX2splTTg?si=LTHqLFIWQD4hAYsO This workflow collects end-of-day updates from team members in Slack, stores them in Google Sheets, and posts a concise executive summary back to Slack using Google Gemini. How it…