AutomationMart
Home/Browse/Automate multi-step onboarding with Google Sheets, Forms and Gmail notifications
n8n

Automate multi-step onboarding with Google Sheets, Forms and Gmail notifications

n8nn8n26 modulesv1.0
codeexecuteWorkflowexecuteWorkflowTriggerformformTriggergmailgoogleSheetsifmanualTriggernoOpscheduleTriggersetswitch

This n8n workflow enables teams to automate and standardize multi-step onboarding or messaging workflows using Google Sheets, Forms, Gmail, and dynamic logic powered by Code and Switch nodes. It ensures the right email is sent at the right step, tracks progress in Google Sheets, and handles errors or escalations. --- 🧑‍💼 Who is this for? - HR and PeopleOps teams managing candidate or employee onboarding processes - Customer success or onboarding teams handling structured, step-based journeys

At a glance

Automate multi-step onboarding with Google Sheets, Forms and Gmail notifications is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects code, executeWorkflow, executeWorkflowTrigger, form. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
code, executeWorkflow, executeWorkflowTrigger, form, formTrigger, gmail
Modules
26
Price
Free
Version
v1.0
Automate multi-step onboarding with Google Sheets, Forms and Gmail notifications workflow diagram

About this workflow

This n8n workflow enables teams to automate and standardize multi-step onboarding or messaging workflows using Google Sheets, Forms, Gmail, and dynamic logic powered by Code and Switch nodes. It ensures the right email is sent at the right step, tracks progress in Google Sheets, and handles errors or escalations. --- 🧑‍💼 Who is this for? - HR and PeopleOps teams managing candidate or employee onboarding processes - Customer success or onboarding teams handling structured, step-based journeys - Any team using Google Sheets as a lightweight CRM or workflow tracker --- 🧩 What problem is this workflow solving? Coordinating multi-step onboarding or communication flows using spreadsheets and email can quickly become error-prone. This workflow: - Dynamically detects the current step and status from a Google Sheet - Sends the right message at the right time - Updates statuses and creates next steps - Handles errors with escalation logic --- ⚙️ What this workflow does 1. Trigger via Form or Manual Execution - Users can fill a web form or run the workflow manually. 2. Read Google Sheets - Retrieves step definitions and user progress from two sheets: - One for message templates - One for user step/status tracking 3. Generate Message Table - Uses custom JavaScript to parse and structure message templates based on step and message type (sent, completed, error). 4. Determine User Step - A Switch node checks the user’s current step and status. - Logic branches into the correct flow for message sending and verification. 5. Send Message - Message variables are replaced using a Code node. - Final message is sent via Gmail or another workflow (using Execute Workflow). 6. Update Sheets - Marks the step as completed or passed. - Creates the next step in the sheet with updated status. 7. Handle Errors - If the step fails, an error message is sent to the responsible admin. --- 🛠️ Setup 1. Connect Google Sheets and Gmail: - Ensure credentials are configured in n8n. 2. Prepare Sheets: - One sheet for messages with steps/types/subjects/content. You can copy the one from here - One sheet for tracking users and their current step/status. You can copy the one from here 3. Customize Webform: - Use the provided form to capture First Name, Last Name, and Email. 4. Connect to Your Email Templates: - Ensure your message structure follows the expected JSON format by step and type. --- ✏️ How to customize this workflow to your needs - Add More Steps: Expand the Switch logic and template sheet for more steps. - Use Different Channels: Replace Gmail with Slack, Telegram, or another messaging node. - Change Form Fields: Adjust the FormTrigger node to match your onboarding fields. - Custom Error Logic: Customize escalation emails, including admin routing or Slack alerts. - Integrate with Databases: Swap Google Sheets with Airtable, PostgreSQL, or Notion. --- This workflow is ideal for automating repetitive, step-based processes involving human communication. It’s modular, extensible, and powered by spreadsheet-driven logic.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Scrape & import shoe products to Shopify with BrowserAct (with variants & images)

Scrape & Import Products to Shopify from Any Site (with Variants & Images)-(Optimized for shoes) This advanced n8n template automates e-commerce operations by scraping product data (including variants and images) from any URL and creating fully detailed products in your Shopify store. This workflow is essential for dropshippers, e-commerce store owners, and anyone looking to quickly import product catalogs from specific websites into their Shopify store. --- Self-Hosted Only This Workflow uses

Free

Convert meeting recordings to notes & action items with AssemblyAI, GPT-4 & Sheets

This workflow automates the process of turning meeting recordings into structured notes and actionable tasks using AssemblyAI and Google Sheets. It is ideal for teams who want to save time on manual note-taking and ensure that action items from meetings are never missed. What it does - Receives a meeting recording (audio file) via webhook - Transcribes the audio using AssemblyAI - Uses AI to generate structured meeting notes and extract action items (tasks) - Logs meeting details and action

Free

Daily Magento 2 customer sync to Google Contacts & Sheets without duplicates

Automatically sync newly registered Magento 2 customers to Google Contacts and Google Sheets every 24 hours — with full duplication control and seamless automation. This workflow is a plug-and-play customer contact automation system designed for Magento 2 store owners, marketers, and CRM teams. It fetches customer records registered within the last 24 hours (from 00:00:00 to 23:59:59), checks against an existing Google Sheet to avoid reprocessing, and syncs only the new ones into Google Con

Free

Generate AI viral videos with Seedance and upload to TikTok, YouTube & Instagram

Generate AI videos with Seedance & Blotato, upload to TikTok, YouTube & Instagram Who is this for? This template is ideal for creators, content marketers, social media managers, and AI enthusiasts who want to automate the production of short-form, visually captivating videos for platforms like TikTok, YouTube Shorts, and Instagram Reels — all without manual editing or publishing. What problem is this workflow solving?

Free

Effortless task management: Create Todoist tasks directly from Telegram with AI

Effortless Task Management: Create Todoist Tasks Directly from Telegram with AI This n8n workflow empowers you to seamlessly manage your tasks by creating Todoist entries directly from Telegram, using the power of AI. Simply send a voice or text message to your Telegram bot, and this workflow will transform it into actionable tasks in your Todoist account. Who is this for? Busy professionals who need a quick and easy way to capture tasks on the go. Students looking to streamline their assignme

Free

Extract email tasks with Gmail, ChatGPT-4o and Supabase

Gmail → GPT → Supabase | Task Extractor This n8n workflow automates the extraction of actionable tasks from unread Gmail messages using OpenAI's GPT API, stores the resulting task metadata in Supabase, and avoids re-processing previously handled emails. --- ✅ What It Does 1. Triggers on a schedule to check for unread emails in your Gmail inbox. 2. Loops through each email individually using SplitInBatches. 3. Checks Supabase to see if the email has already been processed. 4. If it's a new email:

Free

AI proposal generator

Overview Stop spending hours formatting proposals. This workflow turns a short post-call form into a high-converting, fully-personalized PandaDoc proposal—plus updates your CRM and drafts the follow-up email for you. After a sales call, just fill out a 3-minute form summarizing key pain points, solutions pitched, and the price. The workflow uses AI to generate polished proposal copy, then builds a PandaDoc draft using dynamic data mapped into the JSON body (which you can fully customize per

Free

Simple eval for legal benchmarking

This workflow demonstrates a simple way to run evals on a set of test cases stored in a Google Sheet. The example we are using comes from an info extraction task dataset, where we tested 6 different LLMs on 18 different test cases. You can see our sample data in this spreadsheet here to get started. Once you have this working for our dataset, you can plug in your own test cases matching different LLMs to see how it works with your own data. How it works: - It loads test cases from Google Sheets.

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free