8
n8n Françaisamn8n.com

E-mail personnalisé

Intermédiaire

Ceci est unLead Nurturing, Multimodal AIworkflow d'automatisation du domainecontenant 8 nœuds.Utilise principalement des nœuds comme If, Set, GoogleSheets, ScheduleTrigger, ChainLlm. Utiliser Gemini AI et Google Sheets pour créer des e-mails de prospection commerciale personnalisés

Prérequis
  • •Informations d'identification Google Sheets API
  • •Clé API Google Gemini

Nœuds utilisés (8)

If
Set
GoogleSheets
ScheduleTrigger
ChainLlm
LmChatGoogleGemini
OutputParserStructured

Catégorie

Nurturing de leads
IA Multimodale
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
{
  "name": "Personalised Mail",
  "nodes": [
    {
      "id": "c3a221a2-d3e3-47f3-a897-6781a29857a4",
      "name": "Lire les prospects depuis la feuille",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -400,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "Your_Sheet_GID",
          "cachedResultUrl": "Your_Sheet_URL",
          "cachedResultName": "Your_Sheet_Name"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_SPREADSHEET_ID_HERE",
          "cachedResultUrl": "Your_Spreadsheet_URL",
          "cachedResultName": "Your_Spreadsheet_Name"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Your_Credentials_Id",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "23b2b8e8-e26c-4586-9ec1-dba83ab0069c",
      "name": "Préparer les données pour la feuille",
      "type": "n8n-nodes-base.set",
      "position": [
        400,
        0
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "updated_email",
              "value": "={{ $input.item.json.text }}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "7e937d3d-3483-442e-b89c-57ce699609ed",
      "name": "Mettre à jour la feuille avec l'e-mail",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $('Read Leads from Sheet').item.json.Email }}",
            "subject": "= {{ $json.output.subject }}",
            "email_body": "={{ $json.output.email_body }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Location",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Education",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Education",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LinkedIn_Connections",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "LinkedIn_Connections",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry_Focus",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Industry_Focus",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Key_Expertise",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Key_Expertise",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LinkedIn_URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "LinkedIn_URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company_Type",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company_Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Focus_Areas",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Focus_Areas",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Growth_Stage",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Growth_Stage",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Pain_Points",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Pain_Points",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Location_Opportunities",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Location_Opportunities",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email_Template",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email_Template",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LinkedIn_DM_Template",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "LinkedIn_DM_Template",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company_Website",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company_Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email_body",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "email_body",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "subject",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "subject",
              "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"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "Your_Sheet_GID",
          "cachedResultUrl": "Your_Sheet_URL",
          "cachedResultName": "Your_Sheet_Name"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "=1p6vuSjRfTiSUrPa3CR4wQA8c9NyuS18K2UMhP_bWx08"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Your_Credentials_Id",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
      "name": "Chaîne LLM de base",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        40,
        0
      ],
      "parameters": {
        "text": "=You are an expert email copywriter for Intuz, a company offering AI Engineering and AI Service solutions.\n\nYour task is to generate the components for a single, concise, professional, and conversational email outreach (100-120 words).\n\n---\n**CONTEXT & DATA**\n*   Prospect Name: {{ $('Read Leads from Sheet').item.json.Name }}\n*   Company Name: {{ $('Read Leads from Sheet').item.json.Company }}\n*   Persona / Title: {{ $('Read Leads from Sheet').item.json.Title }}\n*   CTA Link: [https://calendly.com/YOUR_LINK]\n\n---\n**INSTRUCTIONS**\n*   **Pain Point:** Focus on one of these: slow AI feature rollouts, difficulty integrating AI, scaling challenges, or security concerns.\n*   **Value Proposition:** Highlight how Intuz's AI Engineering services solve that specific pain point (e.g., rapid development, seamless integration, scalable workflows).\n*   **Structure:** The email body must start with a question addressing the pain point, briefly explain the solution, and end with a CTA for a 15-minute call using the provided link.\n*   **Tone:** Conversational, empathetic, and professional.\n*   **Subject Line:** Generate a catchy, question-based subject line (under 8 words) tied to the pain point.\n*   **Personalization:** Use the prospect's data to tailor the message.\n*   **CRITICAL FORMATTING:** Structure the `email_body` into 3 distinct paragraphs. Use the markdown newline character `\\n\\n` to separate each paragraph for clean spacing and readability.\n*   **Constraints:** Keep the body 100-120 words. No salutation (e.g., \"Hi Tobias,\") or sign-off (e.g., \"Best,\") should be included in the email body.\n\n---\n**REQUIRED OUTPUT**\nYou MUST format your response as a valid JSON object containing two keys: \"subject\" and \"email_body\".",
        "batching": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.7
    },
    {
      "id": "3434b60b-85ea-4221-94c4-3abf64f8ff17",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        60,
        220
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.5-flash"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "Your_Gemini_API",
          "name": "Your Google Gemini API"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e62f603b-d063-4f90-9d13-ce599b536bed",
      "name": "Analyseur de sortie structurée",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        180,
        220
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"subject\": \"A short, catchy, question-based subject line\",\n  \"email_body\": \"The full email body, 100-120 words, without any salutation or sign-off.\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "323a2628-a30a-4b20-8a56-2d0677c6c5af",
      "name": "Déclencheur programmé",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -620,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 30
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cbca8f8d-959d-45b9-a801-20386034a844",
      "name": "Si",
      "type": "n8n-nodes-base.if",
      "position": [
        -180,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "0640b75d-662e-4625-a038-92c099b79f25",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.email_body }}",
              "rightValue": ""
            },
            {
              "id": "6d30f170-03fd-4e89-9a56-ab87e8c7c01a",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.subject }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "cbca8f8d-959d-45b9-a801-20386034a844": {
      "main": [
        [
          {
            "node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9120c44a-92a4-4f06-83a5-045bd7e17a07": {
      "main": [
        [
          {
            "node": "23b2b8e8-e26c-4586-9ec1-dba83ab0069c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "323a2628-a30a-4b20-8a56-2d0677c6c5af": {
      "main": [
        [
          {
            "node": "c3a221a2-d3e3-47f3-a897-6781a29857a4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c3a221a2-d3e3-47f3-a897-6781a29857a4": {
      "main": [
        [
          {
            "node": "cbca8f8d-959d-45b9-a801-20386034a844",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "23b2b8e8-e26c-4586-9ec1-dba83ab0069c": {
      "main": [
        [
          {
            "node": "7e937d3d-3483-442e-b89c-57ce699609ed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7e937d3d-3483-442e-b89c-57ce699609ed": {
      "main": [
        []
      ]
    },
    "3434b60b-85ea-4221-94c4-3abf64f8ff17": {
      "ai_languageModel": [
        [
          {
            "node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "e62f603b-d063-4f90-9d13-ce599b536bed": {
      "ai_outputParser": [
        [
          {
            "node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}
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é ?

Intermédiaire - Nurturing de leads, IA Multimodale

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

Génération automatique de propositions Upwork en temps réel avec Apify, Google Gemini et Sheets
Utiliser Apify, Google Gemini et Sheets pour automatiser la génération de propositions Upwork IA
If
Set
Gmail
+
If
Set
Gmail
25 NœudsIntuz
Génération de leads
Recherche de profils LinkedIn en temps réel et prospection AI (avec Apify, Gemini et Sheets)
Utiliser Apify, Gemini et Sheets pour automatiser la recherche de profils LinkedIn et le e-mailing
If
Limit
Google Sheets
+
If
Limit
Google Sheets
20 NœudsIntuz
Génération de leads
Génération automatisée de prospects IA LinkedIn pour les emplois avec Apify, Apollo.io et Google Gemini
Automatisation de la génération de prospects d'offres d'emploi LinkedIn : Apify, Apollo.io et Google Gemini
If
Code
Limit
+
If
Code
Limit
47 NœudsIntuz
Génération de leads
Développement terminé - Extraction de contenu FAX
Flux de travail d'extraction de données de fax et de PDF : utilisation de Google Gemini et Google Sheets
Set
Code
Form Trigger
+
Set
Code
Form Trigger
18 NœudsIntuz
Création de contenu
Moteur automatisé de contenu viral pour LinkedIn et X
Création et publication automatique de contenu viral pour LinkedIn et X avec l'IA
If
Set
Wait
+
If
Set
Wait
156 NœudsDiptamoy Barman
Création de contenu
Génération de blog WordPress optimisé pour le SEO avec Gemini, Tavily et une révision humaine
Utiliser Gemini, Tavily et une révision manuelle pour générer des articles de blog WordPress optimisés SEO
If
Set
Code
+
If
Set
Code
38 NœudsAryan Shinde
Création de contenu
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds8
Catégorie2
Types de nœuds7
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
Intuz

Intuz

@intuz

A boutique tech consulting company, helping businesses with custom AI/ML, Workflow Automations, and software development.

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