Templates / Capture website form leads in Google Sheets and send Gmail auto-replies

Capture website form leads in Google Sheets and send Gmail auto-replies

Ready for 3.0

by Philipp Primisser · 2 views · created 2026-10-15 · Lead Generation

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 7 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

  1. Clean & Validate (Code): runs custom JavaScript code
  2. Valid? (If): checks a condition and branches into true / false
  3. Respond OK (Respond to Webhook): sends the response back to the webhook caller
  4. Respond Error (Respond to Webhook): sends the response back to the webhook caller
  5. Save to Google Sheet (Google Sheets): append
  6. Auto-reply (Gmail) (Gmail): uses Gmail

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

From the author

Quick overview Freelancers and small businesses that collect leads through a website form can capture each submission via a webhook, save valid leads to Google Sheets and send an instant auto-reply email. How it works 1. Webhook receives the POST request from…

Excerpt from Philipp Primisser's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.