Automation library · Scheduling

Automate event registration and reminder emails with Forms

Started by someone submitting a form, and works across Gmail and Google Sheets. 28 steps, 4 branches, 4 loops or waits: large, and worth reading before you trust it with anything live.

Large

Download free
28 stepsLarge: read it before trusting it with anything live
4Branches: places the flow splits
4Loops or waits
2Services it connects to

The flow

Starts it 2Logic 16Service 10

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

  1. 1Event Registration Form3Form triggerStarts it
  2. 2Schedule Trigger2Schedule triggerStarts it
  3. 3Edit Fields4SetLogic
  4. 4Edit Fields5SetLogic
  5. 5Switch2SwitchLogic
  6. 6Read Existing Registrations2Google SheetsService
  7. 7Get Confirmed Aptitude Candidates2Google SheetsService
  8. 8Check for Duplicate Email2CodeLogic
  9. 9Filter Reminder Candidates2CodeLogic
  10. 10If Not Duplicate2IfLogic
  11. 11Switch Reminder Type2SwitchLogic
  12. 12Store Registration (Google Sheets)3Google SheetsService
  13. 13Loop 3-Day2Split In BatchesLogic
  14. 14Loop Event-Day2Split In BatchesLogic
  15. 15Add Status & Event Date3SetLogic
  16. 16Send 3-Day Reminder2GmailService
  17. 17Send Event-Day Reminder2GmailService
  18. 18Check Registration Success3IfLogic
  19. 19Prepare 3-Day Update2CodeLogic
  20. 20Prepare Event-Day Update2CodeLogic
  21. 21Send Welcome Email3GmailService
  22. 22Send Admin Alert3GmailService
  23. 23Wait5WaitLogic
  24. 24Wait6WaitLogic
  25. 25Code in JavaScript4CodeLogic
  26. 26Update 3-Day Status3Google SheetsService
  27. 27Update Event-Day Status2Google SheetsService
  28. 28Update Welcome Email Status3Google SheetsService

How it's built

Starts on
Someone submitting a form
Steps
28, with 4 branches, 4 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Gmail and Google Sheets accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on someone submitting a form.

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 28 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 28 steps before you point it at anything that matters.