{
  "name": "Real-time registration form tracking with Google Sheets and Gmail notifications",
  "nodes": [
    {
      "id": "6129a28e-055e-4355-8b3d-412cd2b21baf",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -496,
        -848
      ]
    },
    {
      "id": "939ffb5e-d5ba-4ddd-a34a-b5db3f8be956",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -496,
        -656
      ]
    },
    {
      "id": "9019ab48-1b0e-497a-bba6-50727a8664c9",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        -48,
        -752
      ]
    },
    {
      "id": "751e83f2-92e9-4ca2-80fe-51926866f07e",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        -272,
        -752
      ]
    },
    {
      "id": "ab22e315-f457-4c6a-b143-3e5795b25275",
      "name": "Respond to Webhook",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        176,
        -736
      ]
    },
    {
      "id": "1d83a5bf-9c03-4c8b-8478-1ae605e24e3d",
      "name": "Webhook1",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -720,
        -752
      ]
    },
    {
      "id": "54808873-11d8-44fa-8429-42cabbfa2b5c",
      "name": "Webhook - send-acknowledgements",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -240,
        -336
      ]
    },
    {
      "id": "b8895288-5239-43f4-95b3-48d208bab533",
      "name": "Google Sheets - Student List",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        32,
        -496
      ]
    },
    {
      "id": "410063fe-d634-4db6-b2c6-c31bc239fc57",
      "name": "Code - Prepare Messages",
      "type": "n8n-nodes-base.code",
      "position": [
        480,
        -400
      ]
    },
    {
      "id": "555aad64-769d-4e5a-95ae-65badd883d4d",
      "name": "Respond - Confirmation",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        928,
        -400
      ]
    },
    {
      "id": "f7170ea9-81c5-4602-a9f6-e1d85830694e",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        704,
        -400
      ]
    },
    {
      "id": "7fa0622b-4f27-4eb2-96d3-1f6a8a96d983",
      "name": "Google Sheets FormResponses",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        32,
        -304
      ]
    },
    {
      "id": "384d999b-d603-4a1e-ad58-6a055a2b26c4",
      "name": "Merge1",
      "type": "n8n-nodes-base.merge",
      "position": [
        256,
        -400
      ]
    },
    {
      "id": "1bf63625-8f0d-4f2c-a6ea-08dcb50dc1ad",
      "name": "Google Sheets - FormResponses",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        16,
        208
      ]
    },
    {
      "id": "199c5e4a-514f-4c51-8568-d5aec1c0c3ea",
      "name": "Webhook - send-acknowledgements1",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -208,
        112
      ]
    },
    {
      "id": "cb8662bb-0224-43c5-9596-36428dbc539f",
      "name": "Google Sheets - Student List1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        16,
        16
      ]
    },
    {
      "id": "693ec31d-f225-4533-800f-870cdc838c59",
      "name": "Code - Prepare Messages1",
      "type": "n8n-nodes-base.code",
      "position": [
        464,
        112
      ]
    },
    {
      "id": "f17a315f-b0f1-4c2a-b482-cb6ccc627140",
      "name": "Respond - Confirmation1",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        912,
        112
      ]
    },
    {
      "id": "a6e673c1-677d-4657-b237-095960f5c0c1",
      "name": "Send a message1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        688,
        112
      ]
    },
    {
      "id": "f1e66b06-43e4-456f-b7e8-a7afb247b752",
      "name": "Merge2",
      "type": "n8n-nodes-base.merge",
      "position": [
        240,
        112
      ]
    },
    {
      "id": "246db6a2-f974-48b9-85f9-c140a4b52ddf",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        -944
      ],
      "parameters": {
        "width": 1360,
        "height": 448,
        "content": "Gracewell Automated Registration Tracker Suite"
      }
    },
    {
      "id": "64153acd-c102-46be-9e71-2154dcb560d8",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        -480
      ],
      "parameters": {
        "width": 1520,
        "height": 320,
        "content": " Workflow 2: Send Acknowledgements"
      }
    },
    {
      "id": "7e4346b8-b5e8-4f96-a85b-02a4bab9d1af",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -288,
        -32
      ],
      "parameters": {
        "width": 1456,
        "height": 400,
        "content": " Workflow 3: Send Reminders"
      }
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge1": {
      "main": [
        [
          {
            "node": "Code - Prepare Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge2": {
      "main": [
        [
          {
            "node": "Code - Prepare Messages1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook1": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Respond - Confirmation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message1": {
      "main": [
        [
          {
            "node": "Respond - Confirmation1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Respond to Webhook": {
      "main": [
        []
      ]
    },
    "Code - Prepare Messages": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code - Prepare Messages1": {
      "main": [
        [
          {
            "node": "Send a message1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets FormResponses": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Google Sheets - Student List": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets - FormResponses": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Google Sheets - Student List1": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook - send-acknowledgements": {
      "main": [
        [
          {
            "node": "Google Sheets - Student List",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets FormResponses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook - send-acknowledgements1": {
      "main": [
        [
          {
            "node": "Google Sheets - Student List1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets - FormResponses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}