Daily team progress checks & reports with Slack, ChatGPT and Google Sheets
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Function (legacy), Cron. 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets, Slack and OpenAI.
How it runs
Trigger: On a schedule (legacy Cron node).
- Get Project WBS (Google Sheets): uses Google Sheets
- Filter Uncompleted Tasks (If): checks a condition and branches into true / false
- Group Member Info (Function): runs custom JavaScript (legacy Function node)
- Agent: Update task status reminders (OpenAI): uses OpenAI
- Send Messages to Members (Slack): uses Slack
- Wait: pauses before continuing
- Agent: Compile Report Summary (OpenAI): uses OpenAI
- Generate Daily Report (Function): runs custom JavaScript (legacy Function node)
- Send Report to Client (Slack): uses Slack
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Function (legacy) in Group Member Info, Generate Daily Report: replace with Code node, mode 'Run Once for All Items'.
- Cron in Start Daily at 17:00: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Group Member Info, Generate Daily Report | Code node, mode 'Run Once for All Items' |
| Cron Start Daily at 17:00 | Schedule Trigger |
Nodes used (7)
- Function
n8n-nodes-base.function - Cron
n8n-nodes-base.cron - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Wait
n8n-nodes-base.wait - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Overview This workflow is a daily progress check flow that runs automatically at 17:00. It integrates Google Sheets, Slack, and ChatGPT to automate progress inquiries to team members and generate daily reports. --- Overall Workflow Steps Triggered every day…