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": "Wpp",
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "aula",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
0,
0
],
"id": "a55886a1-aee3-4a01-84f4-ee02bf863bc9",
"name": "Webhook"
},
{
"parameters": {
"mode": "raw",
"jsonOutput": "={{ $json.body.jsonData }}",
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
208,
0
],
"id": "9096f430-1acd-491d-9ca8-704925a19062",
"name": "PARSE1"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "b065143f-b9f5-4e72-a8e5-998cf883ba04",
"name": "nome",
"value": "={{ $json.event.Info.PushName }}",
"type": "string"
},
{
"id": "c708f21e-3b52-4e32-841c-f4e3bb4ac00b",
"name": "numero",
"value": "={{ $json.event.Info.Sender.split('@')[0].split(':')[0] }}",
"type": "string"
},
{
"id": "dfa58ce6-3d57-442b-9242-49eb68d7b67c",
"name": "mensagem",
"value": "={{ $json.event.Message.extendedTextMessage.text }}",
"type": "string"
},
{
"id": "ef1e7673-b5c2-461a-9151-8fa744007ea1",
"name": "isGroup",
"value": "={{ $json.event.Info.IsGroup }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
416,
0
],
"id": "58763c0a-0e42-4bd5-a2c1-3e540f8d6057",
"name": "NORM"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6b4d7965-aee2-43c7-9e0b-b6ea208bf87a",
"leftValue": "={{ $json.isGroup }}",
"rightValue": "true",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
624,
0
],
"id": "2315d0fd-129c-469c-ab67-083b850e04fd",
"name": "If"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
832,
-96
],
"id": "fdeab15e-2348-436a-a182-a9b9da360d4b",
"name": "NADA"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "models/gemini-2.5-flash",
"mode": "list",
"cachedResultName": "models/gemini-2.5-flash"
},
"messages": {
"values": [
{
"content": "Voce \u00e9 apenas uma IA normal porem que responde de forma curta e direta e \u00e9 especialista em Skyrim responda sempre em uma unica mensagem",
"role": "model"
},
{
"content": "={{ $('NORM').item.json.mensagem }}"
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"typeVersion": 1,
"position": [
1680,
0
],
"id": "f35b0803-af4d-495f-9a54-777f1b4981a7",
"name": "Message a model",
"credentials": {
"googlePalmApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"method": "POST",
"url": "http://3.82.24.11:8080/message/sendText/n8n",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "number",
"value": "={{ $('NORM').item.json.numero }}"
},
{
"name": "text",
"value": "={{ $json.content.parts[0].text }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2032,
0
],
"id": "66f8243d-033c-4b8a-9de4-ed261ec57953",
"name": "HTTP Request",
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "create",
"base": {
"__rl": true,
"value": "appLHt6ocXq5UiNVT",
"mode": "list",
"cachedResultName": "N8N Testes",
"cachedResultUrl": "https://airtable.com/appLHt6ocXq5UiNVT"
},
"table": {
"__rl": true,
"value": "tbl8JeQC7JZjInlrr",
"mode": "list",
"cachedResultName": "Users",
"cachedResultUrl": "https://airtable.com/appLHt6ocXq5UiNVT/tbl8JeQC7JZjInlrr"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"phone": "={{ $('NORM').item.json.numero }}",
"full_name": "={{ $('NORM').item.json.nome }}"
},
"matchingColumns": [],
"schema": [
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "phone",
"displayName": "phone",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "full_name",
"displayName": "full_name",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
1296,
288
],
"id": "29eee4ad-6e05-4fed-a1b4-739247b5eea8",
"name": "CRIAR CONTATO",
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a0ec7696-4928-4ae4-bf1b-0d34c04fec0d",
"leftValue": "={{!Object.keys($node[\"Search records\"].data).length}}",
"rightValue": "",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1072,
48
],
"id": "dd125f80-cd64-42d1-9780-973a23671a35",
"name": "If1",
"alwaysOutputData": false
},
{
"parameters": {},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
1488,
0
],
"id": "1c875b85-c837-47b6-a9cd-f9ea680972e2",
"name": "Merge",
"alwaysOutputData": true
},
{
"parameters": {
"operation": "search",
"base": {
"__rl": true,
"value": "appLHt6ocXq5UiNVT",
"mode": "list",
"cachedResultName": "N8N Testes",
"cachedResultUrl": "https://airtable.com/appLHt6ocXq5UiNVT"
},
"table": {
"__rl": true,
"value": "tbl8JeQC7JZjInlrr",
"mode": "list",
"cachedResultName": "Profile",
"cachedResultUrl": "https://airtable.com/appLHt6ocXq5UiNVT/tbl8JeQC7JZjInlrr"
},
"filterByFormula": "={phone} = \"{{ $json.numero }}\"",
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
832,
48
],
"id": "c5120a65-4729-45f5-b74d-1bd555200f05",
"name": "Search records",
"alwaysOutputData": true,
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "PARSE1",
"type": "main",
"index": 0
}
]
]
},
"PARSE1": {
"main": [
[
{
"node": "NORM",
"type": "main",
"index": 0
}
]
]
},
"NORM": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[
{
"node": "NADA",
"type": "main",
"index": 0
}
],
[
{
"node": "Search records",
"type": "main",
"index": 0
}
]
]
},
"Message a model": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
],
[
{
"node": "CRIAR CONTATO",
"type": "main",
"index": 0
}
]
]
},
"CRIAR CONTATO": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Message a model",
"type": "main",
"index": 0
}
]
]
},
"Search records": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "ffd364b0-0010-4be6-99ff-c413c88aa907",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "QCGSe1rKWCyKUA8z",
"tags": []
}
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.
airtableTokenApigooglePalmApihttpHeaderAuth
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Wpp. Uses googleGemini, httpRequest, airtable. Webhook trigger; 11 nodes.
Source: https://github.com/DiegoVSC42/AVM/blob/09286cea243235976b6c039620e26483b7d83a28/n8n/aws/Wpp.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.
This workflow automates the process of generating stylized product photos for e-commerce by combining real product shots with creative templates. It enables the creation of a complete set of images fo
Airtable, HTTP Request, Google Gemini
This powerful n8n automation workflow is designed to execute advanced B2B lead enrichment and hyper-personalization for cold email outreach. By orchestrating a complex chain of data scraping, AI analy
OpenAI, HTTP Request, Airtable
This template is perfect for e-commerce entrepreneurs, marketers, agencies, and creative teams who want to turn simple product photos and short descriptions into professional flyers or product videos—
Airtable, OpenAI, HTTP Request +1
How it works Runs on schedule (Monday-Friday at 9 AM) to automate lead generation Searches for companies on Google Maps by location and category Extracts owner information from company websites and im
HTTP Request, Anthropic, Google Gemini +3
This n8n template demonstrates how to capture inbound leads from a form, qualify them with OpenAI, and route the hottest ones to a Bland AI voice agent that calls them back, books a meeting on Google
Airtable, OpenAI, SendGrid +2