Triage and enrich contact form leads, log to Sheets, and notify via Gmail
Ready for 3.0Ready 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 AI workflow has 22 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Gemini Chat Model, Google Sheets and Gmail. It also calls api.apollo.io over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Set — Workflow Configuration (Edit Fields (Set)): sets or maps fields
- Code: runs custom JavaScript code
- Webhook — Respond to Form (Respond to Webhook): sends the response back to the webhook caller
- If: checks a condition and branches into true / false
- AI — Triage Submission (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini — Chat Model; output parser: Parser — Triage JSON
- Set — Mark Rejected (Edit Fields (Set)): sets or maps fields
- Set — Assemble Lead Record (Edit Fields (Set)): sets 18 fields: name, firstName, lastName…
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Code: runs custom JavaScript code
…plus 9 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apollo.io
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 (12)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Respond to Webhook
n8n-nodes-base.respondToWebhook - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - HTTP Request
n8n-nodes-base.httpRequest - Perplexity
n8n-nodes-base.perplexity
From the author
Quick Overview This workflow receives website contact form submissions via a webhook, logs the details to Google Sheets, generates a branded HTML notification, and sends the submission to a specified recipient using Gmail. How it works 1. Receives a contact…