Sauvegarde des retours et génération de rapports
Avancé
Ceci est unCRM, AI Summarizationworkflow d'automatisation du domainecontenant 28 nœuds.Utilise principalement des nœuds comme Set, Code, EmailSend, GoogleSheets, ManualTrigger. Utiliser Azure OpenAI et Google Sheets pour analyser les résultats des transactions de vente et générer des rapports
Prérequis
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
Nœuds utilisés (28)
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": "INCHeFIxjP8eus8J",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "Feedback save and report generation",
"tags": [],
"nodes": [
{
"id": "e47ac8b4-ccb8-49df-82f0-05fdbff7828a",
"name": "Extraire les notes/emails",
"type": "n8n-nodes-base.code",
"position": [
16,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9cb26417-5674-44cb-ab6f-28c44b168094",
"name": "Analyser la réponse IA",
"type": "n8n-nodes-base.code",
"position": [
1264,
-224
],
"parameters": {},
"typeVersion": 2
},
{
"id": "60a74709-38da-48d6-9227-eeed1734c0f6",
"name": "Enregistrer dans Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1488,
-96
],
"parameters": {},
"typeVersion": 4
},
{
"id": "3f508420-a1a3-4a46-b07b-a6bd0664f789",
"name": "Récupérer les données de Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
448,
480
],
"parameters": {},
"typeVersion": 4
},
{
"id": "5bb2b739-60d9-4043-9771-979ad1c593da",
"name": "Filtrer les données récentes",
"type": "n8n-nodes-base.code",
"position": [
1232,
416
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a06f354f-3cdc-47bf-9ef3-c25b76135778",
"name": "Envoyer un résumé par email",
"type": "n8n-nodes-base.emailSend",
"position": [
1472,
416
],
"webhookId": "2fd9cd32-4351-49a0-ba18-310a17f086b5",
"parameters": {},
"typeVersion": 2
},
{
"id": "073e3c65-5662-4c40-8f7c-abb1b5d54030",
"name": "Lors du clic sur 'Exécuter le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-432,
112
],
"parameters": {},
"typeVersion": 1
},
{
"id": "38f26876-4138-49fc-8f79-93ac5ad7876d",
"name": "Obtenir la/les ligne(s) dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
-208,
112
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "dd009347-1c1e-4d77-880f-98a1268feab6",
"name": "Agent IA",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
432,
-368
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "3914f8f7-955b-4464-9548-89f6b79f67bb",
"name": "Azure OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
464,
-208
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"name": "Boucler sur les éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
240,
112
],
"parameters": {},
"typeVersion": 3
},
{
"id": "62ebbddb-b10b-4af2-ae56-4e642e5cd610",
"name": "Modifier les champs",
"type": "n8n-nodes-base.set",
"position": [
896,
-368
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"name": "Agent IA1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
752,
416
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "5529bf2c-a211-43bb-8a1a-1c2027fb7daf",
"name": "Azure OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
832,
592
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d1043f1a-2691-4f2f-a5e9-108431e7a7f8",
"name": "Note autocollante",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d232025f-784f-4ef6-8a4d-d0b62a7bd651",
"name": "Note autocollante1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-256
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "222b661a-1825-42f0-9548-b4c7a35928b5",
"name": "Note autocollante2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bfc6fdc7-1535-4849-8995-8cbabb4b4db5",
"name": "Note autocollante3",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3d1bbe23-6654-4708-9088-3e931e8da497",
"name": "Note autocollante4",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
-752
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33538927-39dd-4cbe-8e7b-a8cf69bdad23",
"name": "Note autocollante5",
"type": "n8n-nodes-base.stickyNote",
"position": [
592,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2bd5d02c-5fbc-4b0b-8526-3222daeef829",
"name": "Note autocollante6",
"type": "n8n-nodes-base.stickyNote",
"position": [
832,
-704
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "db617a0c-d9d3-4e46-b305-c471b35884e1",
"name": "Note autocollante7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1216,
-608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1c2fd82b-2067-43c8-8a6b-2eaaa00e20aa",
"name": "Note autocollante8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1584,
-432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e87af0fc-8734-47d6-8630-d20cee16d6bc",
"name": "Note autocollante9",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
704
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e8d0fdf6-e192-4d2d-ba57-e38f413fde9d",
"name": "Note autocollante10",
"type": "n8n-nodes-base.stickyNote",
"position": [
752,
144
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4ac6d3a4-4c29-4fea-adb8-28bff7c90f9d",
"name": "Note autocollante11",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
752
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3ecd8bc0-6e57-40c1-bee9-ecce4253097b",
"name": "Note autocollante12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1184,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "007b3968-5938-4abf-b369-16e119de46c9",
"name": "Note autocollante13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1664,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1552e070-ec28-47ce-b4e6-41c3fd0dd004",
"connections": {
"dd009347-1c1e-4d77-880f-98a1268feab6": {
"main": [
[
{
"node": "62ebbddb-b10b-4af2-ae56-4e642e5cd610",
"type": "main",
"index": 0
}
]
]
},
"d114ef1f-19de-49ce-92c6-df5e75c187c2": {
"main": [
[
{
"node": "5bb2b739-60d9-4043-9771-979ad1c593da",
"type": "main",
"index": 0
}
]
]
},
"62ebbddb-b10b-4af2-ae56-4e642e5cd610": {
"main": [
[
{
"node": "9cb26417-5674-44cb-ab6f-28c44b168094",
"type": "main",
"index": 0
}
]
]
},
"c59c230c-fb7d-47ea-aa19-210c5b65dccd": {
"main": [
[
{
"node": "3f508420-a1a3-4a46-b07b-a6bd0664f789",
"type": "main",
"index": 0
}
],
[
{
"node": "dd009347-1c1e-4d77-880f-98a1268feab6",
"type": "main",
"index": 0
}
]
]
},
"9cb26417-5674-44cb-ab6f-28c44b168094": {
"main": [
[
{
"node": "60a74709-38da-48d6-9227-eeed1734c0f6",
"type": "main",
"index": 0
}
]
]
},
"a06f354f-3cdc-47bf-9ef3-c25b76135778": {
"main": [
[]
]
},
"5bb2b739-60d9-4043-9771-979ad1c593da": {
"main": [
[
{
"node": "a06f354f-3cdc-47bf-9ef3-c25b76135778",
"type": "main",
"index": 0
}
]
]
},
"38f26876-4138-49fc-8f79-93ac5ad7876d": {
"main": [
[
{
"node": "e47ac8b4-ccb8-49df-82f0-05fdbff7828a",
"type": "main",
"index": 0
}
]
]
},
"e47ac8b4-ccb8-49df-82f0-05fdbff7828a": {
"main": [
[
{
"node": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"type": "main",
"index": 0
}
]
]
},
"60a74709-38da-48d6-9227-eeed1734c0f6": {
"main": [
[
{
"node": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"type": "main",
"index": 0
}
]
]
},
"3914f8f7-955b-4464-9548-89f6b79f67bb": {
"ai_languageModel": [
[
{
"node": "dd009347-1c1e-4d77-880f-98a1268feab6",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"3f508420-a1a3-4a46-b07b-a6bd0664f789": {
"main": [
[
{
"node": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"type": "main",
"index": 0
}
]
]
},
"5529bf2c-a211-43bb-8a1a-1c2027fb7daf": {
"ai_languageModel": [
[
{
"node": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"073e3c65-5662-4c40-8f7c-abb1b5d54030": {
"main": [
[
{
"node": "38f26876-4138-49fc-8f79-93ac5ad7876d",
"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é - CRM, Résumé IA
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
Utiliser GPT-4o-mini et Gmail pour analyser les chaînes YouTube et envoyer des rapports de performance
Utiliser GPT-4o-mini et Gmail pour analyser un canal YouTube et envoyer un rapport de performance
Code
Email Send
Http Request
+
Code
Email Send
Http Request
20 NœudsRahul Joshi
Étude de marché
Test des FAQ sur la limitation de débit et l'authentification d'API
Utiliser GPT-4o-mini, Google Sheets et Slack reminders pour automatiser le test qualité des FAQs API
If
Set
Code
+
If
Set
Code
19 NœudsRahul Joshi
Extraction de documents
Suivi automatisé des mises à jour des dépendances
Analyse des risques de mises à jour de dépendances avec GPT-4o, Slack, Jira et Google Sheets
If
Set
Code
+
If
Set
Code
23 NœudsRahul Joshi
DevOps
Génération de propositions_Enregistrement automatique des brouillons
Utiliser GPT-4o d'Azure pour générer des propositions commerciales et les sauvegarder comme brouillon Gmail depuis Sheets
If
Code
Gmail
+
If
Code
Gmail
16 NœudsRahul Joshi
CRM
Marquage et routage intelligent des prospects
Classification et routage des prospects pilotés par l'IA, basés sur HighLevel et Azure GPT-4o-mini
If
Code
Email Send
+
If
Code
Email Send
17 NœudsRahul Joshi
Génération de leads
E-mails de rejet/personnalisés pour l'étape suivante
Automatisation du rejet des candidats avec Google Sheets, GPT-4o-mini, Gmail et ClickUp
If
Set
Code
+
If
Set
Code
38 NœudsRahul Joshi
Ressources Humaines
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds28
Catégorie2
Types de nœuds9
Description de la difficulté
Auteur
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
Liens externes
Voir sur n8n.io →
Partager ce workflow