This workflow follows the Airtable → HTTP Request 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": "Enrich Lead Profile (v2)",
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "enrich-lead-v2",
"options": {}
},
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
250,
300
]
},
{
"parameters": {
"url": "https://api.hunter.io/v2/email-finder?domain={{$json.body.email.split('@')[1]}}&api_key=YOUR_KEY",
"options": {}
},
"name": "Fetch Social Data",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 3,
"position": [
450,
300
],
"notes": "Simulates fetching data from Hunter/Clearbit"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gemini-1.5-flash",
"mode": "list"
},
"prompt": "=Based on this raw data: {{$json.data}}, write a short 2-sentence summary of the lead's professional background and likely income bracket for a real estate CRM.",
"options": {}
},
"name": "Gemini Summarizer",
"type": "n8n-nodes-base.googleGeminiChat",
"typeVersion": 1,
"position": [
650,
300
],
"credentials": {
"googlePalmApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"baseId": "appYOURBASEID",
"table": "Leads",
"id": "={{$node[\"Webhook\"].json.body.leadId}}",
"columns": {
"mappingMode": "defineBelow",
"value": {
"AI_Summary_Text": "={{$json.output}}",
"Tags": "Enriched, Verified",
"Status": "Nurture"
}
}
},
"name": "Update Airtable",
"type": "n8n-nodes-base.airtable",
"typeVersion": 1,
"position": [
850,
300
],
"credentials": {
"airtableApi": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "Fetch Social Data",
"type": "main",
"index": 0
}
]
]
},
"Fetch Social Data": {
"main": [
[
{
"node": "Gemini Summarizer",
"type": "main",
"index": 0
}
]
]
},
"Gemini Summarizer": {
"main": [
[
{
"node": "Update Airtable",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableApigooglePalmApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Enrich Lead Profile (v2). Uses httpRequest, googleGeminiChat, airtable. Webhook trigger; 4 nodes.
Source: https://github.com/YHSG-Kling/Smart-Engine--VIP-Agents/blob/39a4392cd3e306846338d3870d4add1e5c4c0d54/workflows/enrich-lead.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.
Audit Document Compliance. Uses httpRequest, googleGeminiChat. Webhook trigger; 4 nodes.
What if AI didn't just write content—but actually thought about how to write it? This n8n workflow revolutionizes content creation by deploying multiple specialized AI agents that handle every aspect
Ai Data Extraction With Dynamic Prompts And Airtable. Uses httpRequest, extractFromFile, splitInBatches, noOp. Webhook trigger; 51 nodes.
This n8n template introduces the Dynamic Prompts Ai workflow pattern which are incredible for certain types of data extraction tasks where attributes are unknown or need to remain flexible.
2771. Uses httpRequest, chainLlm, lmChatOpenAi, airtable. Webhook trigger; 51 nodes.