This workflow follows the Google Sheets → 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 →
{
"updatedAt": "2025-06-16T12:22:12.000Z",
"createdAt": "2025-06-16T12:21:26.550Z",
"id": "mzhHpffddR0nA80U",
"name": "02 - Modelo Texto com Video",
"active": false,
"isArchived": false,
"nodes": [
{
"parameters": {},
"id": "14d8a023-442c-464f-b18c-d6901e643e3b",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
1360,
380
]
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1ovG3gkqWLcZi7cO91-gtrtPItF0HY05QTtz097q7Yqc",
"mode": "list",
"cachedResultName": "Planilha HD - Teste",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ovG3gkqWLcZi7cO91-gtrtPItF0HY05QTtz097q7Yqc/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "pg1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ovG3gkqWLcZi7cO91-gtrtPItF0HY05QTtz097q7Yqc/edit#gid=0"
},
"options": {}
},
"id": "6deb50b9-0cf0-486c-ba9a-7d65e1dd3331",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1600,
380
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"id": "0822e43d-b77d-4d05-8257-bfc88a346092",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1880,
240
]
},
{
"parameters": {},
"id": "b3753804-b2ba-46c9-b906-58b81365ee0e",
"name": "Replace Me",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
2920,
380
]
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1ovG3gkqWLcZi7cO91-gtrtPItF0HY05QTtz097q7Yqc",
"mode": "list",
"cachedResultName": "Planilha HD - Teste",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ovG3gkqWLcZi7cO91-gtrtPItF0HY05QTtz097q7Yqc/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "pg1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jk-yWMnM96Xx22dIVsG8kPpyuCiHLsj3QCVB3P9K884/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"row_number": "={{ $('Google Sheets').item.json.row_number }}",
"Enviado": "SIM",
"Sa\u00edda": "=+551151989942"
},
"matchingColumns": [
"row_number"
],
"schema": [
{
"id": "Nome",
"displayName": "Nome",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "email",
"displayName": "email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Telefone",
"displayName": "Telefone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "CPF",
"displayName": "CPF",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Existe",
"displayName": "Existe",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Enviado",
"displayName": "Enviado",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Sa\u00edda",
"displayName": "Sa\u00edda",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": false
}
]
},
"options": {}
},
"id": "699cad01-c203-4bcb-8aab-f7993d362c4d",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
2700,
100
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "00fe3841-bebd-4679-91b3-f37d994eba91",
"leftValue": "={{ $('Google Sheets').item.json.Enviado }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
}
},
{
"id": "3b33695b-8df7-4e6a-bd5f-a7428399c7cd",
"leftValue": "={{ $('Google Sheets').item.json.Existe }}",
"rightValue": "N\u00c3O",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "or"
},
"options": {}
},
"id": "979a0ab5-67d9-4cbb-8b33-617289b1ec40",
"name": "If",
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
2100,
260
]
},
{
"parameters": {
"amount": "=1",
"path": "ee811b3b-1f56-4c71-a954-de8c5bdf68ee"
},
"id": "d62455e0-00c6-4cbd-b469-6e9b8642030f",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
2520,
100
]
},
{
"parameters": {
"method": "POST",
"url": "=https://graph.facebook.com/v22.0/576678365532139/messages",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "whatsAppApi",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"messaging_product\": \"whatsapp\",\n \"recipient_type\": \"individual\",\n \"to\": \"+55{{ $('Google Sheets').item.json.Telefone }}\",\n \"type\": \"template\",\n \"template\": {\n \"name\": \"2905_slide1\",\n \"language\": {\n \"code\": \"pt_BR\"\n },\n \"components\": [\n {\n \"type\": \"header\",\n \"parameters\": [\n {\n \"type\": \"video\",\n \"video\": {\n \"link\": \"https://mobilevet.blob.core.windows.net/arquivos/video_duette_v3.mp4\"\n }\n }\n ]\n },\n {\n \"type\": \"body\",\n \"parameters\": []\n }\n ]\n }\n}",
"options": {}
},
"id": "b397c0ff-8ff1-4cb3-9209-f4228cfafeec",
"name": "Registrar",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2340,
100
],
"credentials": {
"whatsAppApi": {
"name": "<your credential>"
}
}
}
],
"connections": {
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Replace Me": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Replace Me",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
],
[
{
"node": "Registrar",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Registrar": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"meta": {
"templateCredsSetupCompleted": true
},
"versionId": "5f9e7816-c77c-4d34-ab20-d92e6090471a",
"triggerCount": 0,
"shared": [
{
"updatedAt": "2025-06-16T12:21:26.556Z",
"createdAt": "2025-06-16T12:21:26.556Z",
"role": "workflow:owner",
"workflowId": "mzhHpffddR0nA80U",
"projectId": "5dTxE8vBWJ6kQMrp"
}
],
"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.
googleSheetsOAuth2ApiwhatsAppApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
02 - Modelo Texto com Video. Uses googleSheets, httpRequest. Event-driven trigger; 8 nodes.
Source: https://github.com/woa2000/n8n_automation/blob/2b3d421e9085108bc28fce14b9c99ae07c1ae1f2/02---modelo-texto-com-video-mzhHpffddR0nA80U.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.
TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +1
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Product Ad Machine. Uses googleDrive, googleSheets, httpRequest, @ffmpeg-micro/n8n-nodes-ffmpeg-micro. Event-driven trigger; 60 nodes.
Google Drive, Google Sheets, HTTP Request +2
Basic AI SEO KW Research n8n DataForSEO Gumroad 030125. Uses googleSheets, googleDrive, httpRequest. Event-driven trigger; 56 nodes.
Google Sheets, Google Drive, HTTP Request