Envoi automatisé de masse d'e-mails avec suivi des réponses et des réponses
Intermédiaire
Ceci est unSocial Media, Multimodal AIworkflow d'automatisation du domainecontenant 11 nœuds.Utilise principalement des nœuds comme If, Gmail, Switch, GoogleSheets, EmailReadImap. Envoi automatisé de masse d'e-mails avec suivi et traçage des réponses
Prérequis
- •Compte Google et informations d'identification Gmail API
- •Informations d'identification Google Sheets API
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"id": "8urb5ud9FW5of1Ct",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Automated Email Blast with Follow-Ups & Response Tracking",
"tags": [],
"nodes": [
{
"id": "263d7a2a-0185-47b5-a58b-c00a0f756dcc",
"name": "Déclencheur quotidien",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-80,
-485
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "d5b54189-9981-4b23-afa1-d8c2007ce94d",
"name": "Récupérer les données de contacts",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-485
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"name": "Itérer les contacts",
"type": "n8n-nodes-base.splitInBatches",
"position": [
360,
-485
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "55ff15d6-15ed-4197-b2b4-98df8695f98c",
"name": "Déterminer l'étape de suivi",
"type": "n8n-nodes-base.if",
"onError": "continueErrorOutput",
"position": [
580,
-560
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8533f0cb-5664-4ba3-ac35-46587194560d",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Reply }}",
"rightValue": "no"
}
]
}
},
"typeVersion": 2.2,
"alwaysOutputData": true
},
{
"id": "11f2e1b6-0f21-4d5b-aced-a4c45e29f970",
"name": "Router par étape de suivi",
"type": "n8n-nodes-base.switch",
"position": [
800,
-560
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bde52b5f-b028-4849-acd0-fd976bbae44d",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json['Follow-up'] }}",
"rightValue": 6
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1a69881c-21ce-4cb7-9c17-f5ed0e5dd6ac",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json['Follow-up'] }}",
"rightValue": 7
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "2dbd64d3-ec48-4992-a25e-f665d4f04001",
"name": "Envoyer l'email de suivi 1",
"type": "n8n-nodes-base.gmail",
"position": [
1020,
-660
],
"webhookId": "3844e21b-95b7-4e7c-81ef-5e49a9e8a6f1",
"parameters": {
"sendTo": "={{ $json['User Email'] }}",
"message": "Testing-6",
"options": {
"appendAttribution": false
},
"subject": "Testing-6",
"emailType": "text",
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 2.1
},
{
"id": "c2ed8d92-11c0-49df-87c2-191917a18a9b",
"name": "Envoyer l'email de suivi 2",
"type": "n8n-nodes-base.gmail",
"position": [
1020,
-460
],
"webhookId": "0e770d89-aadf-4a63-a769-f142de4da2e2",
"parameters": {
"sendTo": "={{ $json['User Email'] }}",
"message": "Testing-7",
"options": {
"appendAttribution": false
},
"subject": "Testing-7",
"emailType": "text",
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 2.1
},
{
"id": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"name": "Mettre à jour la feuille avec le statut de suivi",
"type": "n8n-nodes-base.googleSheets",
"position": [
1240,
-460
],
"parameters": {
"columns": {
"value": {
"Reply": "={{ $('Route by Follow-Up Stage').item.json.Reply }}",
"Follow-up": "={{ $('Route by Follow-Up Stage').item.json['Follow-up'] + 1}}",
"Send Mail": "=yes (Follow-up = {{ $('Route by Follow-Up Stage').item.json['Follow-up'] }}) ",
"User Name": "={{ $('Route by Follow-Up Stage').item.json['User Name'] }}",
"Inquiry ID": "={{ $('Route by Follow-Up Stage').item.json['Inquiry ID'] }}",
"User Email": "={{ $('Route by Follow-Up Stage').item.json['User Email'] }}",
"Follow-up Type": "Email",
"Submission Date": "={{ new Date($now).toISOString().split('T')[0] }}",
"Next Follow-up Date": "={{ new Date(Date.now() + 3 * 24 * 60 * 60 * 1000).toISOString().split('T')[0] }}"
},
"schema": [
{
"id": "User Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "User Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "User Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "User Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Inquiry ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Inquiry ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reply",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Reply",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Follow-up",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Follow-up",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send Mail",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Send Mail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Follow-up Type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Follow-up Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Communication Mode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Communication Mode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comment",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Requirement Doc",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Requirement Doc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Workflow Diagram",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Workflow Diagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Test Cases",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Test Cases",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Call Schedule",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Call Schedule",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Submission Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Submission Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next Follow-up Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Next Follow-up Date",
"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": "autoMapInputData",
"matchingColumns": [
"User Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "009b187a-a8b6-4748-bc9a-2e7dcd69f233",
"name": "Vérifier les réponses aux emails",
"type": "n8n-nodes-base.emailReadImap",
"position": [
-80,
-200
],
"parameters": {
"options": {
"customEmailConfig": "[\"UNSEEN\", [\"SUBJECT\", \"Testing\"]]"
}
},
"credentials": {
"imap": {
"id": "D3nLrSlP1dHWcIDE",
"name": "IMAP account"
}
},
"typeVersion": 2
},
{
"id": "91e87156-bd84-4df5-ad9e-11089af50c02",
"name": "Mettre à jour la feuille avec la réponse",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-200
],
"parameters": {
"columns": {
"value": {
"reply": "=yes",
"user email": "={{ $json.from }}"
},
"schema": [
{
"id": "user name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "user name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "user email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "user email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reply",
"type": "string",
"display": true,
"required": false,
"displayName": "reply",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followup",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "followup",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send mail",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Send mail",
"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": [
"user email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "a599605e-e3a6-412c-a221-cc73d87d7d74",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-960
],
"parameters": {
"color": 4,
"width": 920,
"height": 240,
"content": "## Node Details\n- **Daily Trigger - 9 AM**: Triggers the workflow daily at 9 AM using a Cron schedule.\n- **Read Contact Data from Google Sheet**: Reads contact data (name, email, stage) from a specified Google Sheet range.\n- **Loop Through Contacts**: Uses SplitInBatches to process each contact individually.\n- **Determine Follow-Up Stage**: Checks the contact’s stage (e.g., Initial, Follow-Up 1) using an If node.\n- **Send Main/Follow-Up Email**: Sends personalized emails via Gmail based on the stage.\n- **Update Sheet Status**: Appends or updates the Google Sheet with the new status (e.g., Sent, Replied).\n- **Check Gmail for Replies**: Periodically checks Gmail for responses using an IMAP node.\n- **Log Responses**: Writes response details (e.g., timestamp, content) to the Google Sheet."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "437e7f2a-166b-487d-a269-7fc2dbebb917",
"connections": {
"263d7a2a-0185-47b5-a58b-c00a0f756dcc": {
"main": [
[
{
"node": "d5b54189-9981-4b23-afa1-d8c2007ce94d",
"type": "main",
"index": 0
}
]
]
},
"f2525c0e-4f9b-4430-a4f1-d21c18977095": {
"main": [
[],
[
{
"node": "55ff15d6-15ed-4197-b2b4-98df8695f98c",
"type": "main",
"index": 0
}
]
]
},
"d5b54189-9981-4b23-afa1-d8c2007ce94d": {
"main": [
[
{
"node": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"type": "main",
"index": 0
}
]
]
},
"009b187a-a8b6-4748-bc9a-2e7dcd69f233": {
"main": [
[
{
"node": "91e87156-bd84-4df5-ad9e-11089af50c02",
"type": "main",
"index": 0
}
]
]
},
"c2ed8d92-11c0-49df-87c2-191917a18a9b": {
"main": [
[
{
"node": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"type": "main",
"index": 0
}
]
]
},
"2dbd64d3-ec48-4992-a25e-f665d4f04001": {
"main": [
[
{
"node": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"type": "main",
"index": 0
}
]
]
},
"11f2e1b6-0f21-4d5b-aced-a4c45e29f970": {
"main": [
[
{
"node": "2dbd64d3-ec48-4992-a25e-f665d4f04001",
"type": "main",
"index": 0
}
],
[
{
"node": "c2ed8d92-11c0-49df-87c2-191917a18a9b",
"type": "main",
"index": 0
}
]
]
},
"55ff15d6-15ed-4197-b2b4-98df8695f98c": {
"main": [
[
{
"node": "11f2e1b6-0f21-4d5b-aced-a4c45e29f970",
"type": "main",
"index": 0
}
]
]
},
"Send a message for followup 6": {
"main": [
[
{
"node": "HRMS api for upadte inqiery data direclty in db",
"type": "main",
"index": 0
}
]
]
},
"Send a message for followup 7": {
"main": [
[
{
"node": "HRMS api for upadte inqiery data direclty in db",
"type": "main",
"index": 0
}
]
]
},
"715c5558-6bdb-4b8b-afc1-ae62bbf175f0": {
"main": [
[
{
"node": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"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 - Réseaux sociaux, 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
Notificateur de mises à jour de menu alimentaire via WhatsApp, e-mail et Twilio SMS
Notificateur de mise à jour de menus alimentaires
If
Set
Code
+
If
Set
Code
22 NœudsOneclick AI Squad
Réseaux sociaux
Réponses automatiques aux commentaires Instagram pilotées par l'IA
Suivre automatiquement les réponses aux commentaires Instagram avec OpenAI et Redis
If
Code
Merge
+
If
Code
Merge
27 NœudsOneclick AI Squad
Réseaux sociaux
Générateur intelligent de marketing par e-mail (Excel + AI) (de la feuille de calcul à la boîte de réception)
Basé sur Google Sheets, utiliser Llama AI pour générer des e-mails marketing personnalisés
Code
Gmail
Google Sheets
+
Code
Gmail
Google Sheets
7 NœudsOneclick AI Squad
Réseaux sociaux
Workflow de modération et de défense automatisée contre les commentaires malveillants sur Instagram
Modération automatique des commentaires Instagram avec relecture et alertes Slack via Perspective API
If
Set
Cron
+
If
Set
Cron
15 NœudsOneclick AI Squad
Réseaux sociaux
Automatisation des remises d'anniversaire pour le e-commerce
Utiliser Google Sheet et Gmail pour automatiser les e-mails de réduction d'anniversaire pour le commerce en ligne
If
Gmail
Function
+
If
Gmail
Function
7 NœudsMarth
Réseaux sociaux
Automatisation de la conformité des livrables et des contrats pour les influenceurs Instagram
Automatiser la conformité des contrats d'influenceurs Instagram avec Claude AI et des rappels Slack
If
Set
Code
+
If
Set
Code
26 NœudsOneclick AI Squad
Réseaux sociaux
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds11
Catégorie2
Types de nœuds8
Description de la difficulté
Auteur
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
Liens externes
Voir sur n8n.io →
Partager ce workflow