Track Zoom attendance and create AI summaries with Google Sheets, ClickUp and Telegram

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 joiner, a ClickUp follow-up task is created automatically so no one slips through the cracks. Built for team leads, trainers, and operations managers who run recurring Zoom meetings.

---

What This Workflow Does

- Automatic attendance capture — Receives the Zoom meeting.ended event via webhook and processes all participant data instantly, with zero manual input - Late participant detection — Classifies each attendee as Attended or Late based on a configurable join delay threshold (default: 5 minutes) - 14-column Google Sheets log — Saves every participant as one row including join time, leave time, time in meeting, join delay, and status - AI-written Telegram summary — GPT-4o-mini writes a professional attendance summary and sends it once per meeting directly to the host's Telegram - Automated ClickUp follow-up tasks — Creates one ClickUp task per late joiner with full meeting context, participant details, and a next-day due date - Clean exit for on-time attendees — Participants who joined on time bypass the task creation step with no noise or extra actions

---

Setup Requirements

Tools and accounts needed