{
  "name": "Automate event registration and reminder emails with Forms, Sheets & Gmail",
  "nodes": [
    {
      "id": "84619214-27ec-4fdd-ad5d-b1ff93c1636c",
      "name": "Read Existing Registrations2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        608,
        2368
      ]
    },
    {
      "id": "e77b0f4a-3ed7-4e7e-ab7b-eb88764aa99b",
      "name": "If Not Duplicate2",
      "type": "n8n-nodes-base.if",
      "position": [
        1040,
        2368
      ]
    },
    {
      "id": "a53b6c74-2983-45d5-ae27-bd9607c65356",
      "name": "Event Registration Form3",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -224,
        2368
      ]
    },
    {
      "id": "1956a1a2-0605-4996-8ac1-301991383cb8",
      "name": "Check for Duplicate Email2",
      "type": "n8n-nodes-base.code",
      "position": [
        800,
        2368
      ]
    },
    {
      "id": "cdab6e67-08a1-435e-b9dd-b7491c8b9df9",
      "name": "Check Registration Success3",
      "type": "n8n-nodes-base.if",
      "position": [
        1776,
        2336
      ]
    },
    {
      "id": "2260a659-8443-4665-a0bf-b25b7c404d46",
      "name": "Send Welcome Email3",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2032,
        2240
      ]
    },
    {
      "id": "b0f144c8-b8f7-4a5a-97b6-2eeb0aa09dc1",
      "name": "Update Welcome Email Status3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2560,
        2240
      ]
    },
    {
      "id": "46d2e1d6-ce69-461c-962c-62651d8af59d",
      "name": "Store Registration (Google Sheets)3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1280,
        2272
      ]
    },
    {
      "id": "dba5c770-e4b5-43c6-b16b-f5a01fc8cdde",
      "name": "Send Admin Alert3",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2032,
        2416
      ]
    },
    {
      "id": "22680c89-073d-40f8-8e9c-7701241a3a18",
      "name": "Code in JavaScript4",
      "type": "n8n-nodes-base.code",
      "position": [
        2288,
        2240
      ]
    },
    {
      "id": "7f5149be-7295-4075-af7e-62b09567f8bc",
      "name": "Add Status & Event Date3",
      "type": "n8n-nodes-base.set",
      "position": [
        1536,
        2336
      ]
    },
    {
      "id": "fe122d0e-6cbe-4743-a663-1b58e4fe7fac",
      "name": "Get Confirmed Aptitude Candidates2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        576,
        2848
      ]
    },
    {
      "id": "aedbc6ad-c34e-4631-8b4c-417b71a07217",
      "name": "Filter Reminder Candidates2",
      "type": "n8n-nodes-base.code",
      "position": [
        832,
        2848
      ]
    },
    {
      "id": "a38a55b9-0dcd-48a3-8eb7-066668f3bcb0",
      "name": "Switch Reminder Type2",
      "type": "n8n-nodes-base.switch",
      "position": [
        1072,
        2848
      ]
    },
    {
      "id": "6f595286-b68e-4af2-9c4b-b23ca19e73d5",
      "name": "Loop 3-Day2",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1584,
        2688
      ]
    },
    {
      "id": "a5cb7979-b97f-4514-8f8e-0487d70c592a",
      "name": "Send 3-Day Reminder2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1824,
        2688
      ]
    },
    {
      "id": "d07fca2b-5352-482d-a3aa-ec02a02fb9c9",
      "name": "Wait5",
      "type": "n8n-nodes-base.wait",
      "position": [
        2304,
        2688
      ]
    },
    {
      "id": "b4dfe64c-1d83-4e82-a199-16530b2b3d9c",
      "name": "Loop Event-Day2",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1584,
        2928
      ]
    },
    {
      "id": "73248631-1749-4fc2-9d84-609a4bf486ff",
      "name": "Send Event-Day Reminder2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1824,
        2928
      ]
    },
    {
      "id": "133b5b42-3ef9-4fc8-87db-88fae58b7d39",
      "name": "Wait6",
      "type": "n8n-nodes-base.wait",
      "position": [
        2304,
        2928
      ]
    },
    {
      "id": "2fe1e490-bfa2-4ea9-84c7-ffc0c9ed7205",
      "name": "Prepare 3-Day Update2",
      "type": "n8n-nodes-base.code",
      "position": [
        2064,
        2688
      ]
    },
    {
      "id": "ff7107a5-c96b-4c86-8519-9bc567dfb19e",
      "name": "Prepare Event-Day Update2",
      "type": "n8n-nodes-base.code",
      "position": [
        2064,
        2928
      ]
    },
    {
      "id": "1117508c-d3f4-42f3-9a75-5c44d573e319",
      "name": "Update Event-Day Status2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2544,
        2928
      ]
    },
    {
      "id": "2a2f7f9a-a86b-4faa-b4eb-5efc358aa650",
      "name": "Update 3-Day Status3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2528,
        2688
      ]
    },
    {
      "id": "68cdbd91-df76-4831-953f-cca014a5d8d6",
      "name": "Schedule Trigger2",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -240,
        2848
      ]
    },
    {
      "id": "4c7c9e52-5257-4fba-8609-1e7002ab6152",
      "name": "Edit Fields4",
      "type": "n8n-nodes-base.set",
      "position": [
        0,
        2368
      ]
    },
    {
      "id": "0b7a74ca-c1bf-46ff-a150-564e71fb3869",
      "name": "Edit Fields5",
      "type": "n8n-nodes-base.set",
      "position": [
        -32,
        2848
      ]
    },
    {
      "id": "cbe773e8-0fe4-402c-a258-fbcd1822cee6",
      "name": "Switch2",
      "type": "n8n-nodes-base.switch",
      "position": [
        304,
        2672
      ]
    },
    {
      "id": "35f7afdb-902e-4e83-b1b1-8bb8ab6dba85",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        2112
      ],
      "parameters": {
        "width": 880,
        "height": 1024,
        "content": "## Event Registration Automation with Email Workflow\nThis automation manages the complete event registration lifecycle—from form submission to event day reminders. It prevents duplicate registrations,"
      }
    },
    {
      "id": "89f1765f-1d79-4b44-9282-2f2ee34fece1",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        2112
      ],
      "parameters": {
        "width": 1744,
        "height": 448,
        "content": "## Step 1: Capture and Process Registration\nWhen a user submits the event registration form, the workflow first verifies the submission using a Switch node if the form is submitted. It then checks whe"
      }
    },
    {
      "id": "dd1f38d9-a2c1-4189-8c66-9683027799fa",
      "name": "Sticky Note12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1504,
        2112
      ],
      "parameters": {
        "width": 1312,
        "height": 448,
        "content": "## Step 2: Confirm Registration and Send Notifications\nAfter the registration data is stored, the system assigns a confirmed status and event date to the entry. It then checks whether the registration"
      }
    },
    {
      "id": "837d8655-8090-4c8d-8cd9-c77e99f94fff",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        2576
      ],
      "parameters": {
        "width": 1536,
        "height": 560,
        "content": "## Step 3: Scheduled Trigger and Reminder Routing\nWhen the schedule trigger runs, the workflow first uses a Switch node to confirm the execution source is the scheduled run and not a form submission. "
      }
    },
    {
      "id": "15082637-439f-47ad-af52-1f39dc2045f4",
      "name": "Sticky Note14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1296,
        2576
      ],
      "parameters": {
        "width": 1520,
        "height": 560,
        "content": "## Step 4: Send Reminders and Update Event Communication Status\nOnce reminder candidates are identified, the workflow processes them in batches to avoid overload. Attendees scheduled for a 3-day remin"
      }
    }
  ],
  "connections": {
    "Wait5": {
      "main": [
        [
          {
            "node": "Update 3-Day Status3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait6": {
      "main": [
        [
          {
            "node": "Update Event-Day Status2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch2": {
      "main": [
        [
          {
            "node": "Read Existing Registrations2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get Confirmed Aptitude Candidates2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop 3-Day2": {
      "main": [
        [],
        [
          {
            "node": "Send 3-Day Reminder2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields4": {
      "main": [
        [
          {
            "node": "Switch2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields5": {
      "main": [
        [
          {
            "node": "Switch2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Event-Day2": {
      "main": [
        [],
        [
          {
            "node": "Send Event-Day Reminder2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If Not Duplicate2": {
      "main": [
        [
          {
            "node": "Store Registration (Google Sheets)3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger2": {
      "main": [
        [
          {
            "node": "Edit Fields5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code in JavaScript4": {
      "main": [
        [
          {
            "node": "Update Welcome Email Status3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Welcome Email3": {
      "main": [
        [
          {
            "node": "Code in JavaScript4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send 3-Day Reminder2": {
      "main": [
        [
          {
            "node": "Prepare 3-Day Update2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update 3-Day Status3": {
      "main": [
        [
          {
            "node": "Loop 3-Day2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare 3-Day Update2": {
      "main": [
        [
          {
            "node": "Wait5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch Reminder Type2": {
      "main": [
        [
          {
            "node": "Loop 3-Day2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Event-Day2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Status & Event Date3": {
      "main": [
        [
          {
            "node": "Check Registration Success3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Event Registration Form3": {
      "main": [
        [
          {
            "node": "Edit Fields4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Event-Day Reminder2": {
      "main": [
        [
          {
            "node": "Prepare Event-Day Update2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Event-Day Status2": {
      "main": [
        [
          {
            "node": "Loop Event-Day2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Event-Day Update2": {
      "main": [
        [
          {
            "node": "Wait6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check for Duplicate Email2": {
      "main": [
        [
          {
            "node": "If Not Duplicate2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Registration Success3": {
      "main": [
        [
          {
            "node": "Send Welcome Email3",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Admin Alert3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Reminder Candidates2": {
      "main": [
        [
          {
            "node": "Switch Reminder Type2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Existing Registrations2": {
      "main": [
        [
          {
            "node": "Check for Duplicate Email2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Confirmed Aptitude Candidates2": {
      "main": [
        [
          {
            "node": "Filter Reminder Candidates2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Registration (Google Sheets)3": {
      "main": [
        [
          {
            "node": "Add Status & Event Date3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}