Automatización de correos fríos/calientes

Avanzado

Este es unLead Nurturingflujo de automatización del dominio deautomatización que contiene 19 nodos.Utiliza principalmente nodos como If, Set, Hunter, EmailSend, GoogleSheets. Campaña automatizada de marketing por correo frío, usando Google Sheets, verificación de correo y SMTP

Requisitos previos
  • Credenciales de API de Google Sheets
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "0NUf4DsJtFfnyxnp",
  "meta": {
    "instanceId": "b575ae39acc98e53d75e50d1b5147e8b0922704c4aeb3230092d8e2a78247bc3"
  },
  "name": "Cold/Warm Email Automation",
  "tags": [],
  "nodes": [
    {
      "id": "8df39dbf-a9c7-4de0-9582-8946a312a35f",
      "name": "Al hacer clic en 'Ejecutar flujo de trabajo'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        432,
        1392
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3adc0f15-d7a2-4b23-b36d-eb0361167446",
      "name": "Nota adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        2096
      ],
      "parameters": {
        "color": 7,
        "height": 256,
        "content": "## **Find out SMTP info for your email service provider Link** \n\nhttps://docs.google.com/document/d/1UnAYprKmGWHQ7VDpzdMndV7-iPl1sVlIIke3GY5O8e0/edit?usp=sharing"
      },
      "typeVersion": 1
    },
    {
      "id": "42a71dd2-654d-48ca-9e89-619402f9b65a",
      "name": "Nota adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        1584
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 208,
        "content": "## **Step-by-Step Tutorial YouTube Video Link** \n\n\nhttps://youtu.be/Dg68OaYPhYs?si=LVu9pdxt9JUuCrzM"
      },
      "typeVersion": 1
    },
    {
      "id": "bb87b350-c396-4cd4-a266-1b58300cf261",
      "name": "Nota adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1584
      ],
      "parameters": {
        "color": 7,
        "width": 224,
        "height": 224,
        "content": "## **Sample Google Sheet for  Leads I used.** \n\nhttps://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=sharing \n\n\n- "
      },
      "typeVersion": 1
    },
    {
      "id": "5a7e7b8a-30ef-43fa-a290-23ccff275628",
      "name": "Activador programado a las 9 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        176,
        1392
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
      "name": "Hoja de Leads - Obtener filas de la hoja",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        640,
        1392
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=drivesdk",
          "cachedResultName": "Leads"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "3a2a1244-2870-421b-a27b-ce9dba18eace",
      "name": "Actualizar Google Sheet si el Email está \"Enviado\"",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2320,
        1744
      ],
      "parameters": {
        "columns": {
          "value": {
            "Tool Name": "={{ $('Google Sheets').item.json['Tool Name'] }}",
            "Email Sent": "={{ $json.accepted[0] }}"
          },
          "schema": [
            {
              "id": "Tool Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Tool Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Tool Link",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Tool Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Link to Apply Affiliate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Link to Apply Affiliate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "How to Work",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "How to Work",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Affiliate Link to Share",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Affiliate Link to Share",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Coupon Code",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Coupon Code",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Reach Out Mode",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Reach Out Mode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "How did you find?",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "How did you find?",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Reach Out Platform",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Reach Out Platform",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Incoming",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Incoming",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Script",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Script",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Sent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Ideas",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Ideas",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Tool Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2051398108,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit#gid=2051398108",
          "cachedResultName": "AI tool reachout"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit?usp=drivesdk",
          "cachedResultName": "CF Calendar"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.6
    },
    {
      "id": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
      "name": "Verificador - ¿Los correos están verificados o no?",
      "type": "n8n-nodes-base.if",
      "position": [
        1568,
        1584
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.result }}",
              "rightValue": "undeliverable"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "935d4058-b2e9-43f1-a887-defb038948c3",
      "name": "Nota adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        1760
      ],
      "parameters": {
        "width": 208,
        "height": 192,
        "content": "## **Add Email Verification API** \n\nI use hunter, https://hunter.io/api-keys\n\nYou can use any other tools"
      },
      "typeVersion": 1
    },
    {
      "id": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
      "name": "Crear campo para actualizar \"Enviado\" en Google Sheet1",
      "type": "n8n-nodes-base.set",
      "position": [
        2096,
        1744
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "05814c14-4365-4c37-af55-f28bf2ee5819",
              "name": "accepted[0]",
              "type": "string",
              "value": "Sent"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4f251ddb-b669-4b14-8255-ab47ab062516",
      "name": "Sin operación, no hacer nada5",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1872,
        1424
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
      "name": "Verificación de email usando Hunter",
      "type": "n8n-nodes-base.hunter",
      "position": [
        1312,
        1584
      ],
      "parameters": {
        "email": "={{ $json.Email }}",
        "operation": "emailVerifier"
      },
      "typeVersion": 1
    },
    {
      "id": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
      "name": "Verificador - ¿Ya está \"Enviado\" o no?",
      "type": "n8n-nodes-base.if",
      "position": [
        864,
        1392
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c72a013e-7b22-4bc7-a6c6-d51e9804ece7",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json['Email Sent'] }}",
              "rightValue": "Sent"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
      "name": "Verificador - ¿El campo \"Email\" del Lead está vacío?",
      "type": "n8n-nodes-base.if",
      "position": [
        1088,
        1488
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
      "name": "Sin operación, no hacer nada",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1040,
        1296
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
      "name": "Sin operación, no hacer nada1",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1312,
        1392
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d98f7325-01c6-4e62-acc9-ca6bee188d39",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1232
      ],
      "parameters": {
        "width": 224,
        "height": 128,
        "content": "## **Connect with Google Sheet or CRM** "
      },
      "typeVersion": 1
    },
    {
      "id": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
      "name": "Enviar correo usando SMTP",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1872,
        1744
      ],
      "webhookId": "3a2cb249-8183-4481-8df7-5fcdd2c52881",
      "parameters": {
        "text": "=Hello {{ $('Lead Sheet - Get Rows from the sheet').item.json['Tool Name'] }} team, \n\nWe can collborate on multiple features. Can we have a quick meet over the meet?\n\nBest regards,\nJanak",
        "options": {},
        "subject": "Let's collaborate!",
        "toEmail": "={{ $('Lead Sheet - Get Rows from the sheet').item.json.Email }}",
        "fromEmail": "support@dolphy.io",
        "emailFormat": "text"
      },
      "executeOnce": false,
      "typeVersion": 2.1
    },
    {
      "id": "2188bf86-d2d8-48c2-9783-954d3c879089",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        1920
      ],
      "parameters": {
        "width": 224,
        "height": 128,
        "content": "## **Send email using SMTP- Any Email Provider works** "
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d5347202-25e6-43fd-aca3-2e53eef114c0",
  "connections": {
    "ecfd047b-fcb8-4e7b-a150-537cc96be2f2": {
      "main": [
        [
          {
            "node": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d8fd0b18-6907-4466-b2f5-d5bd19293da8": {
      "main": [
        [
          {
            "node": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de42e271-8e99-4a09-b189-a0af7b2bbcb2": {
      "main": [
        [
          {
            "node": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5c58d9d4-f19c-44f1-871c-a31dde73f8c3": {
      "main": [
        [
          {
            "node": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8df39dbf-a9c7-4de0-9582-8946a312a35f": {
      "main": [
        [
          {
            "node": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "78f8130a-26ee-4e7b-b749-2c201eb6aca2": {
      "main": [
        [
          {
            "node": "4f251ddb-b669-4b14-8255-ab47ab062516",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6a1c602a-489b-4c83-b2b8-da27bc80718f": {
      "main": [
        [
          {
            "node": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58": {
      "main": [
        [
          {
            "node": "3a2a1244-2870-421b-a27b-ce9dba18eace",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Avanzado - Nutrición de leads

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.

Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos19
Categoría1
Tipos de nodos9
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34