Bear Brown
← All N8N workflows
Data & databasesCryptoEmail SendFormForm TriggerGoogle Sheets

Adding to GSheet-List, Creating a OTP / Verification Code

Configured with Crypto, Email Send, Form, Form Trigger, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗14 nodes · MIT
Workflow preview
Data storeAdd to Waitlist SheetGoogle SheetsTransformClean and StandardizeEdit FieldsMessagingSend Verification EmailEmail SendIntegrationValidate withVerification CodeFormTransformGet all Data from thePrev Form + CurrentEdit FieldsIntegrationAdditional Data for theSheetFormTransformEvery Step DataEdit FieldsRoutingis the Code correct?IfIntegrationLet the User ReenterCodeFormTransformMergeMergeData storeSave Intend to ListGoogle SheetsData storeSave as VerifiedGoogle SheetsTransformGenerate RandomVerification CodeCryptoTriggerWaitlist FormForm Trigger

Node categories in this workflow

  • Data store
  • Transform
  • Messaging
  • Integration
  • Routing
  • Trigger

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Add to Waitlist SheetData storeGoogle SheetsappendOrUpdate
Clean and StandardizeTransformEdit FieldsSee node parameters
Send Verification EmailMessagingEmail SendSee node parameters
Validate with Verification CodeIntegrationFormSee node parameters
Get all Data from the Prev Form + CurrentTransformEdit FieldsSee node parameters
Additional Data for the SheetIntegrationFormSee node parameters
Every Step DataTransformEdit FieldsSee node parameters
is the Code correct?RoutingIfSee node parameters
Let the User Reenter CodeIntegrationFormSee node parameters
MergeTransformMergeSee node parameters
Save Intend to ListData storeGoogle SheetsappendOrUpdate
Save as VerifiedData storeGoogle SheetsappendOrUpdate
Generate Random Verification CodeTransformCryptoSee node parameters
Waitlist FormTriggerForm TriggerSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleSheetsOAuth2Api
  • smtp

Workflow notes

Instructions

Instructions

This automation streamlines the process of collecting user information using a Form Node, enabling individuals to join a waitlist managed via Google Sheets.

It also generates a verification code, prompting users to input this code in the Second Form Step. If the code is _nvalid, the workflow keeps the user in a verification loop until a valid code is entered.

Once a valid code is provided, the workflow proceeds to the final step, where additional information can be collected.

All entered data and intermediate states are securely stored in the Google Sheet.

Structure of the GoogleSheet

Firstname | Lastname | Email | Company | Verification-Code | Verified | Intended Use Marcel | Claus-Ahrens | foo[at]bar| foobar | abc123 | TRUE | Just testing

Setup

  1. Set Up a Google Sheet: Create a Google Sheet with the specified columns, or customize them to suit your needs.
  2. Verify the "Send Mail" Node: Ensure your "Send Mail" node is functional, or replace it with another email-sending node.
  3. Customize Texts and Fields: Update email content, form texts, and form fields to align with your specific use case.
  4. Done!


Enjoy the workflow! ❤️
let the workf low — Workflow Automation & Development

Adding to GSheet-List, Creating a OTP / Verification Code

Adding to GSheet-List, Creating a OTP / Verification Code

Purpose and structure

This folder contains the Adding to GSheet-List, Creating a OTP / Verification Code workflow. Its executable nodes use crypto, emailSend, form, formTrigger, googleSheets, if, merge, set. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Waitlist Form

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Form/0633_Form_GoogleSheets_Create_Triggered.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Adding to GSheet-List, Creating a OTP / Verification Code
  • Let the user enter the Verification Code
  • Verification Loop
  • Last Page, let them add some details and save them

More in Data & databases

1/ Add Your credentials1/ Add Your credentials2. Add Beehiiv newsletter subscribers from Gumroad sales