Skip to main content

Send Webflow form leads to Google Sheets with email and WhatsApp alerts

Workflow preview

Workflow preview
100%
Send Webflow form leads to Google Sheets with email and WhatsApp alerts preview
Open on n8n.io

1. Workflow Overview

Who it's for This n8n workflow is designed for business owners , sales teams , and customer support managers who want to automate their lead capture and immediate acknowledgment process. The workfl...

Best for

  • Lead Generation automation workflows
  • intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.webflowtrigger, n8n-nodes-base.splitinbatches, n8n-nodes-base.wait, n8n-nodes-base.stickynote, n8n-nodes-base.code, n8n-nodes-base.googlesheets, n8n-nodes-base.gmail, n8n-nodes-rapiwa.rapiwa

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by SpaGreen Creative.

Original n8n.io source

1.1 Workflow description

Title
Send Webflow form leads to Google Sheets with email and WhatsApp alerts
Workflow name
Send Webflow form leads to Google Sheets with email and WhatsApp alerts

Who it's for

This n8n workflow is designed for business owners, sales teams, and customer support managers who want to automate their lead capture and immediate acknowledgment process. The workflow creates an end-to-end multi-channel communication system that captures form submissions directly from Webflow, cleans and structures the data, saves it securely to a Google Sheet, and instantly sends personalized "Thank You" messages via both Email and WhatsApp.

Features

  • Captures Webflow form submissions in real time
  • Cleans and structures data into JSON using custom JavaScript
  • Automatically saves leads to Google Sheets (Name, Email, Phone, Message, Date)
  • Sends instant email confirmation to users
  • Verifies WhatsApp numbers via Rapiwa API
  • Sends WhatsApp messages only to valid numbers
  • Handles multiple submissions with delay to avoid API limits
  • Uses conditional routing for error-free automation flow

Requirements

  • Webflow OAuth2 API: To authenticate the trigger node and receive real-time form submission webhooks from your specific site.
  • Google Sheets OAuth2 API: For appending new lead data to your designated spreadsheet ("Sales - Save to Google Sheets").
  • Gmail OAuth2 API: To send the automated confirmation emails to your leads from your connected Gmail account.
  • Rapiwa API Credentials: For verifying the validity of WhatsApp numbers and sending out the WhatsApp text messages.
Configure Credentials
  • Webflow API: Ensure you select the correct Site ID in the trigger node settings to listen to the right website's forms.
  • Google Sheets: Configure with edit access to the target spreadsheet and ensure the sheet name ("Webflow") exactly matches your tab.
  • Gmail API: Connect the Google account you wish to use as the sender for the confirmation emails.
  • Rapiwa API: Add your Rapiwa API key to enable WhatsApp number verification and messaging capabilities.
  • Customize Messages: Update the default text in the "Send a message" (Email) and "Rapiwa" (WhatsApp) nodes, making sure to replace __add_your_brand_name__ with your actual brand name.

Important Notes

  • Ensure consistent field names between Code node and Google Sheets (e.g., email, name must match exactly with sheet headers like Email, Name) to avoid empty values
  • WhatsApp logic: $json.exists === false means the number is valid and exists on WhatsApp, so the True branch sends the message—don’t invert this
  • Loop Over Items has two outputs: top output goes back into the 5s wait loop, bottom output continues main processing flow
  • WhatsApp message uses cleaned sheet data ($('Store Data in Sheet').item.json.Name) to ensure accurate formatting
  • Replace __add_your_brand_name__ in all templates to avoid unprofessional messaging

Support & Help

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Webflow Trigger

Type / Role
n8n-nodes-base.webflowTrigger - webflowTrigger
Config choices
Version 2

Block 2 - Loop Over Items

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 3 - Wait 5s

Type / Role
n8n-nodes-base.wait - wait
Config choices
Version 1.1

Block 4 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 5 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Code (Clean response data)

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 7 - Google Sheet (Store/Save Data in Sheet)

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 8 - Send a confirmation email message

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.2

Block 9 - Rapiwa (Verify WhatsApp Number)

Type / Role
n8n-nodes-rapiwa.rapiwa - rapiwa
Config choices
Version 1

Block 10 - If (Check WhatsApp Number Exists or Not)

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 11 - Rapiwa (Send WhatsApp Confirmation Message)

Type / Role
n8n-nodes-rapiwa.rapiwa - rapiwa
Config choices
Version 1

Block 12 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Send Webflow form leads to Google Sheets with email and WhatsApp alerts
Complexity intermediate
Nodes 13
Categories Lead Generation
Author SpaGreen Creative
Published 28 Apr 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/15349/15349.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Send Webflow form leads to Google Sheets with email and WhatsApp alerts do?

Who it's for This n8n workflow is designed for business owners , sales teams , and customer support managers who want to automate their lead capture and immediate acknowledgment process. The workfl...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation use case.