Automation library · Alerts and monitoring

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
35 stepsLarge: read it before trusting it with anything live
5Branches: places the flow splits
3Loops or waits
3Services it connects to

The flow

Starts it 5Logic 10Service 20

The steps in the order they run, from what starts it.

  1. 1Webhook1 - org1WebhookStarts it
  2. 2When clicking ‘Execute workflow’Manual triggerStarts it
  3. 3Webhook3 - org3WebhookStarts it
  4. 4Webhook2 - org2WebhookStarts it
  5. 5Telegram TriggerTelegram triggerStarts it
  6. 6Get row(s) in sheetGoogle SheetsService
  7. 7Get row(s) in sheet2Google SheetsService
  8. 8Get row(s) in sheet4Google SheetsService
  9. 9Get row(s) in sheet1Google SheetsService
  10. 10SwitchSwitchLogic
  11. 11IfIfLogic
  12. 12Loop Over ItemsSplit In BatchesLogic
  13. 13MergeMergeLogic
  14. 14If3IfLogic
  15. 15If1IfLogic
  16. 16Get row(s) in sheet3Google SheetsService
  17. 17sign attendance ✅Google SheetsService
  18. 18QR CODE INVALID ❌TelegramService
  19. 19Generate QR Code [based on ID]Http RequestService
  20. 20SummarizeSummarizeService
  21. 21sign attendance ✅2Google SheetsService
  22. 22QR CODE INVALID ❌2TelegramService
  23. 23sign attendance ✅1Google SheetsService
  24. 24QR CODE INVALID ❌1TelegramService
  25. 25Loop Over Items1Split In BatchesLogic
  26. 26QR CODE VALID ✅TelegramService
  27. 27WaitWaitLogic
  28. 28send update to admin1TelegramService
  29. 29QR CODE VALID ✅2TelegramService
  30. 30QR CODE VALID ✅1TelegramService
  31. 31No Operation, do nothingNo OpLogic
  32. 32If2IfLogic
  33. 33Send a messageGmailService
  34. 34print absent name + phone numberTelegramService
  35. 35no absents [ feedback ]TelegramService

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.