8
n8n Françaisamn8n.com

Gestion de newsletter (n8n + Bolt.new)

Avancé

Ceci est unAI, Marketingworkflow d'automatisation du domainecontenant 43 nœuds.Utilise principalement des nœuds comme If, Code, Gmail, Merge, Webhook, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Système d'automatisation de communication pour les offres d'emploi (N8N, Bolt.new, RapidAPI, Mails.so & ChatGPT)

Prérequis
  • •Compte Google et informations d'identification Gmail API
  • •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
  • •Peut nécessiter les informations d'identification d'authentification de l'API cible
  • •Informations d'identification Google Sheets API
  • •Clé API OpenAI

Nœuds utilisés (43)

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

Catégorie

Intelligence Artificielle
Marketing
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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": "Vérifier la validité de l'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": "Envoyer 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": "Fusionner",
      "type": "n8n-nodes-base.merge",
      "position": [
        1140,
        -160
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.1
    },
    {
      "id": "82960352-541b-49a6-b1f7-114583be0feb",
      "name": "Déclencheur planifié",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -300,
        1200
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "a246e968-15be-4492-bbc1-c99a5937d794",
      "name": "Diviser",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        540,
        1040
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "jobs"
      },
      "executeOnce": false,
      "typeVersion": 1
    },
    {
      "id": "a284e406-f403-4837-abf9-e770d222f773",
      "name": "Fusionner1",
      "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": "Agréger",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1320,
        1040
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "ad32bd78-a7f9-4225-9a8b-410330a5c043",
      "name": "Agréger1",
      "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": "obtenir les lignes de la feuille tous les abonnés",
      "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": "changer le statut en désabonné",
      "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": "ajouter à la feuille désabonnés",
      "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": "obtenir la ligne dans la feuille abonnés",
      "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": "supprimer la ligne des abonnés",
      "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": "Obtenir les abonnés",
      "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": "Obtenir les offres d'emploi",
      "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": "Résumer les descriptions d'emploi",
      "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": "Formater la newsletter",
      "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": "Obtenir tous les abonnés",
      "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 l'email existe déjà en base",
      "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": "Envoyer l'email de bienvenue",
      "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": "Ajouter l'email à la feuille tous les abonnés",
      "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": "Ajouter l'email à la feuille abonnés",
      "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": "Notification d'existence déjà avérée",
      "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": "Notification d'email invalide",
      "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": "Notification d'abonnement réussi",
      "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": "Note adhésive",
      "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": "Note adhésive1",
      "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": "Note adhésive2",
      "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": "Note adhésive3",
      "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": "Arrêt et erreur",
      "type": "n8n-nodes-base.stopAndError",
      "position": [
        320,
        1300
      ],
      "parameters": {
        "errorMessage": "No Subscribers Found"
      },
      "typeVersion": 1
    },
    {
      "id": "d6c2a737-5cb9-4ba8-81e6-72d0fb280780",
      "name": "S'il y a des abonnés",
      "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": "Envoyer la newsletter",
      "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": "Envoyer l'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": "Note adhésive4",
      "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": "Note adhésive5",
      "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": "Note adhésive6",
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Intelligence Artificielle, Marketing

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Extraction de prospects LinkedIn et enrichissement de données
Génération et enrichissement de prospects LinkedIn en utilisant Apollo.io, LinkedIn API, Mail.so et GPT-3.5
If
Set
Code
+
If
Set
Code
53 NœudsJoseph
Ventes
Générateur de vidéos de quiz
Utiliser Sonnet 3.5, Pinecone et Creatomate pour générer des vidéos courtes d'énigmes et les publier sur YouTube
If
Code
Wait
+
If
Code
Wait
32 NœudsJoseph
Autres
MailChimpautomatisation
Générateur de newsletter de restaurant basé sur l'IA, intégrant Mailchimp et l'approbation via Telegram
If
Set
Code
+
If
Set
Code
43 NœudsFemi Ad
Intelligence Artificielle
Publication automatisée de contenu RSS de blog avec GPT-4o, WordPress et LinkedIn
Publication automatisée de contenu RSS en articles de blog avec GPT-4o, WordPress et LinkedIn
If
Set
Code
+
If
Set
Code
40 NœudsImmanuel
Intelligence Artificielle
Créer et approuver des vidéos POV en utilisant l'IA, ElevenLabs et une publication multiplateforme
Créer et approuver des vidéos POV (TikTok/IG/YT) avec IA, ElevenLabs et publication multiplateforme
If
Set
Code
+
If
Set
Code
60 NœudsImmanuel
Design
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds43
Catégorie2
Types de nœuds15
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
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

Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34