Collect and validate quote requests with Google Sheets and Gmail
Ready for 3.0What 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”).
- Settings (Edit Fields (Set)): sets 4 fields: business_name, owner_email, reply_within…
- Check what is missing (Code): runs custom JavaScript code
- Already received? (Google Sheets): uses Google Sheets
- New request? (If): checks a condition and branches into true / false
- Save request (Google Sheets): append
- Duplicate page (n8n Form): shows the next form page
- Email the owner (Gmail): uses Gmail
- Anything missing? (If): checks a condition and branches into true / false
- Ask for missing details (Gmail): uses Gmail
- Confirm request (Gmail): uses Gmail
…plus 1 more step. See the full node list below.
Services it uses
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)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - n8n Form
n8n-nodes-base.form
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…