Templates / Collect and validate quote requests with Google Sheets and Gmail

Collect and validate quote requests with Google Sheets and Gmail

Ready for 3.0

by Small Hours · 0 views · created 2026-10-14 · 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 12 nodes and runs when someone submits an n8n form (“Request a quote”). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: When someone submits an n8n form (“Request a quote”).

  1. Settings (Edit Fields (Set)): sets 4 fields: business_name, owner_email, reply_within…
  2. Check what is missing (Code): runs custom JavaScript code
  3. Already received? (Google Sheets): uses Google Sheets
  4. New request? (If): checks a condition and branches into true / false
  5. Save request (Google Sheets): append
  6. Duplicate page (n8n Form): shows the next form page
  7. Email the owner (Gmail): uses Gmail
  8. Anything missing? (If): checks a condition and branches into true / false
  9. Ask for missing details (Gmail): uses Gmail
  10. Confirm request (Gmail): uses Gmail

…plus 1 more step. See the full node list below.

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 (7)

From the author

Quick Overview This workflow captures quote requests via an n8n Form, checks whether key details are missing, stores the request in Google Sheets, and sends notification and customer emails through Gmail with either a confirmation or a request for more…

Excerpt from Small Hours'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.