Robot de support WhatsApp par IA basé sur Google Sheets (création de tickets)
Avancé
Ceci est unSupport Chatbot, Multimodal AIworkflow d'automatisation du domainecontenant 35 nœuds.Utilise principalement des nœuds comme Set, Xml, Code, Html, Wait. Robot de support WhatsApp basé sur l'IA (création de tickets Google Sheets)
Prérequis
- •Compte Google et informations d'identification Gmail API
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
- •Clé API Pinecone
Nœuds utilisés (35)
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
{
"nodes": [
{
"id": "c5b15d1f-3f07-4075-83d6-e9b393a20a16",
"name": "À la réception d'un message chat",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
1344,
720
],
"webhookId": "5365fa15-96ef-4437-90f5-8faeb595b03a",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "91546766-7a95-4b59-8d13-e4b970b28e88",
"name": "Agent IA",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1776,
720
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "b4a7917b-a9e6-4076-9aad-efe7cc4d72c5",
"name": "À la soumission d'un formulaire",
"type": "n8n-nodes-base.formTrigger",
"position": [
1104,
-368
],
"webhookId": "8e81bc08-6fc8-4a47-8e45-63fe28046b5b",
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d",
"name": "__PROTECTED__78__",
"type": "n8n-nodes-base.xml",
"position": [
1856,
-368
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a0af59c0-9c5a-4e4a-8654-fd4546224646",
"name": "Requête __PROTECTED__74__",
"type": "n8n-nodes-base.httpRequest",
"position": [
1696,
-368
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "5ebd8d66-9d86-400e-b601-7fa2e0eb40c0",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
2000,
-368
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7dd826d4-a44e-4cf0-b85f-d23410d6a84d",
"name": "Récupérer le HTML de la page",
"type": "n8n-nodes-base.httpRequest",
"position": [
2736,
-432
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ed14bf13-5e46-4465-b93b-0cf8b1cbcc16",
"name": "HTML",
"type": "n8n-nodes-base.html",
"position": [
2736,
-624
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
"name": "Boucler sur les pages",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2544,
-528
],
"parameters": {},
"typeVersion": 3
},
{
"id": "ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3",
"name": "Attente",
"type": "n8n-nodes-base.wait",
"position": [
2896,
-432
],
"webhookId": "9d87e60f-9df8-4a13-9c22-e3e5a5bb9c0e",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "fd7d2d87-8f73-4ce8-8788-b7ee3c983a83",
"name": "Diviser les URLs des pages",
"type": "n8n-nodes-base.code",
"position": [
1696,
-544
],
"parameters": {},
"typeVersion": 2
},
{
"id": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"name": "Vector Store __PROTECTED__28__",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
3296,
-208
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "a986e0b4-c032-4335-9c9b-c56197f9fbf7",
"name": "Chargeur de données par défaut",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
3488,
0
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5e9546d6-b63e-4db8-8ccf-1580dd389079",
"name": "Mémoire simple",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
1840,
928
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "a79d3e2d-b7c6-401b-a449-9a46a7d65f43",
"name": "__PROTECTED__28__ (Récupérer infos)",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
2032,
928
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "3bef0066-c5f8-420a-8064-ed0311b03a97",
"name": "Infos entreprise",
"type": "n8n-nodes-base.set",
"position": [
1568,
720
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "40eb17ab-e6cd-4a88-8842-de528839a47e",
"name": "Extraire le texte",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2512,
32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "51d7cd78-8fb6-43cf-af33-460105ea6185",
"name": "Extraire PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2512,
-128
],
"parameters": {},
"typeVersion": 1
},
{
"id": "673ce2d3-e67b-4d19-9d2b-16817d543b1a",
"name": "Sélectionner le texte",
"type": "n8n-nodes-base.set",
"position": [
2704,
32
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "3f4379fb-1ee1-45a2-8038-41150aa0819d",
"name": "PDF ou TXT",
"type": "n8n-nodes-base.switch",
"position": [
2304,
-48
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
"name": "Fusionner",
"type": "n8n-nodes-base.merge",
"position": [
2192,
-528
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "9be77a2b-5508-414b-92a1-e4c3178cc160",
"name": "Supprimer les doublons",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
2336,
-528
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"name": "Boucler sur les fichiers",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2080,
-192
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c55ec9ad-9cf9-4813-a1cb-5a5bc8844469",
"name": "Commutateur1",
"type": "n8n-nodes-base.switch",
"position": [
1376,
-384
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "907ad368-9129-4d81-acbd-ad7d48de0787",
"name": "Diviser_Binaire",
"type": "n8n-nodes-base.code",
"position": [
1856,
-64
],
"parameters": {},
"typeVersion": 2
},
{
"id": "05ac9943-f6de-43ab-b9bd-470d39e0db3d",
"name": "Obtenir les tickets",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
2384,
848
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "df90fdae-4d8f-43a7-acf9-1c2349b8cf02",
"name": "Créer des tickets d'assistance",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
2560,
784
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "05b6a554-0465-4595-821a-eac544c98b51",
"name": "Envoyer un message dans __PROTECTED__60__",
"type": "n8n-nodes-base.gmailTool",
"position": [
1856,
1200
],
"webhookId": "d78e82ae-5289-4213-b1f4-7fb749b83dad",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "6d27f310-28e3-4698-b09c-d924e5d77b4a",
"name": "Modèle de chat __PROTECTED__58__",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1664,
928
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "53eb3e5f-8a73-4e8d-ab6e-840eb196f61d",
"name": "Embeddings __PROTECTED__58__",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
2112,
1120
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e6a670ff-1815-44f7-ad82-99a4ea356ebb",
"name": "Embeddings OpenAI1",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
3280,
16
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "ac031d5a-ed46-4c36-8213-734a08fc2c1f",
"name": "Déclencheur __PROTECTED__22__",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
1344,
544
],
"webhookId": "64048f32-bac4-473d-9a2a-9193401d3937",
"parameters": {},
"typeVersion": 1
},
{
"id": "77349f3e-1292-432f-822a-4ca1d0b4a20d",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
1008,
-688
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "29fe4f2c-eed7-4e14-9f89-53e7bf689eaf",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1008,
432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0bbf9a71-f76d-49c5-8552-ae7b34dd1798",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
-688
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d": {
"main": [
[
{
"node": "5ebd8d66-9d86-400e-b601-7fa2e0eb40c0",
"type": "main",
"index": 0
}
]
]
},
"5ebd8d66-9d86-400e-b601-7fa2e0eb40c0": {
"main": [
[
{
"node": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
"type": "main",
"index": 1
}
]
]
},
"ed14bf13-5e46-4465-b93b-0cf8b1cbcc16": {
"main": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "main",
"index": 0
}
]
]
},
"ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3": {
"main": [
[
{
"node": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
"type": "main",
"index": 0
}
]
]
},
"15a0a6a4-302d-45e4-af7c-72b21efc59dc": {
"main": [
[
{
"node": "9be77a2b-5508-414b-92a1-e4c3178cc160",
"type": "main",
"index": 0
}
]
]
},
"c55ec9ad-9cf9-4813-a1cb-5a5bc8844469": {
"main": [
[
{
"node": "fd7d2d87-8f73-4ce8-8788-b7ee3c983a83",
"type": "main",
"index": 0
}
],
[
{
"node": "a0af59c0-9c5a-4e4a-8654-fd4546224646",
"type": "main",
"index": 0
}
],
[
{
"node": "907ad368-9129-4d81-acbd-ad7d48de0787",
"type": "main",
"index": 0
}
]
]
},
"3f4379fb-1ee1-45a2-8038-41150aa0819d": {
"main": [
[
{
"node": "51d7cd78-8fb6-43cf-af33-460105ea6185",
"type": "main",
"index": 0
}
],
[
{
"node": "40eb17ab-e6cd-4a88-8842-de528839a47e",
"type": "main",
"index": 0
}
]
]
},
"51d7cd78-8fb6-43cf-af33-460105ea6185": {
"main": [
[
{
"node": "673ce2d3-e67b-4d19-9d2b-16817d543b1a",
"type": "main",
"index": 0
}
]
]
},
"05ac9943-f6de-43ab-b9bd-470d39e0db3d": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"673ce2d3-e67b-4d19-9d2b-16817d543b1a": {
"main": [
[
{
"node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"type": "main",
"index": 0
}
]
]
},
"3bef0066-c5f8-420a-8064-ed0311b03a97": {
"main": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "main",
"index": 0
}
]
]
},
"40eb17ab-e6cd-4a88-8842-de528839a47e": {
"main": [
[
{
"node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"type": "main",
"index": 0
}
]
]
},
"a0af59c0-9c5a-4e4a-8654-fd4546224646": {
"main": [
[
{
"node": "f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d",
"type": "main",
"index": 0
}
]
]
},
"907ad368-9129-4d81-acbd-ad7d48de0787": {
"main": [
[
{
"node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"type": "main",
"index": 0
}
]
]
},
"5e9546d6-b63e-4db8-8ccf-1580dd389079": {
"ai_memory": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_memory",
"index": 0
}
]
]
},
"7dd826d4-a44e-4cf0-b85f-d23410d6a84d": {
"main": [
[
{
"node": "ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3",
"type": "main",
"index": 0
}
]
]
},
"1ccd6382-e370-47f7-902a-bc9ecf7f1ac6": {
"main": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "main",
"index": 0
}
],
[
{
"node": "3f4379fb-1ee1-45a2-8038-41150aa0819d",
"type": "main",
"index": 0
}
]
]
},
"add88ee7-7e17-4c34-a539-7b727e57c3a9": {
"main": [
[
{
"node": "ed14bf13-5e46-4465-b93b-0cf8b1cbcc16",
"type": "main",
"index": 0
}
],
[
{
"node": "7dd826d4-a44e-4cf0-b85f-d23410d6a84d",
"type": "main",
"index": 0
}
]
]
},
"fd7d2d87-8f73-4ce8-8788-b7ee3c983a83": {
"main": [
[
{
"node": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
"type": "main",
"index": 0
}
]
]
},
"ac031d5a-ed46-4c36-8213-734a08fc2c1f": {
"main": [
[
{
"node": "3bef0066-c5f8-420a-8064-ed0311b03a97",
"type": "main",
"index": 0
}
]
]
},
"53eb3e5f-8a73-4e8d-ab6e-840eb196f61d": {
"ai_embedding": [
[
{
"node": "a79d3e2d-b7c6-401b-a449-9a46a7d65f43",
"type": "ai_embedding",
"index": 0
}
]
]
},
"6d27f310-28e3-4698-b09c-d924e5d77b4a": {
"ai_languageModel": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"9be77a2b-5508-414b-92a1-e4c3178cc160": {
"main": [
[
{
"node": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
"type": "main",
"index": 0
}
]
]
},
"e6a670ff-1815-44f7-ad82-99a4ea356ebb": {
"ai_embedding": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "ai_embedding",
"index": 0
}
]
]
},
"b4a7917b-a9e6-4076-9aad-efe7cc4d72c5": {
"main": [
[
{
"node": "c55ec9ad-9cf9-4813-a1cb-5a5bc8844469",
"type": "main",
"index": 0
}
]
]
},
"a986e0b4-c032-4335-9c9b-c56197f9fbf7": {
"ai_document": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "ai_document",
"index": 0
}
]
]
},
"df90fdae-4d8f-43a7-acf9-1c2349b8cf02": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"05b6a554-0465-4595-821a-eac544c98b51": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"a79d3e2d-b7c6-401b-a449-9a46a7d65f43": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"c5b15d1f-3f07-4075-83d6-e9b393a20a16": {
"main": [
[
{
"node": "3bef0066-c5f8-420a-8064-ed0311b03a97",
"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é - Chatbot de support, 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
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
Extraction de tout le contenu de pages web et stockage dans Pinecone avec les embeddings de Gemini
de网站obtenir所有页面contenu并存储至PineconedeGemini嵌入
Xml
Code
Html
+
Xml
Code
Html
16 NœudsZain Khan
Extraction de documents
Rédaction IA de textes avec RAG contextuel hybride
Synchronisation Google Drive vers Supabase pour une base de données vectorielle contextuelle pour les applications RAG
If
Set
Code
+
If
Set
Code
76 NœudsMichael Taleb
RAG IA
基于AIdeMISagent
基于AIdegestion信息系统agent
If
Set
Code
+
If
Set
Code
129 NœudsKumar Shivam
Support
Petite boutique 4
🐶 Agent IA pour les réservations de magasins de pets
If
Set
Code
+
If
Set
Code
187 NœudsBruno Dias
Intelligence Artificielle
Charger les problèmes ouverts et commentaires de Jira dans Pinecone
Utiliser Pinecone et OpenAI pour construire un agent de support piloté par RAG pour les problèmes Jira
Set
Code
Merge
+
Set
Code
Merge
30 NœudsBr1
Création de contenu
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds35
Catégorie2
Types de nœuds23
Description de la difficulté
Auteur
Zain Khan
@zainI partner with businesses to streamline processes and accelerate growth through intelligent AI automation and Web/mobile Development. Leveraging deep expertise in GPT-4, LangChain, and n8n, I develop AI-powered agents and sophisticated LLM pipelines.
Liens externes
Voir sur n8n.io →
Partager ce workflow