Track Zoom attendance and create AI summaries with Google Sheets, ClickUp and Telegram
Needs changesWhat this workflow does
This AI workflow has 12 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, OpenAI Chat Model, ClickUp and Telegram.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- 2. Set — Config Values (Edit Fields (Set)): sets 6 fields: telegramChatId, sheetId, sheetName…
- 3. Code — Extract and Classify Participants (Code): runs custom JavaScript code
- 4. Google Sheets — Log Participant Row (Google Sheets): append
- 5. IF — First Row Check (If): checks a condition and branches into true / false
- 6. AI Agent — Write Telegram Summary (AI Agent): runs an AI agent, with model: 7. OpenAI — GPT-4o-mini Model
- 8. IF — Is Participant Late? (If): checks a condition and branches into true / false
- 11. Set — Prepare Telegram Fields (Edit Fields (Set)): sets 2 fields: telegramMessage, telegramChatId
- 9. ClickUp — Create Late Participant Task (ClickUp): uses ClickUp
- 10. Set — No Action Needed (Edit Fields (Set)): sets 3 fields: result, participantName, status
- 12. Telegram — Send Meeting Summary (Telegram): uses Telegram
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in 6. AI Agent — Write Telegram Summary (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) 6. AI Agent — Write Telegram Summary (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - ClickUp
n8n-nodes-base.clickUp - Telegram
n8n-nodes-base.telegram
From the author
Description When a Zoom meeting ends, this workflow fires automatically — no manual action needed. It classifies every participant as On Time or Late, logs all attendance data to Google Sheets, and sends you one AI-written summary via Telegram. For every late…