Build: Instant Lead Response
Speed-to-lead is the single highest-leverage number in a service business: contacting an inquiry within 60 seconds instead of the industry-average hours can roughly quadruple your conversion rate. This build gets you there automatically, for free, in about 30 minutes.
What we're building, and why
A visitor fills out a "get a quote" form on your website. The moment they submit it, the workflow: logs them to a spreadsheet, checks whether their stated budget clears your minimum, emails you immediately so you can call them inside that critical first minute, and emails them a tailored reply with a booking link — different copy depending on which service they asked about.
The trigger: form submission
Create a new workflow and add a trigger → On Form Submission.
- Authentication: None — anyone with the link can submit.
- Form title: "Contact Us." Description: "Get a Quote Now."
- Add fields: Full Name (text, required), Email (email type — this validates the format for you, required), Service (dropdown: e.g. SEO / Ads, required), Budget (number, required).
- Click Execute step to open the live form, submit a test entry, and confirm the output panel shows your fields plus an auto-added
submittedAttimestamp.
Log the lead to Google Sheets
Create a spreadsheet with a header row: Full Name, Email, Service, Budget, Contacted,
Rejected, Date. Back in n8n, add an action → Google Sheets →
Append Row.
- Create the credential (sign in with Google, grant access) — this connection is reused by every Sheets node from now on.
- Select your document, then the correct tab ("Sheet1").
- Map each column by dragging the matching field from the Input panel:
Full Name,Email,Service,Budget, and the auto-generatedsubmittedAtintoDate. - Execute the step and confirm a new row lands in the sheet.
Filter out low-budget leads
Not every inquiry is worth your delivery cost. Add a Filter node: condition =
Budget (Number) is greater than or equal to 1000.
Anything below the threshold is silently discarded here — the rest of the workflow simply never runs for that lead. While testing, edit the pinned form data's budget field above/below 1000 to confirm both paths.
Notify yourself instantly
Add Gmail → Send a message, addressed to yourself.
- Subject: "🔔 New Lead" — a subject line you'll recognize instantly in a crowded inbox is a small trick that pays off every single time it fires.
- Body (Text, switched to Expression so you can use line breaks): map in
Full Name,Email,Service, andBudget. - In Options → Append Attribution, turn this off so client-facing sends never carry an "automated with n8n" footer.
Branch the reply by service
Add an IF node: condition = Service equals
"ads". On the true branch, add a Gmail send addressed to the lead with
ads-specific copy and a booking link. Duplicate that node onto the false branch and swap in
SEO-specific copy.
To strip a last name out of a full-name field for a friendlier greeting ("Hi Jane" instead of "Hi Jane Smith"), switch the field to Expression and use:
{{ $json.full_name.split(' ')[0] }}
You don't need to know why that works to use it — describe what you want to ChatGPT ("give me an n8n expression that returns only the first word of this field") and paste the result in.
Merge the branches back together
Add a Merge node in Append mode with two inputs, and connect both the "true" and "false" reply branches into it. Everything after this point — updating the sheet — only needs to exist once instead of being duplicated per branch.
Update the sheet's status
Add Google Sheets → Update Row (or "Append or Update" if you
prefer one node that does both). Set Column to match on to Email —
the only field guaranteed to be unique per lead — then set Contacted to
true and compute Rejected with an inline expression:
{{ $json.budget >= 1000 ? false : true }}
Test end to end
Click Execute Workflow at the bottom of the canvas (not inside a single node) so the trigger actually fires and data flows through every downstream node. Submit once with a budget above your threshold and the "ads" service, and once below threshold with "SEO," and confirm the sheet, your inbox, and the test lead's inbox all show the expected result before you flip the workflow to Active.
Variations worth selling
- Swap the form for a webhook from the client's existing site form or CRM — see Layer 05 for the webhook pattern.
- Add a calendar-booking link generated per lead instead of a static one.
- Replace the static reply copy with an AI-drafted, personalized one — the pattern is identical to the reply-drafting step in Layer 02.
Sources
| Source | Used for |
|---|---|
| Jono Catliff (Automatable), "n8n 8 Hour Masterclass — Build & Sell AI Agents (Automate Anything)" | Primary source for this build's workflow steps |
| n8n docs, Form node | Form trigger setup & field types |
| n8n docs, Filter node | Budget-threshold filtering |
| n8n docs, Google Sheets node | Append/update row operations |
| n8n docs, Gmail node | Sending the notification & reply emails |