Mi flujo de trabajo 2

Name: Mi flujo de trabajo 2
Rating: 4.5 (10 reviews)
Author: Gaurav

Intermedio

Este es unLead Generationflujo de automatización del dominio deautomatización que contiene 13 nodos.Utiliza principalmente nodos como Filter, HttpRequest, GoogleSheets, SplitInBatches, GoogleSheetsTrigger. Verificación automática de correos electrónicos para Hojas de Google utilizando Rapid Email Verifier

Requisitos previos

•Pueden requerirse credenciales de autenticación para la API de destino
•Credenciales de API de Google Sheets

Nodos utilizados (13)

Categoría

Generación de leads

Vista previa del flujo de trabajo

Visualización de las conexiones entre nodos, con soporte para zoom y panorámica

Monitorear Nuevas Entradas de Correo

Actualizar Resultados de Verificación

Filtrar Correos No Verificados

Procesar Correos en Lotes

Verificar Dirección de Correo

React Flow

Exportar flujo de trabajo

Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo

{
  "id": "O9e1SfXnhax8YZal",
  "meta": {
    "instanceId": "f080fafc9937b6b383f471ad8cc35ad1727032832bd16212f900e0577db46644"
  },
  "name": "My workflow 2",
  "tags": [],
  "nodes": [
    {
      "id": "13f98fdb-07fc-49a9-9362-1eb1bab2e1ee",
      "name": "Monitorear Nuevas Entradas de Correo",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        112,
        544
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyHour"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": "Your Email Verification Spreadsheet"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "28e1409f-e4ef-46aa-b035-a8227d5d6646",
      "name": "Actualizar Resultados de Verificación",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1584,
        544
      ],
      "parameters": {
        "columns": {
          "value": {
            "SrNo": "={{ $('Filter Unverified Emails').item.json.SrNo }}",
            "Email Verified": "={{ $json.status }}"
          },
          "schema": [
            {
              "id": "SrNo",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "SrNo",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Verified",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email Verified",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "SrNo"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": "Your Email Verification Spreadsheet"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "XruFPA2NpYd9OmBT",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "2ee35cec-c0a0-476e-b91e-ee18e586f989",
      "name": "Resumen del Flujo de Trabajo",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 6,
        "width": 416,
        "height": 192,
        "content": "📧 AUTOMATED EMAIL VERIFICATION SYSTEM\n════════════════════════════════════════════════════════════\n✨ Automatically validates email addresses from Google Sheets\n⚡ Real-time verification using rapid-email-verifier API\n📊 Updates spreadsheet with verification status\n🔄 Continuous monitoring with hourly checks\n\n🎯 USE CASES: Lead qualification | Contact list cleaning | Email marketing prep\n"
      },
      "typeVersion": 1
    },
    {
      "id": "601194a5-7ddf-48e4-814d-7f8be5a4cb99",
      "name": "Instrucciones de Configuración",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        0
      ],
      "parameters": {
        "color": 5,
        "width": 416,
        "height": 208,
        "content": "⚙️ QUICK SETUP GUIDE\n═══════════════════════════════════════\n1️⃣ Create Google Sheet with columns:\n   • SrNo | Name | Email | Email Verified\n\n2️⃣ Connect your Google Sheets account\n   \n3️⃣ Update Sheet ID in trigger and update nodes\n\n4️⃣ Test with sample data\n\n💡 TIP: Test with a sample email first!\n"
      },
      "typeVersion": 1
    },
    {
      "id": "99d920b4-a489-4215-8757-0f123f6351e8",
      "name": "Explicación del Activador",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        272
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 192,
        "content": "🚀 MONITORING TRIGGER\n───────────────────────\n• Checks every hour for new rows\n• Only processes newly added entries\n• Automatically handles multiple entries\n• Uses efficient polling to avoid rate limits\n• Connects to your Google Sheets document\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0f7b061a-3410-48a6-bc71-39d93595ff6d",
      "name": "Filtrar Correos No Verificados",
      "type": "n8n-nodes-base.filter",
      "position": [
        528,
        544
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "80aa56a4-b365-448f-9214-71f0ba758947",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['Email Verified'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "0af226e1-ded6-4fb4-b5af-296b02be9c63",
      "name": "Procesar Correos en Lotes",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        832,
        544
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "92f176f5-6cef-4b7f-abd7-0a8bd6b9eda2",
      "name": "Verificar Dirección de Correo",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1216,
        544
      ],
      "parameters": {
        "url": "https://rapid-email-verifier.fly.dev/api/validate",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "email",
              "value": "={{ $json.Email }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "7513234f-b1a3-4fe8-b167-410bb8a6921e",
      "name": "Lógica de Filtrado",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 192,
        "content": "🔍 SMART FILTERING\n─────────────────────\nOnly processes emails that haven't been verified yet\n• Checks if \"Email Verified\" column is empty\n• Prevents duplicate API calls\n• Saves processing time and API credits\n• Ensures efficient workflow execution\n"
      },
      "typeVersion": 1
    },
    {
      "id": "d45072c3-7be3-423a-8afc-f787fc484772",
      "name": "Procesamiento por Lotes",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        752,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 256,
        "height": 224,
        "content": "⚙️ BATCH PROCESSING\n─────────────────────\nProcesses emails one by one to:\n• Respect API rate limits\n• Handle errors gracefully  \n• Ensure reliable verification\n• Track progress per item\n• Maintain data consistency\n"
      },
      "typeVersion": 1
    },
    {
      "id": "e8d919ee-92d1-41b8-8862-6c12e8bff6d5",
      "name": "Detalles de API",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 224,
        "content": "🌐 EMAIL VALIDATION API\n────────────────────────\nrapid-email-verifier.fly.dev\n• Real-time email verification\n• Returns: valid/invalid/unknown\n• Fast response times (<500ms)\n• No authentication required\n• Free tier: 1000 verifications/month\n"
      },
      "typeVersion": 1
    },
    {
      "id": "dc571bb2-e2f0-4a5d-870b-62f388c7609f",
      "name": "Actualización de Resultados",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1472,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 224,
        "content": "✅ RESULTS UPDATE\n──────────────────\nUpdates the original sheet with:\n• Verification status (valid/invalid)\n• Matches by Serial Number\n• Preserves original data\n• Creates audit trail\n• Enables easy filtering\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8e1eeaaf-823b-468b-90c4-6bd03c068a34",
      "name": "Métricas de Rendimiento",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        0
      ],
      "parameters": {
        "color": 7,
        "width": 416,
        "height": 224,
        "content": "📈 WORKFLOW PERFORMANCE  \n────────────────────────────\n• Processes: ~60 emails/hour\n• API Response: <500ms average\n• Accuracy: 95%+ verification rate\n• Cost: Free tier supports 1000/month\n• Memory efficient batch processing\n\n💡 PRO TIP: Use webhook trigger for real-time verification\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a5ff6180-438a-4e77-98ea-372bf7177dc8",
  "connections": {
    "92f176f5-6cef-4b7f-abd7-0a8bd6b9eda2": {
      "main": [
        [
          {
            "node": "28e1409f-e4ef-46aa-b035-a8227d5d6646",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0f7b061a-3410-48a6-bc71-39d93595ff6d": {
      "main": [
        [
          {
            "node": "0af226e1-ded6-4fb4-b5af-296b02be9c63",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "13f98fdb-07fc-49a9-9362-1eb1bab2e1ee": {
      "main": [
        [
          {
            "node": "0f7b061a-3410-48a6-bc71-39d93595ff6d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0af226e1-ded6-4fb4-b5af-296b02be9c63": {
      "main": [
        [],
        [
          {
            "node": "92f176f5-6cef-4b7f-abd7-0a8bd6b9eda2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "28e1409f-e4ef-46aa-b035-a8227d5d6646": {
      "main": [
        [
          {
            "node": "0af226e1-ded6-4fb4-b5af-296b02be9c63",
            "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?

Intermedio - Generació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.