{
  "name": "Automate multi-step onboarding with Google Sheets, Forms and Gmail notifications",
  "nodes": [
    {
      "id": "bdb2c014-ce81-4e05-bfd1-e6ca9a42fb0f",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -2240,
        2462
      ]
    },
    {
      "id": "73376d8c-21d3-47b3-af14-3872147ce7af",
      "name": "Generate message table",
      "type": "n8n-nodes-base.code",
      "position": [
        -1800,
        2362
      ]
    },
    {
      "id": "46747e54-1288-4887-aa08-d37cc835f57e",
      "name": "Read MSG status Rows",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1580,
        2362
      ]
    },
    {
      "id": "0d67cbd3-d0f5-45a7-9057-289a97be871a",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2240,
        2262
      ]
    },
    {
      "id": "2526926e-8a12-4e5c-a588-03e9f03bb334",
      "name": "If completed4",
      "type": "n8n-nodes-base.if",
      "position": [
        -260,
        2562
      ]
    },
    {
      "id": "75188ae4-001c-4a84-89fd-b9d9f3d9f608",
      "name": "Form",
      "type": "n8n-nodes-base.form",
      "position": [
        -1800,
        1860
      ]
    },
    {
      "id": "2db39637-6703-4691-ad62-1aabb8429357",
      "name": "Save registration Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2020,
        1860
      ]
    },
    {
      "id": "824c1b36-bff3-4165-821a-9e2425c0a067",
      "name": "Read Messages",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2020,
        2362
      ]
    },
    {
      "id": "d3dcba73-305b-4faf-94ae-8f6d53a9f708",
      "name": "Update row to completed",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -260,
        2120
      ]
    },
    {
      "id": "8a89a0c4-0dae-4139-91c3-b05678722d10",
      "name": "Do some action",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -700,
        2220
      ]
    },
    {
      "id": "e336dac1-00e4-4149-8e00-d3e207a99549",
      "name": "Check if action done",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -700,
        2562
      ]
    },
    {
      "id": "159ebeb8-efc0-4489-be43-7fe7e05597ca",
      "name": "Create next step",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        400,
        2462
      ]
    },
    {
      "id": "082323c8-a6ec-475d-ad37-74df2cad4757",
      "name": "Send message",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        -2240,
        2960
      ]
    },
    {
      "id": "fccbeab1-3536-409a-b68a-4bcf63a14f05",
      "name": "Gmail2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -1800,
        2960
      ]
    },
    {
      "id": "15c53cfe-963c-4ff3-8126-204c9c01f00e",
      "name": "Send msg to user",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        -480,
        2220
      ]
    },
    {
      "id": "17b9e0b9-9be8-4086-86d2-6b5f3e43096e",
      "name": "Send msg to admin",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        -260,
        2320
      ]
    },
    {
      "id": "a007cd85-93d8-48bb-8921-ffdb5b653491",
      "name": "Send msg to user1",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        -40,
        2462
      ]
    },
    {
      "id": "9fc1fc41-0776-4fc5-a4c1-efc5129e3b12",
      "name": "Set variables",
      "type": "n8n-nodes-base.set",
      "position": [
        -1360,
        2362
      ]
    },
    {
      "id": "72bd115d-d8ec-43d4-93d0-bbd3eedbbba1",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        -2020,
        2960
      ]
    },
    {
      "id": "99146b8e-8f06-4c1c-94ff-abf68cf2fa29",
      "name": "Send msg to admin1",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        -40,
        2662
      ]
    },
    {
      "id": "691dc84a-67aa-4df2-9ccf-43b24ef21a4d",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2300,
        1680
      ],
      "parameters": {
        "width": 680,
        "height": 340,
        "content": "## This is the starting point\n- You can send the link by email to the person\n- On ce it will fill it it will create the Step 1"
      }
    },
    {
      "id": "fe9f14e5-6ddf-4354-9596-d4cb3f933664",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        -920,
        2178
      ]
    },
    {
      "id": "7fef0239-7179-4ac2-8b6b-df3e0ff68ba6",
      "name": "Switch1",
      "type": "n8n-nodes-base.switch",
      "position": [
        -920,
        2520
      ]
    },
    {
      "id": "add73124-2a49-4b9b-b732-ff51c519b631",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -980,
        2060
      ],
      "parameters": {
        "width": null,
        "height": 340,
        "content": "## Case setting \nHere you can set the distinct action for each step"
      }
    },
    {
      "id": "6ad12fb7-9e21-443a-bc2a-1f3f582fbe95",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -980,
        2420
      ],
      "parameters": {
        "width": null,
        "height": 400,
        "content": "## Case setting \nHere you can set the distinct verifications for each step"
      }
    },
    {
      "id": "e25b6577-80ef-4419-ba65-8d7baa5c7bb4",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2300,
        2040
      ],
      "parameters": {
        "width": 2940,
        "height": 800,
        "content": "## Main workflow\n"
      }
    },
    {
      "id": "61697f64-a7f5-44b3-97f2-aa99104d61e0",
      "name": "Switch type of step",
      "type": "n8n-nodes-base.switch",
      "position": [
        -1140,
        2362
      ]
    },
    {
      "id": "c35de795-5fc3-4e6d-a87b-a98d467e7f74",
      "name": "Debug mode set result",
      "type": "n8n-nodes-base.set",
      "position": [
        -480,
        2562
      ]
    },
    {
      "id": "3d3ce9ce-83d1-4e07-8f09-a4248e9e8759",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2300,
        2860
      ],
      "parameters": {
        "width": 680,
        "height": 260,
        "content": "## Sub Workflow \n- replace the variables enclosed in {{ }} by its corresponding value set in \"Set variables node\".\n- Send messages, here you can set a slack or telegram nessage"
      }
    },
    {
      "id": "e0a9ac24-c20a-4209-a896-55da6dd158e3",
      "name": "Update row to passed",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        180,
        2460
      ]
    },
    {
      "id": "9d5ca28d-01a3-405c-a3a9-f9de83ba174e",
      "name": "Registration",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -2240,
        1860
      ]
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Gmail2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Do some action",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Do some action",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Do some action",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Do some action",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Do some action",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch1": {
      "main": [
        [
          {
            "node": "Check if action done",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Check if action done",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Check if action done",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Check if action done",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Check if action done",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Registration": {
      "main": [
        [
          {
            "node": "Save registration Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send message": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If completed4": {
      "main": [
        [
          {
            "node": "Send msg to user1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send msg to admin1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Messages": {
      "main": [
        [
          {
            "node": "Generate message table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set variables": {
      "main": [
        [
          {
            "node": "Switch type of step",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Do some action": {
      "main": [
        [
          {
            "node": "Send msg to user",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create next step": {
      "main": [
        []
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Read Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send msg to user": {
      "main": [
        [
          {
            "node": "Update row to completed",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send msg to admin",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send msg to user1": {
      "main": [
        [
          {
            "node": "Update row to passed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch type of step": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Switch1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if action done": {
      "main": [
        [
          {
            "node": "Debug mode set result",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read MSG status Rows": {
      "main": [
        [
          {
            "node": "Set variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row to passed": {
      "main": [
        [
          {
            "node": "Create next step",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Debug mode set result": {
      "main": [
        [
          {
            "node": "If completed4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate message table": {
      "main": [
        [
          {
            "node": "Read MSG status Rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save registration Data": {
      "main": [
        [
          {
            "node": "Form",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row to completed": {
      "main": [
        []
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Read Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}