8
n8n Françaisamn8n.com

Automatisation des e-froid/e-chaud

Avancé

Ceci est unLead Nurturingworkflow d'automatisation du domainecontenant 19 nœuds.Utilise principalement des nœuds comme If, Set, Hunter, EmailSend, GoogleSheets. Campagne automatisée d'emailing froid, en utilisant Google Sheets, la validation d'email et SMTP

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

Nœuds utilisés (19)

If
Set
NoOp
Hunter
EmailSend
StickyNote
GoogleSheets
ManualTrigger
ScheduleTrigger

Catégorie

Nurturing de leads
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": "0NUf4DsJtFfnyxnp",
  "meta": {
    "instanceId": "b575ae39acc98e53d75e50d1b5147e8b0922704c4aeb3230092d8e2a78247bc3"
  },
  "name": "Cold/Warm Email Automation",
  "tags": [],
  "nodes": [
    {
      "id": "8df39dbf-a9c7-4de0-9582-8946a312a35f",
      "name": "Au clic sur 'Exécuter le workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        432,
        1392
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3adc0f15-d7a2-4b23-b36d-eb0361167446",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        2096
      ],
      "parameters": {
        "color": 7,
        "height": 256,
        "content": "## **Find out SMTP info for your email service provider Link** \n\nhttps://docs.google.com/document/d/1UnAYprKmGWHQ7VDpzdMndV7-iPl1sVlIIke3GY5O8e0/edit?usp=sharing"
      },
      "typeVersion": 1
    },
    {
      "id": "42a71dd2-654d-48ca-9e89-619402f9b65a",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        1584
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 208,
        "content": "## **Step-by-Step Tutorial YouTube Video Link** \n\n\nhttps://youtu.be/Dg68OaYPhYs?si=LVu9pdxt9JUuCrzM"
      },
      "typeVersion": 1
    },
    {
      "id": "bb87b350-c396-4cd4-a266-1b58300cf261",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1584
      ],
      "parameters": {
        "color": 7,
        "width": 224,
        "height": 224,
        "content": "## **Sample Google Sheet for  Leads I used.** \n\nhttps://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=sharing \n\n\n- "
      },
      "typeVersion": 1
    },
    {
      "id": "5a7e7b8a-30ef-43fa-a290-23ccff275628",
      "name": "Déclencheur programmé à 9h",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        176,
        1392
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
      "name": "Feuille de Leads - Récupérer les lignes de la feuille",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        640,
        1392
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=drivesdk",
          "cachedResultName": "Leads"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "3a2a1244-2870-421b-a27b-ce9dba18eace",
      "name": "Mise à jour GSheet si l'email est 'Envoyé'",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2320,
        1744
      ],
      "parameters": {
        "columns": {
          "value": {
            "Tool Name": "={{ $('Google Sheets').item.json['Tool Name'] }}",
            "Email Sent": "={{ $json.accepted[0] }}"
          },
          "schema": [
            {
              "id": "Tool Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Tool Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Tool Link",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Tool Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Link to Apply Affiliate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Link to Apply Affiliate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "How to Work",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "How to Work",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Affiliate Link to Share",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Affiliate Link to Share",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Coupon Code",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Coupon Code",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Reach Out Mode",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Reach Out Mode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "How did you find?",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "How did you find?",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Reach Out Platform",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Reach Out Platform",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Incoming",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Incoming",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Script",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Script",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Sent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Ideas",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Ideas",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Tool Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2051398108,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit#gid=2051398108",
          "cachedResultName": "AI tool reachout"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit?usp=drivesdk",
          "cachedResultName": "CF Calendar"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.6
    },
    {
      "id": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
      "name": "Vérificateur - Les emails sont-ils vérifiés ou non ?",
      "type": "n8n-nodes-base.if",
      "position": [
        1568,
        1584
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.result }}",
              "rightValue": "undeliverable"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "935d4058-b2e9-43f1-a887-defb038948c3",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        1760
      ],
      "parameters": {
        "width": 208,
        "height": 192,
        "content": "## **Add Email Verification API** \n\nI use hunter, https://hunter.io/api-keys\n\nYou can use any other tools"
      },
      "typeVersion": 1
    },
    {
      "id": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
      "name": "Création du champ pour mettre à jour 'Envoyé' dans G Sheet1",
      "type": "n8n-nodes-base.set",
      "position": [
        2096,
        1744
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "05814c14-4365-4c37-af55-f28bf2ee5819",
              "name": "accepted[0]",
              "type": "string",
              "value": "Sent"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4f251ddb-b669-4b14-8255-ab47ab062516",
      "name": "Aucune opération, ne rien faire5",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1872,
        1424
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
      "name": "Vérification d'email via Hunter",
      "type": "n8n-nodes-base.hunter",
      "position": [
        1312,
        1584
      ],
      "parameters": {
        "email": "={{ $json.Email }}",
        "operation": "emailVerifier"
      },
      "typeVersion": 1
    },
    {
      "id": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
      "name": "Vérificateur - Déjà 'Envoyé' ou non ?",
      "type": "n8n-nodes-base.if",
      "position": [
        864,
        1392
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c72a013e-7b22-4bc7-a6c6-d51e9804ece7",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json['Email Sent'] }}",
              "rightValue": "Sent"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
      "name": "Vérificateur - Le champ 'Email' du lead est-il vide ?",
      "type": "n8n-nodes-base.if",
      "position": [
        1088,
        1488
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
      "name": "Aucune opération, ne rien faire",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1040,
        1296
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
      "name": "Aucune opération, ne rien faire1",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1312,
        1392
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d98f7325-01c6-4e62-acc9-ca6bee188d39",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1232
      ],
      "parameters": {
        "width": 224,
        "height": 128,
        "content": "## **Connect with Google Sheet or CRM** "
      },
      "typeVersion": 1
    },
    {
      "id": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
      "name": "Envoyer l'email via SMTP",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1872,
        1744
      ],
      "webhookId": "3a2cb249-8183-4481-8df7-5fcdd2c52881",
      "parameters": {
        "text": "=Hello {{ $('Lead Sheet - Get Rows from the sheet').item.json['Tool Name'] }} team, \n\nWe can collborate on multiple features. Can we have a quick meet over the meet?\n\nBest regards,\nJanak",
        "options": {},
        "subject": "Let's collaborate!",
        "toEmail": "={{ $('Lead Sheet - Get Rows from the sheet').item.json.Email }}",
        "fromEmail": "support@dolphy.io",
        "emailFormat": "text"
      },
      "executeOnce": false,
      "typeVersion": 2.1
    },
    {
      "id": "2188bf86-d2d8-48c2-9783-954d3c879089",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        1920
      ],
      "parameters": {
        "width": 224,
        "height": 128,
        "content": "## **Send email using SMTP- Any Email Provider works** "
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d5347202-25e6-43fd-aca3-2e53eef114c0",
  "connections": {
    "ecfd047b-fcb8-4e7b-a150-537cc96be2f2": {
      "main": [
        [
          {
            "node": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d8fd0b18-6907-4466-b2f5-d5bd19293da8": {
      "main": [
        [
          {
            "node": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de42e271-8e99-4a09-b189-a0af7b2bbcb2": {
      "main": [
        [
          {
            "node": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5c58d9d4-f19c-44f1-871c-a31dde73f8c3": {
      "main": [
        [
          {
            "node": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8df39dbf-a9c7-4de0-9582-8946a312a35f": {
      "main": [
        [
          {
            "node": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "78f8130a-26ee-4e7b-b749-2c201eb6aca2": {
      "main": [
        [
          {
            "node": "4f251ddb-b669-4b14-8255-ab47ab062516",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6a1c602a-489b-4c83-b2b8-da27bc80718f": {
      "main": [
        [
          {
            "node": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58": {
      "main": [
        [
          {
            "node": "3a2a1244-2870-421b-a27b-ce9dba18eace",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
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é - Nurturing de leads

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

Suivi des invitations LinkedIn automatisées avec Browserflow et Google Sheets
Utiliser Browserflow et Google Sheets pour suivre les invitations LinkedIn automatisées
If
Set
Wait
+
If
Set
Wait
23 NœudsStéphane Heckel
Nurturing de leads
Campagne automatisée de marketing par e-froid avec modèles aléatoires et suivi via Google Sheets
Campagne automatisée d'emailing froid avec des modèles aléatoires et suivi via Google Sheets
If
Set
Code
+
If
Set
Code
20 NœudsAnir Agram
Nurturing de leads
Automatisation du SEO YouTube 1
Générer du contenu SEO YouTube et des vignettes à partir de scripts vidéo avec GPT-4o et Runway
If
Set
Code
+
If
Set
Code
19 NœudsJanak Patel
Création de contenu
Bloc de résumé d'article WordPress généré par IA
Bloc de résumé d'article WordPress généré par IA
If
Set
Slack
+
If
Set
Slack
32 NœudsDataki
Intelligence Artificielle
Tableaux Noco avec priorisation par IA
Utiliser l'IA pour assigner des requêtes et envoyer des rappels en fonction de l'état du tableau de bord NocoDB
If
Set
Slack
+
If
Set
Slack
27 NœudsŁukasz
Support
Préparation automatique de la refinement agile avec Gmail, OpenAI et Google Sheets
Utiliser Gmail, OpenAI et Google Sheets pour automatiser la préparation du raffinement Agile
If
Set
Gmail
+
If
Set
Gmail
51 NœudsWillemijn
Produit
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds19
Catégorie1
Types de nœuds9
Description de la difficulté

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

Auteur
Janak Patel

Janak Patel

@dolphyai
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