Automated Multi-Step Onboarding using Google Sheets and Gmail - n8n Workflow

SaaS Operations Teams: Who need reliable, traceable onboarding sequences.
HR and Training Departments: Automating compliance and training step delivery.
Advanced n8n Users: Looking for highly structured, data-driven automation examples.
Developers/Administrators: Seeking efficient ways to manage customer lifecycles using an n8n workflow.

Managing multi-step processes like customer or employee onboarding can become complex quickly, often relying on manual tracking and generic emails. This advanced n8n workflow solves this by implementing a powerful, data-driven state machine. It leverages Google Sheets to store both user status and standardized message templates, allowing administrators to modify content and steps without changing the core n8n node logic.

The system is initiated when a user registers via an n8n Form. Subsequently, a scheduled n8n trigger periodically checks the status of every user. Based on their current 'step' and 'status' (e.g., sent, completed, passed), the n8n workflow dynamically determines the next action, such as sending the next phase email via Gmail or verifying if the previous action was completed. This ensures highly personalized, conditional progression through your automated sequences, making this n8n template invaluable for robust automation.

This automation operates using two main components: a Registration Trigger and a Scheduled Main Loop.

1. Registration and Initial State

1. The Registration n8n node, an n8n Form Trigger, captures new user data (Name, Email).


2. The data is immediately written to a Google Sheet (the status sheet) using the Save registration Data n8n node, initiating the user at step: 1 and status: sent.

2. Scheduled Onboarding Loop

1. The loop is activated either manually (When clicking ‘Execute workflow’) or periodically by the disabled Schedule Trigger n8n trigger.


2. The n8n workflow first retrieves all standardized message templates from a dedicated Google Sheet via the Read Messages n8n node.


3. The Generate message table Code n8n node processes these templates into a structured object for easy lookups.


4. The Read MSG status Rows n8n node fetches all users' current statuses from the status sheet.


5. For each user, the Set variables n8n node prepares personalized data (like derived company email addresses).


6. The Switch type of step n8n node routes the flow based on the user's current status:

To install and deploy this complex n8n workflow, follow these steps:

1. Import: Copy the provided JSON data and paste it into your n8n instance using the 'Import Workflow' feature.


2. Google Sheets Setup: You need two Google Sheets accounts/credentials connected:

1. Credential Configuration: Update the Google Sheets credentials in the Read Messages, Read MSG status Rows, Save registration Data, Update row to completed, Update row to passed, and Create next step n8n node instances.


2. Gmail Configuration: Ensure the Gmail2 n8n node (located in the sub-workflow) has valid Gmail OAuth2 credentials for sending emails.


3. Sub-Workflow ID: Note that the main workflow uses the Execute Workflow n8n node (Send msg to user, Send msg to admin, etc.) which requires the Sub-Workflow ID (EORpbQwSc80AYgSs). Ensure the sub-workflow is saved and its ID is correctly referenced in the main nodes, or use the 'Export/Import Workflows' feature to ensure linkages are maintained.


4. Activation: Activate both the main n8n workflow (e.g., set the Schedule Trigger to active) and the message sub-workflow.

Registration (Form Trigger n8n trigger): The entry point. It hosts an n8n web form to capture initial user data, automatically setting the hidden fields step to '1' and status to 'sent'.
Save registration Data (Google Sheets n8n node): Appends the newly registered user's details to the tracking Google Sheet.
Schedule Trigger (n8n trigger): Configured (though disabled) to run the main check loop periodically (e.g., every minute) to process pending onboarding steps.
Read Messages (Google Sheets n8n node): Reads the master table containing all email subjects, content bodies, step numbers, and message types (sent, completed, error).
Generate message table (Code n8n node): Essential custom n8n node that aggregates and structures the message template data based on step and Type for easy dynamic lookups later in the n8n workflow.
Switch type of step (Switch n8n node): The first conditional check. It determines if the user is pending action ('sent') or pending verification ('completed').
Switch / Switch1 (Switch n8n node): These separate n8n node instances route the flow based on the current step number (1 through 5), enabling step-specific logic (action or verification).
Send msg to user (Execute Workflow n8n node): Calls a separate, reusable sub-workflow to handle message generation and sending, passing the dynamic message content and variables.
Code (n8n node - Sub-Workflow): Performs simple template processing within the sub-workflow, replacing variable placeholders like {{ variable }} with actual data passed from the main n8n workflow.
Gmail2 (Gmail n8n node): Sends the final, personalized email. This is the ultimate communication action of the entire n8n workflow.