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:23:09.000Z",
"createdAt": "2025-06-16T12:22:53.585Z",
"id": "KMov6t04PblbtPyH",
"name": "03 - Modelo Lista Fria",
"active": false,
"isArchived": false,
"nodes": [
{
"parameters": {},
"id": "2d8fc3f3-6b8c-4fd6-9431-c3ea435722a2",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
940,
380
]
},
{
"parameters": {
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/1yz00cT5pgpPmep9wWbYZYPHiNtssgmza0pk2RZNt-5I/edit?usp=drivesdk",
"__regex": "https:\\/\\/(?:drive|docs)\\.google\\.com(?:\\/.*|)\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "pg1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yz00cT5pgpPmep9wWbYZYPHiNtssgmza0pk2RZNt-5I/edit#gid=0"
},
"options": {}
},
"id": "e1c86655-2188-488a-bd53-0c0171661ad9",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1160,
380
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"id": "aae85302-70d2-4f64-b79b-f31139673d05",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1440,
240
]
},
{
"parameters": {},
"id": "0bc4d1f2-658a-453e-ae61-fd010dc49377",
"name": "Replace Me",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
3300,
460
]
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1yz00cT5pgpPmep9wWbYZYPHiNtssgmza0pk2RZNt-5I",
"mode": "list",
"cachedResultName": "Planilha HD",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yz00cT5pgpPmep9wWbYZYPHiNtssgmza0pk2RZNt-5I/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "pg1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yz00cT5pgpPmep9wWbYZYPHiNtssgmza0pk2RZNt-5I/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Telefone": "={{ $('Loop Over Items').item.json.Telefone }}",
"Enviado": "SIM"
},
"matchingColumns": [
"Telefone"
],
"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": false
},
{
"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,
"removed": false
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
]
},
"options": {}
},
"id": "2a78bcd6-f4b1-44d8-96bd-55dfe1a5d024",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
2880,
-40
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"amount": "={{ Math.floor(Math.random() * (10) + 25) }}",
"path": "39a8d0a1-0907-4ec2-9bdf-0f96206c1f24"
},
"id": "b5d0c5ff-5693-4234-ac90-29bdbdc3cf4d",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
3140,
460
]
},
{
"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": "38811a4b-38c2-46cc-9dd2-d4ee2589dd61",
"name": "If",
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1660,
260
]
},
{
"parameters": {
"resource": "messages-api",
"operation": "send-video",
"instanceName": "Talent",
"remoteJid": "=55{{ $('Google Sheets').item.json.Telefone }}",
"media": "https://mobilevet.blob.core.windows.net/arquivos/talent2025%20(1).mp4",
"caption": "H\u00e1 23 anos, O Talent Hunter Douglas acredita que as melhores conex\u00f5es nascem de momentos compartilhados. O Talent 2025 mudou para oferecer experi\u00eancias exclusivas, networking com profissionais de todo o Brasil e conte\u00fados que impulsionam seu crescimento profissional. Este \u00e9 o programa para quem desenha o futuro da arquitetura e decora\u00e7\u00e3o. Para participar, acesse a nossa plataforma e conhe\u00e7a todas as formas de pontuar para atingir suas metas e viver experi\u00eancias especiais. Cadastre-se pelo bot\u00e3o abaixo: IMPORTANTE: Para os profissionais j\u00e1 cadastrados no Talent, s\u00e3o necess\u00e1rios os seguintes passos: Clique em \u201cEntrar\u201d Clique em \u201cN\u00e3o tenho cadastro\u201d Insira seu e-mail cadastrado no Talent e crie uma nova senha Seus dados ser\u00e3o carregados automaticamente. Verifique as informa\u00e7\u00f5es e finalize o acesso.",
"options_message": {
"delay": 1200
}
},
"id": "61433cf0-30a1-4d31-bfe8-c2bf24eb05c9",
"name": "Evolution API",
"type": "n8n-nodes-evolution-api.evolutionApi",
"typeVersion": 1,
"position": [
2240,
-40
],
"credentials": {
"evolutionApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"amount": "={{ Math.floor(Math.random() * (6) + 5) }}",
"path": "564914a7-865b-431f-89ef-6c866013b6c4"
},
"id": "9a56fa94-1704-4c2a-8a70-503f030e8cf4",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
2460,
-40
]
},
{
"parameters": {
"resource": "messages-api",
"instanceName": "Talent",
"remoteJid": "=55{{ $('Google Sheets').item.json.Telefone }}@s.whatsapp.net",
"messageText": "Clique aqui e Cadastre-se: https://talent.hunterdouglas.com.br/auth/signup",
"options_message": {}
},
"id": "a580395d-2508-4d1d-8873-f50896f13b3f",
"name": "Evolution API1",
"type": "n8n-nodes-evolution-api.evolutionApi",
"typeVersion": 1,
"position": [
2660,
-40
],
"credentials": {
"evolutionApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a0c1f713-0f6d-4c9a-8af9-6aa2b279b684",
"leftValue": "={{ $('Google Sheets').item.json.row_number % 2 === 0 }}",
"rightValue": "0",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1940,
100
],
"id": "4fbe43e4-d884-4289-bf1e-309b7032ea6e",
"name": "If1"
},
{
"parameters": {
"resource": "messages-api",
"operation": "send-video",
"instanceName": "Talent 2025 Chip 2",
"remoteJid": "=55{{ $('Google Sheets').item.json.Telefone }}",
"media": "https://mobilevet.blob.core.windows.net/arquivos/talent2025%20(1).mp4",
"caption": "H\u00e1 23 anos, O Talent Hunter Douglas acredita que as melhores conex\u00f5es nascem de momentos compartilhados. O Talent 2025 mudou para oferecer experi\u00eancias exclusivas, networking com profissionais de todo o Brasil e conte\u00fados que impulsionam seu crescimento profissional. Este \u00e9 o programa para quem desenha o futuro da arquitetura e decora\u00e7\u00e3o. Para participar, acesse a nossa plataforma e conhe\u00e7a todas as formas de pontuar para atingir suas metas e viver experi\u00eancias especiais. Cadastre-se pelo bot\u00e3o abaixo: IMPORTANTE: Para os profissionais j\u00e1 cadastrados no Talent, s\u00e3o necess\u00e1rios os seguintes passos: Clique em \u201cEntrar\u201d Clique em \u201cN\u00e3o tenho cadastro\u201d Insira seu e-mail cadastrado no Talent e crie uma nova senha Seus dados ser\u00e3o carregados automaticamente. Verifique as informa\u00e7\u00f5es e finalize o acesso.",
"options_message": {
"delay": 1200
}
},
"id": "f85c9698-053a-4058-9f31-bc78702682df",
"name": "Evolution API2",
"type": "n8n-nodes-evolution-api.evolutionApi",
"typeVersion": 1,
"position": [
2240,
180
],
"credentials": {
"evolutionApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"amount": "={{ Math.floor(Math.random() * (6) + 5) }}",
"path": "b40995e3-fc2e-4e38-af7d-f1a89e7b0c62"
},
"id": "15e42f4f-8f0d-4e05-ab20-d3fc61f12c35",
"name": "Wait2",
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
2460,
180
]
},
{
"parameters": {
"resource": "messages-api",
"instanceName": "Talent 2025 Chip 2",
"remoteJid": "=55{{ $('Google Sheets').item.json.Telefone }}@s.whatsapp.net",
"messageText": "Clique aqui e Cadastre-se: https://talent.hunterdouglas.com.br/auth/signup",
"options_message": {}
},
"id": "9361c2d1-e08e-4fee-a0e4-6b242f239689",
"name": "Evolution API3",
"type": "n8n-nodes-evolution-api.evolutionApi",
"typeVersion": 1,
"position": [
2660,
180
],
"credentials": {
"evolutionApi": {
"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": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"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": "If1",
"type": "main",
"index": 0
}
]
]
},
"Evolution API": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Evolution API1",
"type": "main",
"index": 0
}
]
]
},
"Evolution API1": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Evolution API",
"type": "main",
"index": 0
}
],
[
{
"node": "Evolution API2",
"type": "main",
"index": 0
}
]
]
},
"Evolution API2": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Evolution API3",
"type": "main",
"index": 0
}
]
]
},
"Evolution API3": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"meta": {
"templateCredsSetupCompleted": true
},
"versionId": "a2bc4f87-44dc-46e7-b649-31280b2fdbe3",
"triggerCount": 0,
"shared": [
{
"updatedAt": "2025-06-16T12:22:53.588Z",
"createdAt": "2025-06-16T12:22:53.588Z",
"role": "workflow:owner",
"workflowId": "KMov6t04PblbtPyH",
"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.
evolutionApigoogleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
03 - Modelo Lista Fria. Uses googleSheets, n8n-nodes-evolution-api. Event-driven trigger; 14 nodes.
Source: https://github.com/woa2000/n8n_automation/blob/2b3d421e9085108bc28fce14b9c99ae07c1ae1f2/03---modelo-lista-fria-KMov6t04PblbtPyH.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.
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.
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Product Ad Machine. Uses googleDrive, googleSheets, httpRequest, @ffmpeg-micro/n8n-nodes-ffmpeg-micro. Event-driven trigger; 60 nodes.
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet