# Manage on-campus event attendance with Google Sheets: n8n workflow > Started by an incoming Telegram message, and works across Gmail, Google Sheets and Telegram. Source: https://millionrounds.com/workflow/manage-on-campus-event-attendance-with-google-sheets (Millionrounds; every figure on the page links to its filing or article) [Automation library](https://millionrounds.com/workflows) · [Alerts and monitoring](https://millionrounds.com/workflows?category=Alerts+and+monitoring#library) # Manage on-campus event attendance with Google Sheets Started by an incoming Telegram message, and works across Gmail, Google Sheets and Telegram. 35 steps, 5 branches, 3 loops or waits: large, and worth reading before you trust it with anything live. Large [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fmanage-on-campus-event-attendance-with-google-sheets) **35 steps** Large: read it before trusting it with anything live **5** Branches: places the flow splits **3** Loops or waits **3** Services it connects to ## The flow Starts it 5 Logic 10 Service 20 The steps in the order they run, from what starts it. - 1 **Webhook1 - org1** Webhook *Starts it* - 2 **When clicking ‘Execute workflow’** Manual trigger *Starts it* - 3 **Webhook3 - org3** Webhook *Starts it* - 4 **Webhook2 - org2** Webhook *Starts it* - 5 **Telegram Trigger** Telegram trigger *Starts it* - 6 **Get row(s) in sheet** Google Sheets *Service* - 7 **Get row(s) in sheet2** Google Sheets *Service* - 8 **Get row(s) in sheet4** Google Sheets *Service* - 9 **Get row(s) in sheet1** Google Sheets *Service* - 10 **Switch** Switch *Logic* - 11 **If** If *Logic* - 12 **Loop Over Items** Split In Batches *Logic* - 13 **Merge** Merge *Logic* - 14 **If3** If *Logic* - 15 **If1** If *Logic* - 16 **Get row(s) in sheet3** Google Sheets *Service* - 17 **sign attendance ✅** Google Sheets *Service* - 18 **QR CODE INVALID ❌** Telegram *Service* - 19 **Generate QR Code [based on ID]** Http Request *Service* - 20 **Summarize** Summarize *Service* - 21 **sign attendance ✅2** Google Sheets *Service* - 22 **QR CODE INVALID ❌2** Telegram *Service* - 23 **sign attendance ✅1** Google Sheets *Service* - 24 **QR CODE INVALID ❌1** Telegram *Service* - 25 **Loop Over Items1** Split In Batches *Logic* - 26 **QR CODE VALID ✅** Telegram *Service* - 27 **Wait** Wait *Logic* - 28 **send update to admin1** Telegram *Service* - 29 **QR CODE VALID ✅2** Telegram *Service* - 30 **QR CODE VALID ✅1** Telegram *Service* - 31 **No Operation, do nothing** No Op *Logic* - 32 **If2** If *Logic* - 33 **Send a message** Gmail *Service* - 34 **print absent name + phone number** Telegram *Service* - 35 **no absents [ feedback ]** Telegram *Service* ## How it's built - **Starts on:** An incoming Telegram message - **Steps:** 35, with 5 branches, 3 loops or waits - **Size:** Large: read it before trusting it with anything live - **Connects to:** Gmail, Google Sheets, Telegram - **Model:** None. This is plumbing, not judgement ## Questions What does it need to run? An n8n account, plus your own Gmail, Google Sheets and Telegram accounts. You connect your own accounts after importing it; none are included. What starts it? It starts on an incoming Telegram message. Does it use AI? No. Every step is fixed logic or a call to a service, so it does the same thing every time. How long does it take to set up? Take your time. At 35 steps it is large: read it before trusting it with anything live. How do I import it? Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts. **Before you run it** Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 35 steps before you point it at anything that matters. ## Run it in n8n - **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n) - **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fmanage-on-campus-event-attendance-with-google-sheets) - **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts. Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind. ## Connects to Each opens the other workflows that use it. [Gmail](https://millionrounds.com/workflows?service=Gmail#library)[Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library)[Telegram](https://millionrounds.com/workflows?service=Telegram#library) ## Workflows like it Also alerts and monitoring, with the same services where possible, closest in size first. - [**Onboard frontline workers with Telegram and DeepSeek** 35 steps · Notion, Telegram](https://millionrounds.com/workflow/onboard-frontline-workers-with-telegram-and-deepseek) - [**Manage Supabase database records with Telegram** 34 steps · Supabase, Telegram](https://millionrounds.com/workflow/manage-supabase-database-records-with-telegram) - [**Meta ads bulk launcher with Google Drive and Slack** 34 steps · Google Drive, Google Sheets](https://millionrounds.com/workflow/meta-ads-bulk-launcher-with-google-drive-and-slack) - [**Sync HubSpot contacts with LinkedIn URLs** 36 steps · Gmail, Google Sheets](https://millionrounds.com/workflow/sync-hubspot-contacts-with-linkedin-urls) - [**Create and optimize B2B LinkedIn AI posts with Groq** 34 steps · calls a model · LinkedIn, Telegram](https://millionrounds.com/workflow/create-and-optimize-b2b-linkedin-ai-posts-with-groq) - [**Monitor IP conflicts and governance with OpenAI and Slack** 34 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/monitor-ip-conflicts-and-governance-with-openai-and-slack)