8
n8n Españolamn8n.com

Gestión de boletines informativos (n8n + Bolt.new)

Avanzado

Este es unAI, Marketingflujo de automatización del dominio deautomatización que contiene 43 nodos.Utiliza principalmente nodos como If, Code, Gmail, Merge, Webhook, combinando tecnología de inteligencia artificial para lograr automatización inteligente. Sistema de automatización de comunicaciones laborales (N8N, Bolt.new, RapidAPI, Mails.so & ChatGPT)

Requisitos previos
  • •Cuenta de Google y credenciales de API de Gmail
  • •Punto final de HTTP Webhook (n8n generará automáticamente)
  • •Pueden requerirse credenciales de autenticación para la API de destino
  • •Credenciales de API de Google Sheets
  • •Clave de API de OpenAI

Nodos utilizados (43)

If
Code
Gmail
Merge
Webhook
SplitOut
Aggregate
EmailSend
StickyNote
HttpRequest
GoogleSheets
StopAndError
ScheduleTrigger
OpenAi
RespondToWebhook

Categoría

Inteligencia Artificial
Marketing
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
React Flow
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "ypa8bWM40du6QADu",
  "meta": {
    "instanceId": "b3c467df4053d13fe31cc98f3c66fa1d16300ba750506bfd019a0913cec71ea3",
    "templateCredsSetupCompleted": true
  },
  "name": "Newsletter Management (n8n + Bolt.new)",
  "tags": [],
  "nodes": [
    {
      "id": "e125e5b8-eb83-4907-a149-6975df76fc80",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -280,
        0
      ],
      "webhookId": "5ec8dcf6-b2ba-4fb3-bf62-d253d2f39f02",
      "parameters": {
        "path": "5ec8dcf6-b2ba-4fb3-bf62-d253d2f39f02",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 2
    },
    {
      "id": "7e5fd2a0-5e1b-461c-b24d-bacd248bd471",
      "name": "Confirmar Validez de Email",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        380,
        180
      ],
      "parameters": {
        "url": "=https://api.mails.so/v1/validate?email={{ $('Webhook').item.json.body.email }}",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "x-mails-api-key",
              "value": "\"your-api-key\""
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "fc0c24fd-8243-4892-862e-61d31d62ac0e",
      "name": "Enviar Email1",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        380,
        -160
      ],
      "webhookId": "d8073085-1413-40df-9d78-d7b6190c8101",
      "parameters": {
        "html": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"UTF-8\">\n  <title>You're Already Subscribed</title>\n  <style>\n    body {\n      font-family: Arial, sans-serif;\n      background-color: #f4f7fa;\n      margin: 0;\n      padding: 0;\n    }\n    .container {\n      max-width: 600px;\n      margin: 40px auto;\n      background-color: #ffffff;\n      padding: 40px;\n      border-radius: 10px;\n      box-shadow: 0 10px 30px rgba(0,0,0,0.05);\n    }\n    .header {\n      text-align: center;\n      padding-bottom: 20px;\n    }\n    .header h1 {\n      color: #2d3748;\n      font-size: 22px;\n      margin-bottom: 10px;\n    }\n    .content {\n      font-size: 16px;\n      color: #4a5568;\n      line-height: 1.6;\n    }\n    .footer {\n      margin-top: 40px;\n      font-size: 12px;\n      text-align: center;\n      color: #a0aec0;\n    }\n    .footer a {\n      color: #2b6cb0;\n      text-decoration: none;\n    }\n  </style>\n</head>\n<body>\n  <div class=\"container\">\n    <div class=\"header\">\n      <h1>You're Already Subscribed</h1>\n    </div>\n    <div class=\"content\">\n      <p>Hi there,</p>\n      <p>It looks like someone recently tried to subscribe <strong>your email</strong> to the Jobs 4 U Newsletter.</p>\n      <p>You're already on our list — no further action is needed!</p>\n      <p>If you did not initiate this request, feel free to ignore this email. Your subscription status has not changed.</p>\n      <p>Thank you for staying with us — great opportunities are always heading your way. 🚀</p>\n    </div>\n    <div class=\"footer\">\n      <p>Review our \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app//terms\" target=\"_blank\">Terms & Conditions</a> and \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app//privacy\" target=\"_blank\">Privacy Policy</a>.\n      </p>\n    </div>\n  </div>\n</body>\n</html>\n",
        "options": {},
        "subject": "Already Subscribed to Jobs 4 U",
        "toEmail": "={{ $('Webhook').item.json.body.email }}",
        "fromEmail": "\"your-from-email\""
      },
      "credentials": {
        "smtp": {
          "id": "xcnAVXwtuOa1IOqE",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "c14789f7-06b6-42de-8459-7fd7a30a4b38",
      "name": "If1",
      "type": "n8n-nodes-base.if",
      "position": [
        580,
        180
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "bc3200af-7ae4-4944-b410-ebb459e2d927",
              "operator": {
                "type": "string",
                "operation": "notContains"
              },
              "leftValue": "={{ $json.data.result }}",
              "rightValue": "undeliverable"
            },
            {
              "id": "b0c7d1c3-a733-4547-899e-ff76b66765ad",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.data.mx_record }}",
              "rightValue": "[null]"
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "3b23881d-e393-4686-9356-aa43e08611bf",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1140,
        -160
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.1
    },
    {
      "id": "82960352-541b-49a6-b1f7-114583be0feb",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -300,
        1200
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "a246e968-15be-4492-bbc1-c99a5937d794",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        540,
        1040
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "jobs"
      },
      "executeOnce": false,
      "typeVersion": 1
    },
    {
      "id": "a284e406-f403-4837-abf9-e770d222f773",
      "name": "Merge1",
      "type": "n8n-nodes-base.merge",
      "position": [
        1640,
        1180
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "executeOnce": false,
      "typeVersion": 3.1
    },
    {
      "id": "e8a459f4-e498-42b8-a901-e107864e260c",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1320,
        1040
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "ad32bd78-a7f9-4225-9a8b-410330a5c043",
      "name": "Aggregate1",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1220,
        1320
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "ff46019a-9524-4d0c-954b-4a796c531534",
      "name": "Webhook1",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -280,
        660
      ],
      "webhookId": "709bb303-2c56-456a-b039-db5254c14328",
      "parameters": {
        "path": "709bb303-2c56-456a-b039-db5254c14328",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "347f8cbe-52f4-4f99-81d0-99e93c4860fc",
      "name": "obtener filas en hoja de todos los suscriptores",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        660
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.body.email }}",
              "lookupColumn": "Email Address"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=0",
          "cachedResultName": "All Subscribers"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "de531168-450e-4177-9c88-6bdeb51170b8",
      "name": "cambiar estado a no suscrito",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        160,
        660
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email Address": "={{ $json['Email Address'] }}",
            "Subscription Status": "Unsubscribed"
          },
          "schema": [
            {
              "id": "Email Address",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email Address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Subscribe Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Subscribe Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Subscription Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Subscription Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email Address"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=0",
          "cachedResultName": "All Subscribers"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "6202d3eb-4f86-4b19-84c9-50a02f136cac",
      "name": "agregar a hoja de no suscritos",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        380,
        660
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $('get rows in all subscribers sheet').item.json.Name }}",
            "Email Address": "={{ $json['Email Address'] }}"
          },
          "schema": [
            {
              "id": "Email Address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1629686868,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=1629686868",
          "cachedResultName": "Unsubscribed"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "e567a35a-83be-48aa-bca6-7f560b18ad0a",
      "name": "obtener fila en hoja de suscritos",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        600,
        660
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json['Email Address'] }}",
              "lookupColumn": "Email Address"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1253191037,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=1253191037",
          "cachedResultName": "Subscribed"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "1fad75fe-83a6-4a1d-a235-0890cbc7932f",
      "name": "eliminar fila de suscritos",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        820,
        660
      ],
      "parameters": {
        "operation": "delete",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1253191037,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=1253191037",
          "cachedResultName": "Subscribed"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        },
        "startIndex": "={{ $json.row_number }}"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "150912ac-0735-4e09-a04e-4dfa2e98def8",
      "name": "Obtener Suscriptores",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -120,
        1200
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1253191037,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=1253191037",
          "cachedResultName": "Subscribed"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "3f79310b-2609-43b7-b5f4-9b355b9dd5aa",
      "name": "Obtener Empleos",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        320,
        1040
      ],
      "parameters": {
        "url": "https://jobs-search-api.p.rapidapi.com/getjobs",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"search_term\": \"product manager\",\n  \"location\": \"remote\",\n  \"results_wanted\": 10,\n  \"site_name\": [\n    \"indeed\",\n    \"linkedin\",\n    \"zip_recruiter\",\n    \"glassdoor\"\n  ],\n  \"distance\": 0,\n  \"job_type\": \"fulltime\",\n  \"is_remote\": true,\n  \"linkedin_fetch_description\": true,\n  \"hours_old\": 24\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "x-rapidapi-host",
              "value": "jobs-search-api.p.rapidapi.com"
            },
            {
              "name": "x-rapidapi-key",
              "value": "\"your-rapid-api-key\""
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "59c28a80-2863-4a60-b846-5fbf02507140",
      "name": "Resumir Descripciones de Empleo",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        960,
        1040
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-3.5-turbo",
          "cachedResultName": "GPT-3.5-TURBO"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Summarize this job description to one sentences: {{ $json.description }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "DO9F6MAeTGLeqgoF",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "6fb33d05-c609-460a-8302-e87628380bc4",
      "name": "Formatear Boletín",
      "type": "n8n-nodes-base.code",
      "position": [
        1820,
        1180
      ],
      "parameters": {
        "jsCode": "// HTML Newsletter Generation Function for n8n\n// This function formats the aggregated job data into an HTML newsletter\n\nfunction generateNewsletter() {\n  // Get current date for the newsletter\n  const currentDate = new Date().toLocaleDateString('en-US', {\n    weekday: 'long',\n    year: 'numeric',\n    month: 'long',\n    day: 'numeric'\n  });\n  \n  // Start building the HTML newsletter\n  let htmlContent = `\n  <!DOCTYPE html>\n  <html lang=\"en\">\n  <head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <title>Job Opportunities Newsletter</title>\n    <style>\n      body {\n        font-family: Arial, sans-serif;\n        line-height: 1.6;\n        color: #333;\n        max-width: 800px;\n        margin: 0 auto;\n        padding: 20px;\n      }\n      .header {\n        background-color: #0066cc;\n        color: white;\n        padding: 20px;\n        text-align: center;\n        border-radius: 5px 5px 0 0;\n      }\n      .job-listing {\n        border: 1px solid #ddd;\n        padding: 15px;\n        margin-bottom: 20px;\n        border-radius: 5px;\n        background-color: #f9f9f9;\n      }\n      .job-title {\n        color: #0066cc;\n        margin-top: 0;\n        margin-bottom: 5px;\n        font-size: 18px;\n      }\n      .job-company {\n        font-weight: bold;\n        margin-bottom: 5px;\n      }\n      .job-details {\n        margin-bottom: 10px;\n        font-size: 14px;\n        color: #666;\n      }\n      .job-description {\n        margin-bottom: 15px;\n      }\n      .job-salary {\n        font-weight: bold;\n        color: #4CAF50;\n      }\n      .job-link {\n        display: inline-block;\n        background-color: #0066cc;\n        color: white;\n        padding: 8px 15px;\n        text-decoration: none;\n        border-radius: 3px;\n        margin-top: 10px;\n      }\n      .job-link:hover {\n        background-color: #004c99;\n      }\n      .footer {\n        background-color: #f5f5f5;\n        border-top: 1px solid #ddd;\n        padding: 20px;\n        margin-top: 30px;\n        border-radius: 0 0 5px 5px;\n      }\n      .footer-logo {\n        text-align: center;\n        margin-bottom: 15px;\n      }\n      .footer-logo a {\n        color: #0066cc;\n        font-size: 24px;\n        font-weight: bold;\n        text-decoration: none;\n      }\n      .footer-links {\n        text-align: center;\n        margin-bottom: 15px;\n      }\n      .footer-links a {\n        color: #666;\n        text-decoration: none;\n        margin: 0 15px;\n        font-size: 14px;\n      }\n      .footer-links a:hover {\n        text-decoration: underline;\n      }\n      .unsubscribe {\n        text-align: center;\n        font-size: 12px;\n        color: #999;\n      }\n      .unsubscribe a {\n        color: #999;\n        text-decoration: underline;\n      }\n    </style>\n  </head>\n  <body>\n    <div class=\"header\">\n      <h1>Top Job Opportunities</h1>\n      <p>${currentDate}</p>\n    </div>\n    <div class=\"content\">\n      <p>Hello ${$('Get Subscribers').first().json.Name}, here are the latest Jobs 4 U:</p>\n  `;\n  \n  // Loop through each job (0 to 9) to add to the newsletter\n  for (let i = 0; i < 10; i++) {\n    // Only include jobs that actually exist in the data\n    if ($('Aggregate1').first().json.data[i] && $('Aggregate1').first().json.data[i].title) {\n      // Get job details from Aggregate1 node\n      const title = $('Aggregate1').first().json.data[i].title || 'No Title';\n      const company = $('Aggregate1').first().json.data[i].company || 'Company not specified';\n      const location = $('Aggregate1').first().json.data[i].location || 'Location not specified';\n      const currency = $('Aggregate1').first().json.data[i].currency || '';\n      const minAmount = $('Aggregate1').first().json.data[i].min_amount || 'Not specified';\n      const maxAmount = $('Aggregate1').first().json.data[i].max_amount || 'Not specified';\n      const datePosted = $('Aggregate1').first().json.data[i].date_posted || 'Date not specified';\n      const jobUrl = $('Aggregate1').first().json.data[i].job_url || '#';\n      \n      // Get job description from Aggregate node\n      const description = $('Aggregate').first().json.data[i]?.message?.content || 'No description available';\n      \n      // Add this job to the HTML content\n      htmlContent += `\n        <div class=\"job-listing\">\n          <h2 class=\"job-title\">${title}</h2>\n          <div class=\"job-company\">${company}</div>\n          <div class=\"job-details\">\n            <span>${location}</span> • \n            <span>Posted: ${datePosted}</span>\n          </div>\n          <div class=\"job-description\">\n            ${description}\n          </div>\n          <div class=\"job-salary\">\n            Salary: ${currency}${minAmount} - ${currency}${maxAmount}\n          </div>\n          <a href=\"${jobUrl}\" class=\"job-link\" target=\"_blank\">Apply Now</a>\n        </div>\n      `;\n    }\n  }\n  \n  // Add the improved footer\n  htmlContent += `\n      <div class=\"footer\">\n        <div class=\"footer-logo\">\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/\">Job 4 U</a>\n        </div>\n        <div class=\"footer-links\">\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/terms\">Terms of Service</a>\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/privacy\">Privacy Policy</a>\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/\">Contact Us</a>\n        </div>\n        <div class=\"unsubscribe\">\n          <p>Don't want to receive these emails? <a href=\"https://magnificent-tanuki-11356e.netlify.app/unsubscribe?email=${$('Get Subscribers').first().json['Email Address']}\">Unsubscribe</a></p>\n        </div>\n      </div>\n    </div>\n  </body>\n  </html>\n  `;\n  \n  // Return the formatted HTML newsletter\n  return { htmlNewsletter: htmlContent };\n}\n\n// Return the generated newsletter\nreturn generateNewsletter();"
      },
      "typeVersion": 2
    },
    {
      "id": "f4814333-4ec8-4dc0-bedc-df24f54d5abe",
      "name": "Obtener Todos los Suscriptores",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        0
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.body.email }}",
              "lookupColumn": "Email Address"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=0",
          "cachedResultName": "All Subscribers"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "419bfccb-9d98-4a62-961b-a537ffbc121f",
      "name": "Si el email ya está en la base de datos",
      "type": "n8n-nodes-base.if",
      "position": [
        160,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "3a5acb6e-d1bb-4b9b-b5db-a0ba52910750",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.row_number }}",
              "rightValue": ""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "62936656-05ba-4492-9cb3-e924c510c689",
      "name": "Enviar Email de Bienvenida",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        780,
        -320
      ],
      "webhookId": "29812df7-d962-495a-b1fe-f755968dc932",
      "parameters": {
        "html": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"UTF-8\">\n  <title>Welcome to Jobs 4 U Newsletter</title>\n  <style>\n    body {\n      font-family: Arial, sans-serif;\n      background-color: #f4f7fa;\n      margin: 0;\n      padding: 0;\n    }\n    .container {\n      max-width: 600px;\n      margin: 40px auto;\n      background-color: #ffffff;\n      padding: 40px;\n      border-radius: 10px;\n      box-shadow: 0 10px 30px rgba(0,0,0,0.05);\n    }\n    .header {\n      text-align: center;\n      padding-bottom: 20px;\n    }\n    .header h1 {\n      color: #2d3748;\n      font-size: 24px;\n      margin-bottom: 10px;\n    }\n    .content {\n      font-size: 16px;\n      color: #4a5568;\n      line-height: 1.6;\n    }\n    .button {\n      display: inline-block;\n      margin-top: 20px;\n      padding: 12px 24px;\n      background-color: #2b6cb0;\n      color: white;\n      text-decoration: none;\n      border-radius: 6px;\n      font-weight: bold;\n    }\n    .footer {\n      margin-top: 40px;\n      font-size: 12px;\n      text-align: center;\n      color: #a0aec0;\n    }\n    .footer a {\n      color: #2b6cb0;\n      text-decoration: none;\n    }\n  </style>\n</head>\n<body>\n  <div class=\"container\">\n    <div class=\"header\">\n      <h1>Welcome to the Jobs Newsletter!</h1>\n    </div>\n    <div class=\"content\">\n      <p>Hi {{ $('Webhook').item.json.body.name }},</p>\n      <p>Thanks for subscribing to the <strong>Jobs 4 U Newsletter</strong>! 🧑‍💻</p>\n      <p>Each week, you'll receive handpicked job opportunities straight to your inbox — from remote roles to top-tier tech companies looking for talent just like you.</p>\n      <p>Stay tuned and keep an eye on your inbox. We’re excited to help you take the next step in your career!</p>\n      <p>If you ever want to unsubscribe, you can do so at the bottom of any email we send.</p>\n    </div>\n    <div class=\"footer\">\n      <p>By subscribing, you agree to our \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app/terms\" target=\"_blank\">Terms & Conditions</a> and \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app/privacy\" target=\"_blank\">Privacy Policy</a>.\n      </p>\n      <p>Happy job hunting! 🚀</p>\n    </div>\n  </div>\n</body>\n</html>\n",
        "options": {
          "appendAttribution": false
        },
        "subject": "Welcome to Jobs 4 U Newsletter",
        "toEmail": "={{ $('Webhook').item.json.body.email }}",
        "fromEmail": "\"your-from-email\""
      },
      "credentials": {
        "smtp": {
          "id": "xcnAVXwtuOa1IOqE",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "f0e80aea-bd08-4a58-b8ae-89782a9662a5",
      "name": "Agregar Email a Hoja de Todos los Suscriptores",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        780,
        -160
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $('Webhook').item.json.body.name }}",
            "Email Address": "={{ $('Webhook').item.json.body.email }}",
            "Subscribe Date": "={{ $now.toFormat('yyyy-MM-dd') }}",
            "Subscription Status": "Subscribed"
          },
          "schema": [
            {
              "id": "Email Address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Subscribe Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Subscribe Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Subscription Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Subscription Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=0",
          "cachedResultName": "All Subscribers"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "cb8d80f2-06d5-4409-a896-e802cc32dab5",
      "name": "Agregar Email a Hoja de Suscritos",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        780,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $('Webhook').item.json.body.name }}",
            "Email Address": "={{ $('Webhook').item.json.body.email }}"
          },
          "schema": [
            {
              "id": "Email Address",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email Address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email Address"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1253191037,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit#gid=1253191037",
          "cachedResultName": "Subscribed"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jSVIqvy74zfz106k-16tFCFTU-l2c5buNxHvKKBgQCw/edit?usp=drivesdk",
          "cachedResultName": "Jobs 4 U Newsletter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "d0qeLhShx9sGXalR",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "5a877277-10be-4076-887d-f23477222dbb",
      "name": "Notificación de Existencia Prevía",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        540,
        -320
      ],
      "parameters": {
        "options": {},
        "respondWith": "text",
        "responseBody": "=Email Already Exists!\nHello  {{ $('Webhook').item.json.body.name }}, your email '{{ $('Webhook').item.json.body.email }}' already exists on our database."
      },
      "typeVersion": 1.2
    },
    {
      "id": "51152701-7da3-499e-84dc-eb3fda51cc50",
      "name": "Notificación de Email Inválido",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        780,
        280
      ],
      "parameters": {
        "options": {},
        "respondWith": "text",
        "responseBody": "=Invalid Email! \nHi {{ $('Webhook').item.json.body.name }}, we are unable to process this email \"{{ $('Webhook').item.json.body.email }}\" and add it to our subscribers database. Please confirm if it right."
      },
      "typeVersion": 1.2
    },
    {
      "id": "dc2166ef-eb75-4203-a88a-6d10009eb19e",
      "name": "Notificación de Suscripción Exitosa",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        1340,
        -160
      ],
      "parameters": {
        "options": {},
        "respondWith": "text",
        "responseBody": "=Success!\n\nYou are good to go {{ $('Webhook').item.json.body.name }}. We have sent you a welcome email. Good  Luck! If you can't see it, please check your spam folder and mark it as not spam."
      },
      "typeVersion": 1.2
    },
    {
      "id": "59497004-29f0-4ef5-9cc6-5b5ff43b8cf5",
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        -420
      ],
      "parameters": {
        "width": 1920,
        "height": 900,
        "content": "## Manage Subscriptions with bolt.new frontend"
      },
      "typeVersion": 1
    },
    {
      "id": "0de46767-048c-4c0f-972a-6e14e05921ea",
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        960
      ],
      "parameters": {
        "color": 4,
        "width": 2540,
        "height": 560,
        "content": "## Scrap Jobs, Format Newsletter and Send to Subscribers"
      },
      "typeVersion": 1
    },
    {
      "id": "f0d3506b-8a79-44c7-b2a3-206d32f03749",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        560
      ],
      "parameters": {
        "color": 3,
        "width": 1700,
        "height": 320,
        "content": "## Manage Unsubscriptions"
      },
      "typeVersion": 1
    },
    {
      "id": "add9d4b3-e004-44ea-8055-a206a3a367f2",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "disabled": true,
      "position": [
        2420,
        1200
      ],
      "webhookId": "f94f14d3-bb4b-4162-bac5-7de53c838420",
      "parameters": {
        "sendTo": "={{ $('Get Subscribers').item.json['Email Address'] }}",
        "message": "={{ $json.htmlNewsletter }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "Latest Jobs 4 U"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "ckS0CnhtgC3I5ETk",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "3d879853-1a3b-4612-a65d-1f8710a5e3f0",
      "name": "Nota Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2340,
        1120
      ],
      "parameters": {
        "color": 5,
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Newsletter)"
      },
      "typeVersion": 1
    },
    {
      "id": "e5c32535-c5e7-44d2-81fb-481108f726bd",
      "name": "Stop and Error",
      "type": "n8n-nodes-base.stopAndError",
      "position": [
        320,
        1300
      ],
      "parameters": {
        "errorMessage": "No Subscribers Found"
      },
      "typeVersion": 1
    },
    {
      "id": "d6c2a737-5cb9-4ba8-81e6-72d0fb280780",
      "name": "Si hay suscriptores",
      "type": "n8n-nodes-base.if",
      "position": [
        60,
        1200
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "846d11d1-a02d-4bc8-a316-6bc020874304",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json['Email Address'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "ca6c833f-04fe-4979-9221-949e6acc52e7",
      "name": "Enviar Boletín",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2000,
        1180
      ],
      "webhookId": "bfaa8f6c-a5af-482c-ab21-ca7b087cdd17",
      "parameters": {
        "html": "={{ $json.htmlNewsletter }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "Latest Jobs 4 U",
        "toEmail": "={{ $('If there are subscribers').item.json['Email Address'] }}",
        "fromEmail": "\"your-from-email\""
      },
      "credentials": {
        "smtp": {
          "id": "xcnAVXwtuOa1IOqE",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "49e25db4-3183-4afc-ad93-5a681d27ff8b",
      "name": "Enviar Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1040,
        660
      ],
      "webhookId": "2ddcc7d7-6df2-478a-a3b4-add24024387a",
      "parameters": {
        "html": "=<!DOCTYPE html>\n<html>\n  <head>\n    <meta charset=\"UTF-8\" />\n    <title>Hello {{ $('get row in subscribed sheet').item.json.Name }}, You’ve Been Unsubscribed from Jobs 4 U Newsletter</title>\n    <style>\n      body {\n        font-family: Arial, sans-serif;\n        background-color: #f6f9fc;\n        margin: 0;\n        padding: 0;\n      }\n      .email-container {\n        max-width: 600px;\n        margin: 40px auto;\n        background-color: #ffffff;\n        border-radius: 8px;\n        overflow: hidden;\n        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.06);\n      }\n      .header {\n        background-color: #1a73e8;\n        color: #ffffff;\n        padding: 24px;\n        text-align: center;\n      }\n      .header h1 {\n        margin: 0;\n        font-size: 24px;\n      }\n      .content {\n        padding: 32px;\n        color: #333333;\n        font-size: 16px;\n        line-height: 1.6;\n      }\n      .content p {\n        margin: 0 0 16px;\n      }\n      .footer {\n        font-size: 12px;\n        color: #888888;\n        text-align: center;\n        padding: 24px;\n        background-color: #f1f1f1;\n      }\n      .footer a {\n        color: #888888;\n        text-decoration: none;\n        margin: 0 8px;\n      }\n    </style>\n  </head>\n  <body>\n    <div class=\"email-container\">\n      <div class=\"header\">\n        <h1>Jobs 4 U</h1>\n      </div>\n      <div class=\"content\">\n        <p>Hi there,</p>\n        <p>\n          You've been successfully unsubscribed from the <strong>Jobs 4 U</strong> newsletter. We're sorry to see you go.\n        </p>\n        <p>\n          If this was a mistake, you're always welcome to subscribe again anytime to get the latest software engineering jobs right in your inbox.\n        </p>\n        <p>Wishing you all the best in your career journey!</p>\n        <p>— The Jobs 4 U Team</p>\n      </div>\n      <div class=\"footer\">\n        <p>\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/terms\">Terms & Conditions</a> |\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/privacy\">Privacy Policy</a>\n        </p>\n        <p>&copy; 2025 Jobs 4 U. All rights reserved.</p>\n      </div>\n    </div>\n  </body>\n</html>\n",
        "options": {},
        "subject": "You have unsubscribed from Jobs 4 U",
        "toEmail": "={{ $('add to unsubscribed sheet').item.json['Email Address'] }}",
        "fromEmail": "\"your-from-email\""
      },
      "credentials": {
        "smtp": {
          "id": "xcnAVXwtuOa1IOqE",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "cc9f78ed-8de0-436c-a164-a0b151517f13",
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "disabled": true,
      "position": [
        1540,
        680
      ],
      "webhookId": "f94f14d3-bb4b-4162-bac5-7de53c838420",
      "parameters": {
        "sendTo": "={{ $('add to unsubscribed sheet').item.json['Email Address'] }}",
        "message": "=<!DOCTYPE html>\n<html>\n  <head>\n    <meta charset=\"UTF-8\" />\n    <title>Hello {{ $('get row in subscribed sheet').item.json.Name }}, You’ve Been Unsubscribed from Jobs 4 U Newsletter</title>\n    <style>\n      body {\n        font-family: Arial, sans-serif;\n        background-color: #f6f9fc;\n        margin: 0;\n        padding: 0;\n      }\n      .email-container {\n        max-width: 600px;\n        margin: 40px auto;\n        background-color: #ffffff;\n        border-radius: 8px;\n        overflow: hidden;\n        box-shadow: 0 4px 10px rgba(0, 0, 0, 0.06);\n      }\n      .header {\n        background-color: #1a73e8;\n        color: #ffffff;\n        padding: 24px;\n        text-align: center;\n      }\n      .header h1 {\n        margin: 0;\n        font-size: 24px;\n      }\n      .content {\n        padding: 32px;\n        color: #333333;\n        font-size: 16px;\n        line-height: 1.6;\n      }\n      .content p {\n        margin: 0 0 16px;\n      }\n      .footer {\n        font-size: 12px;\n        color: #888888;\n        text-align: center;\n        padding: 24px;\n        background-color: #f1f1f1;\n      }\n      .footer a {\n        color: #888888;\n        text-decoration: none;\n        margin: 0 8px;\n      }\n    </style>\n  </head>\n  <body>\n    <div class=\"email-container\">\n      <div class=\"header\">\n        <h1>Jobs 4 U</h1>\n      </div>\n      <div class=\"content\">\n        <p>Hi there,</p>\n        <p>\n          You've been successfully unsubscribed from the <strong>Jobs 4 U</strong> newsletter. We're sorry to see you go.\n        </p>\n        <p>\n          If this was a mistake, you're always welcome to subscribe again anytime to get the latest software engineering jobs right in your inbox.\n        </p>\n        <p>Wishing you all the best in your career journey!</p>\n        <p>— The Jobs 4 U Team</p>\n      </div>\n      <div class=\"footer\">\n        <p>\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/terms\">Terms & Conditions</a> |\n          <a href=\"https://magnificent-tanuki-11356e.netlify.app/privacy\">Privacy Policy</a>\n        </p>\n        <p>&copy; 2025 Jobs 4 U. All rights reserved.</p>\n      </div>\n    </div>\n  </body>\n</html>\n",
        "options": {
          "appendAttribution": false
        },
        "subject": "You have unsubscribed from Jobs 4 U"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "ckS0CnhtgC3I5ETk",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "22152918-e32b-40c0-8924-c4f4f854b290",
      "name": "Nota Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1460,
        600
      ],
      "parameters": {
        "color": 5,
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Unscubscription)"
      },
      "typeVersion": 1
    },
    {
      "id": "ed07df99-2c29-4229-a094-83eae1d77965",
      "name": "Gmail2",
      "type": "n8n-nodes-base.gmail",
      "disabled": true,
      "position": [
        1780,
        -240
      ],
      "webhookId": "f94f14d3-bb4b-4162-bac5-7de53c838420",
      "parameters": {
        "sendTo": "={{ $('Webhook').item.json.body.email }}",
        "message": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"UTF-8\">\n  <title>You're Already Subscribed</title>\n  <style>\n    body {\n      font-family: Arial, sans-serif;\n      background-color: #f4f7fa;\n      margin: 0;\n      padding: 0;\n    }\n    .container {\n      max-width: 600px;\n      margin: 40px auto;\n      background-color: #ffffff;\n      padding: 40px;\n      border-radius: 10px;\n      box-shadow: 0 10px 30px rgba(0,0,0,0.05);\n    }\n    .header {\n      text-align: center;\n      padding-bottom: 20px;\n    }\n    .header h1 {\n      color: #2d3748;\n      font-size: 22px;\n      margin-bottom: 10px;\n    }\n    .content {\n      font-size: 16px;\n      color: #4a5568;\n      line-height: 1.6;\n    }\n    .footer {\n      margin-top: 40px;\n      font-size: 12px;\n      text-align: center;\n      color: #a0aec0;\n    }\n    .footer a {\n      color: #2b6cb0;\n      text-decoration: none;\n    }\n  </style>\n</head>\n<body>\n  <div class=\"container\">\n    <div class=\"header\">\n      <h1>You're Already Subscribed</h1>\n    </div>\n    <div class=\"content\">\n      <p>Hi there,</p>\n      <p>It looks like someone recently tried to subscribe <strong>your email</strong> to the Jobs 4 U Newsletter.</p>\n      <p>You're already on our list — no further action is needed!</p>\n      <p>If you did not initiate this request, feel free to ignore this email. Your subscription status has not changed.</p>\n      <p>Thank you for staying with us — great opportunities are always heading your way. 🚀</p>\n    </div>\n    <div class=\"footer\">\n      <p>Review our \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app//terms\" target=\"_blank\">Terms & Conditions</a> and \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app//privacy\" target=\"_blank\">Privacy Policy</a>.\n      </p>\n    </div>\n  </div>\n</body>\n</html>\n",
        "options": {
          "appendAttribution": false
        },
        "subject": "Already Subscribed to Jobs 4 U"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "ckS0CnhtgC3I5ETk",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "a37b27ce-a796-40b7-8fa0-8ab2fd276b6d",
      "name": "Nota Adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1700,
        -320
      ],
      "parameters": {
        "color": 5,
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Email Exists)"
      },
      "typeVersion": 1
    },
    {
      "id": "e01f3884-309e-4e04-ad5f-77acd08a42d2",
      "name": "Gmail3",
      "type": "n8n-nodes-base.gmail",
      "disabled": true,
      "position": [
        1780,
        220
      ],
      "webhookId": "f94f14d3-bb4b-4162-bac5-7de53c838420",
      "parameters": {
        "sendTo": "={{ $('Webhook').item.json.body.email }}",
        "message": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"UTF-8\">\n  <title>Welcome to Jobs 4 U Newsletter</title>\n  <style>\n    body {\n      font-family: Arial, sans-serif;\n      background-color: #f4f7fa;\n      margin: 0;\n      padding: 0;\n    }\n    .container {\n      max-width: 600px;\n      margin: 40px auto;\n      background-color: #ffffff;\n      padding: 40px;\n      border-radius: 10px;\n      box-shadow: 0 10px 30px rgba(0,0,0,0.05);\n    }\n    .header {\n      text-align: center;\n      padding-bottom: 20px;\n    }\n    .header h1 {\n      color: #2d3748;\n      font-size: 24px;\n      margin-bottom: 10px;\n    }\n    .content {\n      font-size: 16px;\n      color: #4a5568;\n      line-height: 1.6;\n    }\n    .button {\n      display: inline-block;\n      margin-top: 20px;\n      padding: 12px 24px;\n      background-color: #2b6cb0;\n      color: white;\n      text-decoration: none;\n      border-radius: 6px;\n      font-weight: bold;\n    }\n    .footer {\n      margin-top: 40px;\n      font-size: 12px;\n      text-align: center;\n      color: #a0aec0;\n    }\n    .footer a {\n      color: #2b6cb0;\n      text-decoration: none;\n    }\n  </style>\n</head>\n<body>\n  <div class=\"container\">\n    <div class=\"header\">\n      <h1>Welcome to the Jobs Newsletter!</h1>\n    </div>\n    <div class=\"content\">\n      <p>Hi {{ $('Webhook').item.json.body.name }},</p>\n      <p>Thanks for subscribing to the <strong>Jobs 4 U Newsletter</strong>! 🧑‍💻</p>\n      <p>Each week, you'll receive handpicked job opportunities straight to your inbox — from remote roles to top-tier tech companies looking for talent just like you.</p>\n      <p>Stay tuned and keep an eye on your inbox. We’re excited to help you take the next step in your career!</p>\n      <p>If you ever want to unsubscribe, you can do so at the bottom of any email we send.</p>\n    </div>\n    <div class=\"footer\">\n      <p>By subscribing, you agree to our \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app/terms\" target=\"_blank\">Terms & Conditions</a> and \n        <a href=\"https://magnificent-tanuki-11356e.netlify.app/privacy\" target=\"_blank\">Privacy Policy</a>.\n      </p>\n      <p>Happy job hunting! 🚀</p>\n    </div>\n  </div>\n</body>\n</html>\n",
        "options": {
          "appendAttribution": false
        },
        "subject": "Welcome to Jobs 4 U Newsletter"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "ckS0CnhtgC3I5ETk",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "b4c5f6d4-7fad-45b7-ba78-d95b16bd181e",
      "name": "Nota Adhesiva6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1700,
        140
      ],
      "parameters": {
        "color": 5,
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Welcome Email)"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "59aa6d34-959e-4fc3-bd54-f7b2f4c5b075",
  "connections": {
    "c14789f7-06b6-42de-8459-7fd7a30a4b38": {
      "main": [
        [
          {
            "node": "62936656-05ba-4492-9cb3-e924c510c689",
            "type": "main",
            "index": 0
          },
          {
            "node": "f0e80aea-bd08-4a58-b8ae-89782a9662a5",
            "type": "main",
            "index": 0
          },
          {
            "node": "cb8d80f2-06d5-4409-a896-e802cc32dab5",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "51152701-7da3-499e-84dc-eb3fda51cc50",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3b23881d-e393-4686-9356-aa43e08611bf": {
      "main": [
        [
          {
            "node": "dc2166ef-eb75-4203-a88a-6d10009eb19e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a284e406-f403-4837-abf9-e770d222f773": {
      "main": [
        [
          {
            "node": "6fb33d05-c609-460a-8302-e87628380bc4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e125e5b8-eb83-4907-a149-6975df76fc80": {
      "main": [
        [
          {
            "node": "f4814333-4ec8-4dc0-bedc-df24f54d5abe",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3f79310b-2609-43b7-b5f4-9b355b9dd5aa": {
      "main": [
        [
          {
            "node": "a246e968-15be-4492-bbc1-c99a5937d794",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ff46019a-9524-4d0c-954b-4a796c531534": {
      "main": [
        [
          {
            "node": "347f8cbe-52f4-4f99-81d0-99e93c4860fc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e8a459f4-e498-42b8-a901-e107864e260c": {
      "main": [
        [
          {
            "node": "a284e406-f403-4837-abf9-e770d222f773",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a246e968-15be-4492-bbc1-c99a5937d794": {
      "main": [
        [
          {
            "node": "59c28a80-2863-4a60-b846-5fbf02507140",
            "type": "main",
            "index": 0
          },
          {
            "node": "ad32bd78-a7f9-4225-9a8b-410330a5c043",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ad32bd78-a7f9-4225-9a8b-410330a5c043": {
      "main": [
        [
          {
            "node": "a284e406-f403-4837-abf9-e770d222f773",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "fc0c24fd-8243-4892-862e-61d31d62ac0e": {
      "main": [
        [
          {
            "node": "5a877277-10be-4076-887d-f23477222dbb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "150912ac-0735-4e09-a04e-4dfa2e98def8": {
      "main": [
        [
          {
            "node": "d6c2a737-5cb9-4ba8-81e6-72d0fb280780",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "82960352-541b-49a6-b1f7-114583be0feb": {
      "main": [
        [
          {
            "node": "150912ac-0735-4e09-a04e-4dfa2e98def8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6fb33d05-c609-460a-8302-e87628380bc4": {
      "main": [
        [
          {
            "node": "ca6c833f-04fe-4979-9221-949e6acc52e7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "62936656-05ba-4492-9cb3-e924c510c689": {
      "main": [
        [
          {
            "node": "3b23881d-e393-4686-9356-aa43e08611bf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f4814333-4ec8-4dc0-bedc-df24f54d5abe": {
      "main": [
        [
          {
            "node": "419bfccb-9d98-4a62-961b-a537ffbc121f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7e5fd2a0-5e1b-461c-b24d-bacd248bd471": {
      "main": [
        [
          {
            "node": "c14789f7-06b6-42de-8459-7fd7a30a4b38",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d6c2a737-5cb9-4ba8-81e6-72d0fb280780": {
      "main": [
        [
          {
            "node": "3f79310b-2609-43b7-b5f4-9b355b9dd5aa",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "e5c32535-c5e7-44d2-81fb-481108f726bd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6202d3eb-4f86-4b19-84c9-50a02f136cac": {
      "main": [
        [
          {
            "node": "e567a35a-83be-48aa-bca6-7f560b18ad0a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "59c28a80-2863-4a60-b846-5fbf02507140": {
      "main": [
        [
          {
            "node": "e8a459f4-e498-42b8-a901-e107864e260c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1fad75fe-83a6-4a1d-a235-0890cbc7932f": {
      "main": [
        [
          {
            "node": "49e25db4-3183-4afc-ad93-5a681d27ff8b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e567a35a-83be-48aa-bca6-7f560b18ad0a": {
      "main": [
        [
          {
            "node": "1fad75fe-83a6-4a1d-a235-0890cbc7932f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cb8d80f2-06d5-4409-a896-e802cc32dab5": {
      "main": [
        [
          {
            "node": "3b23881d-e393-4686-9356-aa43e08611bf",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "de531168-450e-4177-9c88-6bdeb51170b8": {
      "main": [
        [
          {
            "node": "6202d3eb-4f86-4b19-84c9-50a02f136cac",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "419bfccb-9d98-4a62-961b-a537ffbc121f": {
      "main": [
        [
          {
            "node": "fc0c24fd-8243-4892-862e-61d31d62ac0e",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "7e5fd2a0-5e1b-461c-b24d-bacd248bd471",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "347f8cbe-52f4-4f99-81d0-99e93c4860fc": {
      "main": [
        [
          {
            "node": "de531168-450e-4177-9c88-6bdeb51170b8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f0e80aea-bd08-4a58-b8ae-89782a9662a5": {
      "main": [
        [
          {
            "node": "3b23881d-e393-4686-9356-aa43e08611bf",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}
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 - Inteligencia Artificial, Marketing

¿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.

Flujos de trabajo relacionados recomendados

Extracción y enriquecimiento de datos de prospectos de LinkedIn
Generar y enriquecer leads de LinkedIn con Apollo.io, API de LinkedIn, Mail.so y GPT-3.5
If
Set
Code
+
If
Set
Code
53 NodosJoseph
Ventas
Generador de videos cortos para pruebas
Usar Sonnet 3.5, Pinecone y Creatomate para generar videos cortos de acertijos y publicar en YouTube
If
Code
Wait
+
If
Code
Wait
32 NodosJoseph
Otros
MailChimpautomatización
基于AIde餐厅通讯generador，integraciónMailchimpyTelegram审批
If
Set
Code
+
If
Set
Code
43 NodosFemi Ad
Inteligencia Artificial
Automatización de publicación de contenido RSS en publicaciones de blog con GPT-4o, WordPress y LinkedIn
Usar GPT-4o, WordPress y LinkedIn para automatizar la publicación de contenido RSS en artículos de blog
If
Set
Code
+
If
Set
Code
40 NodosImmanuel
Inteligencia Artificial
Crea y aprueba videos POV usando IA, ElevenLabs y publicación multiplataforma
Usa AI, ElevenLabs y publicación multiplataforma para crear y aprobar videos POV (TikTok/IG/YT)
If
Set
Code
+
If
Set
Code
60 NodosImmanuel
Diseño
Explorar nodos de n8n en la biblioteca de referencias visuales
Explorar nodos de n8n en la base de referencia visual
If
Ftp
Set
+
If
Ftp
Set
113 NodosI versus AI
Otros
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos43
Categoría2
Tipos de nodos15
Descripción de la dificultad

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

Autor
Joseph

Joseph

@mjomba

Automation expert specializing in building smart, scalable workflows using tools like n8n, Make, and Airtable. I help businesses save time, reduce manual work, and grow faster with tailored automation solutions. Feel free to reach out at joseph@uppfy.com to discuss your project. I am also on x.com/juppfy

Enlaces externos
Ver en n8n.io →

Compartir este flujo de trabajo

Categorías

IA Multimodal
1540
Inteligencia Artificial
1108
Creación de contenido
695
Resumen de IA
516
Marketing
419
Chatbot de IA
251
Ingeniería
241
Investigación de mercado
203
Varios
193
Otros
176
Ventas
162
Operaciones de TI
156
Extracción de documentos
147
RAG de IA
146
Bloques de construcción
144
Redes sociales
137
Generación de leads
125
Productividad personal
117
DevOps
111
Recursos Humanos
101
Soporte
97
Nutrición de leads
87
CRM
82
Finanzas
81
Producto
77
Chatbot de soporte
76
Diseño
70
Gestión de tickets
67
Operaciones de seguridad
57
Procesamiento de facturas
53
Comercio de criptomonedas
49
Gestión de archivos
39
Gestión de proyectos
35
Wiki interno
32

Categorías: 34