8
n8n Françaisamn8n.com

Outil d'envoi de masse d'e-froid automatisé avec Gmail, SMTP et Google Sheets

Intermédiaire

Ceci est unLead Nurturingworkflow d'automatisation du domainecontenant 12 nœuds.Utilise principalement des nœuds comme If, Wait, Gmail, Limit, EmailSend. Expéditeur automatisé de campagnes d'emailing en masse, en utilisant Gmail, SMTP et Google Sheets

Prérequis
  • •Compte Google et informations d'identification Gmail API
  • •Informations d'identification Google Sheets API

Nœuds utilisés (12)

If
Wait
Gmail
Limit
EmailSend
StickyNote
GoogleSheets
SplitInBatches
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
{
  "meta": {
    "instanceId": "28099d2544433ae0f39c65315a4d4c531947fcb0f060a94d6047d7be5df31063",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
      "name": "Boucle sur les éléments",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -560,
        160
      ],
      "parameters": {
        "options": {},
        "batchSize": "=1"
      },
      "typeVersion": 3
    },
    {
      "id": "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2",
      "name": "Limite",
      "type": "n8n-nodes-base.limit",
      "position": [
        -760,
        360
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "630c46c1-bf9a-4634-8ce2-a5bd054d1813",
      "name": "Si",
      "type": "n8n-nodes-base.if",
      "position": [
        -380,
        260
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "8dc5b028-6f5d-4d76-8852-99180bfb4591",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json['Email Address '] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "f6834735-f169-4ba4-86de-9ed5c7221628",
      "name": "Mettre à jour les enregistrements",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        60,
        260
      ],
      "parameters": {
        "columns": {
          "value": {
            "Sent on": "={{ $now }}",
            "Message Id": "={{ $json.id }}",
            "Email Sent ": "Yes",
            "Email Address ": "={{ $('If').first().json['Email Address '] }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Address ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email Address ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Sender Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Sender Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Subject",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Body",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Body",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Sent ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Sent ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Sent on",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Sent on",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message Id",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message Id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email Address "
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit?usp=drivesdk",
          "cachedResultName": "Bulk Sender Template"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "NdBpgqV7UHdZ3CZc",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "6dd38853-6493-4677-8db2-0df6497aee42",
      "name": "Envoyer un e-mail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -140,
        260
      ],
      "webhookId": "2add08f1-0af8-4951-af47-721d2c4302ec",
      "parameters": {
        "sendTo": "={{ $json['Email Address '] }}",
        "message": "={{ $json['Email Body'] }}",
        "options": {},
        "subject": "={{ $json['Email Subject'] }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "Fd6oTce3HQiRi3dG",
          "name": "electrabot.info@gmail.com"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "6f4402a7-7519-444f-81a6-fc2600f936cd",
      "name": "Obtenir les e-mails",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -940,
        360
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "No",
              "lookupColumn": "Email Sent "
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit?usp=drivesdk",
          "cachedResultName": "Bulk Sender Template"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "NdBpgqV7UHdZ3CZc",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "bdf30635-0665-40cd-bfee-b507c3a67f49",
      "name": "Définir une minuterie",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1120,
        360
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 6
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6",
      "name": "Attendre",
      "type": "n8n-nodes-base.wait",
      "position": [
        280,
        340
      ],
      "webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
      "parameters": {
        "amount": 10
      },
      "typeVersion": 1.1
    },
    {
      "id": "e69107b7-6e00-4854-81cf-17da9b09b5af",
      "name": "connect",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -1120,
        160
      ],
      "webhookId": "49772db0-f2ab-4f5a-9b20-5b4f097f301c",
      "parameters": {
        "text": "={{ $json['Email body'] }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "={{ $json['Email subject'] }}",
        "toEmail": "={{ $json['Email Address '] }}",
        "fromEmail": "={{ $json['Sender email '] }}",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "PnCWFLAx6sFw8ynW",
          "name": "team@electrabot.space"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "960aca19-606e-409b-b187-b1269bfdc907",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1180,
        -40
      ],
      "parameters": {
        "width": 1660,
        "height": 620,
        "content": "# Email Sender"
      },
      "typeVersion": 1
    },
    {
      "id": "85ac89d1-f0b8-4899-98d0-495db2f0018c",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1480,
        -40
      ],
      "parameters": {
        "width": 300,
        "height": 620,
        "content": "## 1. Setup Guide\n*  ### Configure the timer node to your desired execution frequency.\n* ### Duplicate the provided [Google Sheet Template](https://docs.google.com/spreadsheets/d/1TjXelyGPg5G8lbPDI9_XOReTzmU1o52z2R3v8dYaoQM/edit?usp=sharing).\n* ### Link the duplicated sheet within both the \"Get Emails\" and \"Update Record\" nodes.\n* ### Select your preferred email sending node and use the \"Limit\" node to manage the volume of emails dispatched.\n\n## 2. Help\n* ### For detailed instructions, please refer to our [Detailed Setup Guide](https://drive.google.com/file/d/1o95RjqpwH_FZc28ajgxJJj5j3u6IyO0w/view?usp=sharing).\n* ### If you require further assistance, contact us via Email at [info.gainflow@gmail.com](mailto:info.gainflow@gmail.com).\n* ### Discover additional practical workflows by clicking [HERE](https://docs.google.com/document/d/1RACo90h-QwKA4hEZSlOQZsyw4iB5-43JM2l0s4lpuoY/edit?usp=sharing)."
      },
      "typeVersion": 1
    },
    {
      "id": "e6679e6b-cb5f-4b31-a05d-87b31dfe018e",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1160,
        60
      ],
      "parameters": {
        "color": 3,
        "width": 320,
        "height": 260,
        "content": "## Utilize this node for non-Google email services."
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "630c46c1-bf9a-4634-8ce2-a5bd054d1813": {
      "main": [
        [
          {
            "node": "6dd38853-6493-4677-8db2-0df6497aee42",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6": {
      "main": [
        [
          {
            "node": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2": {
      "main": [
        [
          {
            "node": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bdf30635-0665-40cd-bfee-b507c3a67f49": {
      "main": [
        [
          {
            "node": "6f4402a7-7519-444f-81a6-fc2600f936cd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6f4402a7-7519-444f-81a6-fc2600f936cd": {
      "main": [
        [
          {
            "node": "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6dd38853-6493-4677-8db2-0df6497aee42": {
      "main": [
        [
          {
            "node": "f6834735-f169-4ba4-86de-9ed5c7221628",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f6834735-f169-4ba4-86de-9ed5c7221628": {
      "main": [
        [
          {
            "node": "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6afb72ca-c815-4fca-9125-f77d78bc46aa": {
      "main": [
        [],
        [
          {
            "node": "630c46c1-bf9a-4634-8ce2-a5bd054d1813",
            "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é ?

Intermédiaire - 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

Automatisation de la prospection par e-mail
Séquence de suivi des e-mails gratuite avec Google Sheets et Gmail
If
Set
Html
+
If
Set
Html
18 NœudsGerald Denor
Nurturing de leads
Envoi automatisé de messages de bienvenue WhatsApp à partir de Google Sheets avec Rapiwa API
Envoi automatisé de messages de bienvenue WhatsApp aux prospects via Google Sheets et Rapiwa
If
Code
Wait
+
If
Code
Wait
17 NœudsSpaGreen Creative
Nurturing de leads
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Génération de froid mailing
Utiliser Apollo, Apify et GPT pour automatiser le développement de prospects B2B et les e-mails froids personnalisés
If
Wait
Gmail
+
If
Wait
Gmail
24 NœudsMirai
Processus de scraping et de contact Apollo 1 ✅
Génération automatisée de prospects avec Apollo, analyse IA et suivi par e-mail programmé
If
Code
Wait
+
If
Code
Wait
39 NœudsDeniz
Création de contenu
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
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds12
Catégorie1
Types de nœuds9
Description de la difficulté

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

Auteur
Gain FLow AI

Gain FLow AI

@gain-flow

GainFlow AI is your go-to AI automation agency, specializing in Python and no-code solutions to eliminate repetitive tasks for individuals and businesses. Free up your time and boost efficiency. For inquiries, Fill this form - https://docs.google.com/forms/d/e/1FAIpQLSfIiXdw4HMcI2HM-Obng13j_RFiKv7X-mjOVm_mcy2ucRA8EA/viewform or reach out to us at info.gainflow@gmail.com.

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