Workflow n8n
Automatisation WhatsApp avec n8n : gestion des messages en temps réel
- Ce workflow n8n est conçu pour automatiser la gestion des messages sur WhatsApp, en intégrant des fonctionnalités avancées pour répondre aux utilisateurs et suivre les interactions. Dans un contexte où la communication instantanée est cruciale pour les entreprises, ce workflow permet de gérer efficacement les demandes des clients via WhatsApp tout en assurant un suivi des réponses dans Google Sheets. Les cas d'usage incluent la gestion des requêtes clients, l'envoi de notifications et la mise à jour des statuts de message.
- Le workflow débute avec un déclencheur WhatsApp qui capte les nouveaux messages entrants. Ensuite, il utilise un nœud de condition pour vérifier si le message reçu nécessite une réponse. Si c'est le cas, le workflow récupère les nouvelles réponses à partir de Google Sheets et les envoie via WhatsApp. Un nœud de planification permet d'automatiser l'envoi de notifications à des moments précis, tandis qu'un nœud de mise à jour assure que le statut des messages est correctement enregistré dans Google Sheets. En intégrant des pauses entre les actions, le workflow garantit une communication fluide et sans surcharge.
- Les bénéfices de cette automatisation n8n sont multiples : elle réduit le temps de réponse aux clients, améliore la satisfaction client et optimise le suivi des interactions. En centralisant les données dans Google Sheets, les entreprises peuvent également analyser les performances de leurs communications et ajuster leurs stratégies en conséquence.
Tags clés :automatisationWhatsAppGoogle Sheetscommunicationn8n
Catégorie: Webhook · Tags: automatisation, WhatsApp, Google Sheets, communication, n8n❤ 0
Workflow n8n WhatsApp, Google Sheets, communication : vue d'ensemble
Schéma des nœuds et connexions de ce workflow n8n, généré à partir du JSON n8n.
Workflow n8n WhatsApp, Google Sheets, communication : détail des nœuds
Inscris-toi pour voir l'intégralité du workflow
Inscription gratuite
S'inscrire gratuitementBesoin d'aide ?{
"id": "NzoLNV2FbS4eurJ7",
"meta": {
"instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a",
"templateCredsSetupCompleted": true
},
"name": "WhatsApp business bot",
"tags": [],
"nodes": [
{
"id": "4ca5e25a-f67b-4874-af20-680d1a6ac731",
"name": "Sent notification template",
"type": "n8n-nodes-base.whatsApp",
"position": [
1140,
320
],
"parameters": {
"template": "test_appointment_button|en_US",
"components": {
"component": [
{
"type": "header",
"headerParameters": {
"parameter": [
{
"text": "📅"
}
]
}
},
{
"bodyParameters": {
"parameter": [
{
"text": "={{ $json[\"Your name\"] }}"
},
{
"text": "={{ DateTime.fromFormat($json[\"Please pick a day and time of your appointment\"], \"M/d/yyyy HH:mm:ss\").toLocaleString(DateTime.DATE_HUGE); }}"
},
{
"text": "={{ $json[\"Please pick a day and time of your appointment\"].split(' ')[1] }}"
}
]
}
}
]
},
"phoneNumberId": "=244242975437240",
"requestOptions": {},
"recipientPhoneNumber": "={{ $json[\"Your mobile number\"] }}"
},
"credentials": {
"whatsAppApi": {
"id": "mm0r1xKc6N8XktAD",
"name": "WhatsApp account 2"
}
},
"typeVersion": 1
},
{
"id": "877c62c5-9869-48fc-bd74-35897dbd2276",
"name": "WhatsApp Trigger",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
700,
800
],
"webhookId": "b06b387a-481e-43f1-9035-01a87123ad88",
"parameters": {
"updates": [
"messages"
]
},
"credentials": {
"whatsAppTriggerApi": {
"id": "bWqGRWeDXvGTdSq5",
"name": "WhatsApp Trigger"
}
},
"typeVersion": 1
},
{
"id": "6c0edf48-20af-42fb-a436-aee3a9a4f6cc",
"name": "Is message?",
"type": "n8n-nodes-base.if",
"position": [
920,
800
],
"parameters": {
"options": {
"looseTypeValidation": true
},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "8a765e57-8e39-4547-a99a-0458df2b75f4",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.messages[0] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "00006406-47be-4693-9763-a21d06b13d51",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
680,
1184
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b9919c0d-eeb2-4a5e-a91f-3dad11b778f8",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1120,
1184
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "8f0dc664-715f-4074-b0f7-98d3c7f563a5",
"name": "Get new answers",
"type": "n8n-nodes-base.googleSheets",
"position": [
900,
1184
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "Ready",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1621824221,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit#gid=1621824221",
"cachedResultName": "WA-messages"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit?usp=drivesdk",
"cachedResultName": "WhatsApp Appointments (Responses)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "RtRiRezoxiWkzZQt",
"name": "Ted's Tech Talks Google account"
}
},
"typeVersion": 4.4
},
{
"id": "a7b07f7e-1287-4e8f-b28a-4c656f386f8a",
"name": "Reply to the user",
"type": "n8n-nodes-base.whatsApp",
"position": [
1340,
1184
],
"parameters": {
"textBody": "={{ $json.ReplyText }}",
"operation": "send",
"phoneNumberId": "244242975437240",
"requestOptions": {},
"additionalFields": {},
"recipientPhoneNumber": "=+{{ $json.UserPhone }}"
},
"credentials": {
"whatsAppApi": {
"id": "mm0r1xKc6N8XktAD",
"name": "WhatsApp account 2"
}
},
"typeVersion": 1
},
{
"id": "30f0a7da-c3ce-448c-ad05-b8b75da3d319",
"name": "Update message status",
"type": "n8n-nodes-base.googleSheets",
"position": [
1520,
1184
],
"parameters": {
"columns": {
"value": {
"Status": "Replied",
"row_number": "={{ $('Loop Over Items').item.json.row_number }}"
},
"schema": [
{
"id": "UserPhone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "UserPhone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UserName",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "UserName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UserMessage",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "UserMessage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ReplyText",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ReplyText",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"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": [
"row_number"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1621824221,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit#gid=1621824221",
"cachedResultName": "WA-messages"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit?usp=drivesdk",
"cachedResultName": "WhatsApp Appointments (Responses)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "RtRiRezoxiWkzZQt",
"name": "Ted's Tech Talks Google account"
}
},
"typeVersion": 4.4
},
{
"id": "95486a27-a667-4555-8924-53d46b19de43",
"name": "Wait 1 sec",
"type": "n8n-nodes-base.wait",
"position": [
1700,
1184
],
"webhookId": "df4df4f8-378c-4228-b1e2-326b9d956e7e",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "21551e78-428f-4730-a337-48d1a80bf703",
"name": "New message from the user",
"type": "n8n-nodes-base.googleSheets",
"position": [
1140,
800
],
"parameters": {
"columns": {
"value": {
"Status": "New",
"UserName": "={{ $json.contacts[0].profile.name }}",
"UserPhone": "={{ $json.messages[0].from }}",
"UserMessage": "={{ $json.messages[0].text.body }}"
},
"schema": [
{
"id": "UserPhone",
"type": "string",
"display": true,
"required": false,
"displayName": "UserPhone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UserName",
"type": "string",
"display": true,
"required": false,
"displayName": "UserName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UserMessage",
"type": "string",
"display": true,
"required": false,
"displayName": "UserMessage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ReplyText",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ReplyText",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1621824221,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit#gid=1621824221",
"cachedResultName": "WA-messages"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit?usp=drivesdk",
"cachedResultName": "WhatsApp Appointments (Responses)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "RtRiRezoxiWkzZQt",
"name": "Ted's Tech Talks Google account"
}
},
"typeVersion": 4.4
},
{
"id": "e1478757-0094-4bcb-998f-7e3e81958319",
"name": "Get new entries",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
700,
320
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyX",
"unit": "minutes",
"value": 5
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 470797219,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit#gid=470797219",
"cachedResultName": "Form Responses 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit?usp=drivesdk",
"cachedResultName": "WhatsApp Appointments (Responses)"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "m33qCYf9eEvSgo0x",
"name": "Ted's Tech Talks Google Sheets Trigger"
}
},
"typeVersion": 1
},
{
"id": "14811434-d716-4999-ab53-761fc355ee09",
"name": "User consented for WA messages?",
"type": "n8n-nodes-base.filter",
"position": [
920,
320
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b9bfdb33-0d9c-4320-b4bc-0bf0a469c8ca",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json[\"I consent to receive WhatsApp notifications regarding my appointments\"] }}",
"rightValue": "Yes"
}
]
}
},
"typeVersion": 2
},
{
"id": "20bec538-5d04-4382-ba88-a2c15421c8e7",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
83.6407185628741
],
"parameters": {
"width": 744.5356369854154,
"height": 404.8383233532937,
"content": "## Send a WhatsApp (WA) template message\nOccurs after a user submitted a new Google form. If the user opted-in for WA notifications during the form submission, a template message will be sent via WhatsApp.\n\n**IMPORTANT!**\n1. You will need to create a new WA template message on the [Meta Business portal](https://business.facebook.com/wa/manage/message-templates/)\n2. To send outgoing WA messages you'll need an Access Token and a WhatsApp Business Account ID. These can be obtained via Meta Developers Portal after creating an a new App. Please refer to this [n8n blog article on creating WhatsApp bots](https://blog.n8n.io/whatsapp-bot/#step-1-set-up-a-whatsapp-business-account)"
},
"typeVersion": 1
},
{
"id": "ab7bd838-2ed1-4645-b3d9-69617a888090",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
526.8263473053893
],
"parameters": {
"width": 752.168692512586,
"height": 437.60479041916165,
"content": "## Store incoming WhatsApp user messages in a Google Sheet\nTo receive user messages, you need to add a WhatsApp Trigger node. In the credentials section provide an App ID and an App secret. These are obtained from the Meta Developers Portal, Basic App settings screen\n\nAfter the credentials are added, copy the trigger URL and enter it into the 'Callback URL' field in the WhatsApp configuration window in the Meta Developer portal.\n\nOnce the trigger receives a payload from WhatsApp, we check if the incoming data contains a message and add a new row with user data and message text in [Google Sheet](https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit?gid=1621824221#gid=1621824221).\n\nWhatsApp trigger also receives status notifications (i.e. message sent, message read etc.), so we ignore such notifications in this workflow."
},
"typeVersion": 1
},
{
"id": "b0c62bd4-d6bc-425b-b506-b6820b3e6dc5",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
1000
],
"parameters": {
"width": 1197.9640718562885,
"height": 369.34131736526945,
"content": "## Reply to the user via WhatsApp\nWhatsApp allows sending automatic messages **with custom text** via bots only within the 24h time frame after the last incoming user message.\n\nAfter the user sends a message to the WhatsApp bot, a row is added to the [Google Sheet](https://docs.google.com/spreadsheets/d/1T-B0yepcrCHxQpn7Sj6QjTa0VqwwVBQhO5ZcIUSxWJE/edit?gid=1621824221#gid=1621824221) with the Status 'New'\n\nType something in the `ReplyText` column and change the Status to 'Ready'.\nIn a few minutes, n8n timer will fetch all 'Ready' replies from the Google Sheet and send them one by one to the recipients"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"executionOrder": "v1",
"saveManualExecutions": true,
"saveDataSuccessExecution": "all"
},
"versionId": "66863e99-c756-48d5-b8e0-af0907623e8a",
"connections": {
"Wait 1 sec": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Is message?": {
"main": [
[
{
"node": "New message from the user",
"type": "main",
"index": 0
}
]
]
},
"Get new answers": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Get new entries": {
"main": [
[
{
"node": "User consented for WA messages?",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Reply to the user",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get new answers",
"type": "main",
"index": 0
}
]
]
},
"WhatsApp Trigger": {
"main": [
[
{
"node": "Is message?",
"type": "main",
"index": 0
}
]
]
},
"Reply to the user": {
"main": [
[
{
"node": "Update message status",
"type": "main",
"index": 0
}
]
]
},
"Update message status": {
"main": [
[
{
"node": "Wait 1 sec",
"type": "main",
"index": 0
}
]
]
},
"User consented for WA messages?": {
"main": [
[
{
"node": "Sent notification template",
"type": "main",
"index": 0
}
]
]
}
}
}Workflow n8n WhatsApp, Google Sheets, communication : pour qui est ce workflow ?
Ce workflow s'adresse aux entreprises de toutes tailles souhaitant améliorer leur communication client via WhatsApp. Il est particulièrement adapté aux équipes de support, de vente et de marketing qui cherchent à automatiser leurs interactions tout en maintenant un suivi précis des échanges. Un niveau technique intermédiaire est recommandé pour la mise en place.
Workflow n8n WhatsApp, Google Sheets, communication : problème résolu
Ce workflow résout le problème de la gestion manuelle des messages sur WhatsApp, qui peut être chronophage et sujet à des erreurs. En automatisant le processus de réponse et de suivi, il élimine les frustrations liées aux délais de réponse, réduit le risque de perte de messages importants et permet aux utilisateurs de se concentrer sur des tâches à plus forte valeur ajoutée. Les entreprises peuvent ainsi améliorer leur réactivité et leur service client.
Workflow n8n WhatsApp, Google Sheets, communication : étapes du workflow
Étape 1 : Le workflow est déclenché par un nouveau message sur WhatsApp.
- Étape 1 : Une condition vérifie si le message nécessite une réponse.
- Étape 2 : Si c'est le cas, le workflow récupère les nouvelles réponses depuis Google Sheets.
- Étape 3 : Les réponses sont envoyées à l'utilisateur via WhatsApp.
- Étape 4 : Un nœud de planification permet d'envoyer des notifications à des moments définis.
- Étape 5 : Le statut des messages est mis à jour dans Google Sheets pour un suivi efficace.
- Étape 6 : Des pauses sont intégrées pour éviter la surcharge de messages.
Workflow n8n WhatsApp, Google Sheets, communication : guide de personnalisation
Pour personnaliser ce workflow, commencez par ajuster le déclencheur WhatsApp pour qu'il corresponde à votre numéro de téléphone. Modifiez les paramètres des nœuds Google Sheets pour pointer vers les bonnes feuilles de calcul et les colonnes appropriées. Vous pouvez également adapter les messages envoyés via WhatsApp en modifiant le texte dans les nœuds correspondants. Pour une meilleure sécurité, pensez à configurer des autorisations d'accès aux données et à surveiller les performances du flux via les logs d'exécution de n8n.