AutomationFlowsData & Sheets › Modelo Lista Fria

Modelo Lista Fria

03 - Modelo Lista Fria. Uses googleSheets, n8n-nodes-evolution-api. Event-driven trigger; 14 nodes.

Event trigger★★★★☆ complexity14 nodesGoogle SheetsN8N Nodes Evolution Api
Data & Sheets Trigger: Event Nodes: 14 Complexity: ★★★★☆ Added:

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 →

Download .json
{
  "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.

Pro

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 →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

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
Data & Sheets

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
Data & Sheets

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

Google Sheets, Google Drive, HTTP Request
Data & Sheets

🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)

HTTP Request, Google Drive, Google Sheets
Data & Sheets

📄 Documentation: Notion Guide

Google Sheets, Google Drive, HTTP Request +2