This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "Lead intake: form -> AI qualification -> CRM -> follow-up draft",
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "lead-intake",
"responseMode": "onReceived",
"options": {}
},
"id": "a1000000-0000-0000-0000-000000000001",
"name": "Lead form webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
]
},
{
"parameters": {
"method": "POST",
"url": "={{ $env.LLM_BASE_URL }}/v1/messages",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "={{ $env.LLM_API_KEY }}"
},
{
"name": "anthropic-version",
"value": "2023-06-01"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={{ JSON.stringify({model: $env.LLM_MODEL, max_tokens: 500, messages: [{role: 'user', content: 'You qualify inbound sales leads. Score this lead 1-10 for fit and urgency and reply ONLY with JSON {\"score\": n, \"reason\": \"...\", \"suggested_reply\": \"...\"}. Lead: ' + JSON.stringify($json.body)}]}) }}",
"options": {}
},
"id": "a1000000-0000-0000-0000-000000000002",
"name": "Qualify lead (LLM)",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
220,
0
]
},
{
"parameters": {
"jsCode": "const raw = $json.content?.[0]?.text ?? '{}';\nconst match = raw.match(/\\{[\\s\\S]*\\}/);\nlet q = { score: 0, reason: 'parse failure', suggested_reply: '' };\ntry { if (match) q = JSON.parse(match[0]); } catch (e) {}\nconst lead = $('Lead form webhook').first().json.body;\nreturn [{ json: { ...lead, ...q, received_at: new Date().toISOString() } }];"
},
"id": "a1000000-0000-0000-0000-000000000003",
"name": "Parse qualification",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
440,
0
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"typeValidation": "loose"
},
"conditions": [
{
"leftValue": "={{ $json.score }}",
"rightValue": 7,
"operator": {
"type": "number",
"operation": "gte"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "a1000000-0000-0000-0000-000000000004",
"name": "Hot lead?",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
660,
0
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"mode": "list",
"value": "REPLACE_WITH_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Hot leads"
},
"columns": {
"mappingMode": "autoMapInputData"
},
"options": {}
},
"id": "a1000000-0000-0000-0000-000000000005",
"name": "CRM: hot leads",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
880,
-100
]
},
{
"parameters": {
"resource": "draft",
"subject": "=Re: your inquiry, {{ $json.name }}",
"message": "={{ $json.suggested_reply }}",
"options": {
"sendTo": "={{ $json.email }}"
}
},
"id": "a1000000-0000-0000-0000-000000000006",
"name": "Draft follow-up email",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
1100,
-100
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"mode": "list",
"value": "REPLACE_WITH_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Nurture"
},
"columns": {
"mappingMode": "autoMapInputData"
},
"options": {}
},
"id": "a1000000-0000-0000-0000-000000000007",
"name": "CRM: nurture list",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
880,
100
]
}
],
"connections": {
"Lead form webhook": {
"main": [
[
{
"node": "Qualify lead (LLM)",
"type": "main",
"index": 0
}
]
]
},
"Qualify lead (LLM)": {
"main": [
[
{
"node": "Parse qualification",
"type": "main",
"index": 0
}
]
]
},
"Parse qualification": {
"main": [
[
{
"node": "Hot lead?",
"type": "main",
"index": 0
}
]
]
},
"Hot lead?": {
"main": [
[
{
"node": "CRM: hot leads",
"type": "main",
"index": 0
}
],
[
{
"node": "CRM: nurture list",
"type": "main",
"index": 0
}
]
]
},
"CRM: hot leads": {
"main": [
[
{
"node": "Draft follow-up email",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Lead intake: form -> AI qualification -> CRM -> follow-up draft. Uses httpRequest, googleSheets, gmail. Webhook trigger; 7 nodes.
Source: https://github.com/cig13zs/lead-intake-automation/blob/master/lead_intake_workflow.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Universal Lead Processing Workflow. Uses googleSheets, gmail, httpRequest, gmailTrigger. Webhook trigger; 34 nodes.
This workflow acts as an instant SDR that replies to new inbound leads across multiple channels in real time. It first captures and normalizes all incoming lead data into a unified structure. The work
A comprehensive n8n workflow template for streamlining influencer application processing with real-time social media data validation, intelligent scoring algorithms, and automated onboarding workflows
AI LeadOps Main. Uses httpRequest, googleSheets, slack, gmail. Webhook trigger; 19 nodes.
AI Lead Qualification & Follow-Up. Uses httpRequest, slack, googleSheets, gmail. Webhook trigger; 18 nodes.