Tracker de la vitesse des pipelines GoHighLevel et rappels d'automatisation pour les transactions stagnantes
Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 25 nœuds.Utilise principalement des nœuds comme If, Code, Gmail, Slack, HighLevel. Utiliser GoHighLevel, Gmail et Slack pour analyser la vitesse du pipeline et alerter des transactions stagnantes
- •Compte Google et informations d'identification Gmail API
- •Token Bot Slack ou URL Webhook
- •Informations d'identification Google Sheets API
Nœuds utilisés (25)
Catégorie
{
"id": "7Mu8qjTtj8d94K08",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "GoHighLevel Pipeline Velocity Tracker & Automated Stuck Deal Alerts",
"tags": [],
"nodes": [
{
"id": "54615dae-9ea1-4c79-89b8-6227dcf34136",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1472,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3c3938c2-468a-48a6-acd8-94ac8c623989",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-944,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "097bbb09-68d7-42e9-90ee-8b57eb897045",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d73469cc-02d5-489d-bece-4a2c4e8fcbb5",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9ef8cc7d-fb3f-44a2-ab7d-60b6093d009d",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
-448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "02f7278f-9470-48a5-9371-9f798efd333a",
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
64,
448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "04beef66-2aa6-4ff1-91e9-f373bb602d82",
"name": "Note adhésive6",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9acedd9-4ff3-4275-a3a4-b3bf328fb565",
"name": "Note adhésive7",
"type": "n8n-nodes-base.stickyNote",
"position": [
544,
-688
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "97b966ff-1f98-4eb6-922f-244112797c93",
"name": "Note adhésive8",
"type": "n8n-nodes-base.stickyNote",
"position": [
976,
-496
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c1ff95cb-b8fa-4c4b-a3d5-5a5fa22dd748",
"name": "Note adhésive9",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
544
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5fb06d0a-3f10-46c6-a330-3b5a4c54a513",
"name": "Déclencheur Hebdomadaire - Lundi 8h",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-768,
288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f028f20a-6217-4022-ad94-d70e68803ef0",
"name": "Récupérer les Données du Pipeline GHL",
"type": "n8n-nodes-base.highLevel",
"notes": "Retrieves all opportunities from GoHighLevel. Configure pipeline filter if needed.",
"position": [
-544,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "34e81ae7-95eb-40cf-be7a-2dd8f34672ff",
"name": "Transformer les Données des Étapes",
"type": "n8n-nodes-base.code",
"notes": "Calculates time spent in each stage and prepares data for Google Sheets",
"position": [
-96,
192
],
"parameters": {},
"typeVersion": 2
},
{
"id": "857a5082-7bd8-4dbc-804a-ef4d6b15a9f4",
"name": "Journaliser vers Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "Stores historical pipeline data for tracking trends over time",
"position": [
128,
0
],
"parameters": {},
"typeVersion": 4
},
{
"id": "72dbf078-bdee-4aec-af05-6962ba3641e3",
"name": "Filtrer les Transactions Bloquées (7+ Jours)",
"type": "n8n-nodes-base.if",
"notes": "Triggers if deal is in current stage for more than 7 days (configurable)",
"position": [
128,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ca9bc77b-7eec-4708-ab61-d30bc04f0a32",
"name": "Calculer les Métriques des Étapes",
"type": "n8n-nodes-base.code",
"notes": "Aggregates metrics and identifies bottleneck stages",
"position": [
352,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c9804b69-68de-482e-917d-e56772ed4583",
"name": "Générer le Rapport Hebdomadaire",
"type": "n8n-nodes-base.code",
"notes": "Generates HTML and text versions of the weekly report",
"position": [
576,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cd9073d7-7fdc-4d72-b03c-384437f03b87",
"name": "Générer l'Alerte de Transaction Bloquée",
"type": "n8n-nodes-base.code",
"notes": "Creates alert email for deals stuck longer than threshold",
"position": [
352,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5f6d6e29-edbb-4fa8-bf9d-32c3ba9a5b14",
"name": "Envoyer l'Alerte de Transaction Bloquée",
"type": "n8n-nodes-base.gmail",
"notes": "Sends alert to sales manager when deals are stuck (SECURITY FIX: no longer sends to customer email)",
"position": [
576,
192
],
"webhookId": "976ecd35-8e62-4774-a66e-be51576b30cb",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "31cb8a69-1047-49aa-af74-96710388b11c",
"name": "Envoyer le Rapport Hebdomadaire par Email",
"type": "n8n-nodes-base.gmail",
"notes": "Delivers weekly performance report to sales leadership",
"position": [
800,
0
],
"webhookId": "976ecd35-8e62-4774-a66e-be51576b30cb",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e31fdf64-5a5c-45d9-b6d2-5a1b53f73dd8",
"name": "Envoyer un message",
"type": "n8n-nodes-base.slack",
"position": [
576,
384
],
"webhookId": "5d078c59-21d9-4e5c-8c25-61564de2b7d0",
"parameters": {},
"typeVersion": 2.3
},
{
"id": "c6121da5-c974-45da-88dd-761b0ed02941",
"name": "Note adhésive10",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6987988d-84b5-4099-9847-7e3cbd4b5fb9",
"name": "Envoyer l'Alerte d'Erreur",
"type": "n8n-nodes-base.gmail",
"notes": "Sends an email when the workflow fails",
"position": [
-96,
384
],
"webhookId": "ce5e05f7-e0df-4dfa-9b60-a83fd46b8ec8",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "dca4366e-332a-4b7e-bf27-36eb61ea490f",
"name": "Si",
"type": "n8n-nodes-base.if",
"position": [
-320,
288
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "613b3be0-cb7e-4a44-a64e-c8f0587cfb2f",
"name": "Note adhésive11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
576
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e5e34994-02a0-4a76-89f0-cb65e5f6374d",
"connections": {
"dca4366e-332a-4b7e-bf27-36eb61ea490f": {
"main": [
[
{
"node": "34e81ae7-95eb-40cf-be7a-2dd8f34672ff",
"type": "main",
"index": 0
}
],
[
{
"node": "6987988d-84b5-4099-9847-7e3cbd4b5fb9",
"type": "main",
"index": 0
}
]
]
},
"857a5082-7bd8-4dbc-804a-ef4d6b15a9f4": {
"main": [
[
{
"node": "ca9bc77b-7eec-4708-ab61-d30bc04f0a32",
"type": "main",
"index": 0
}
]
]
},
"34e81ae7-95eb-40cf-be7a-2dd8f34672ff": {
"main": [
[
{
"node": "857a5082-7bd8-4dbc-804a-ef4d6b15a9f4",
"type": "main",
"index": 0
},
{
"node": "72dbf078-bdee-4aec-af05-6962ba3641e3",
"type": "main",
"index": 0
}
]
]
},
"c9804b69-68de-482e-917d-e56772ed4583": {
"main": [
[
{
"node": "31cb8a69-1047-49aa-af74-96710388b11c",
"type": "main",
"index": 0
}
]
]
},
"ca9bc77b-7eec-4708-ab61-d30bc04f0a32": {
"main": [
[
{
"node": "c9804b69-68de-482e-917d-e56772ed4583",
"type": "main",
"index": 0
}
]
]
},
"f028f20a-6217-4022-ad94-d70e68803ef0": {
"main": [
[
{
"node": "dca4366e-332a-4b7e-bf27-36eb61ea490f",
"type": "main",
"index": 0
}
]
]
},
"cd9073d7-7fdc-4d72-b03c-384437f03b87": {
"main": [
[
{
"node": "5f6d6e29-edbb-4fa8-bf9d-32c3ba9a5b14",
"type": "main",
"index": 0
},
{
"node": "e31fdf64-5a5c-45d9-b6d2-5a1b53f73dd8",
"type": "main",
"index": 0
}
]
]
},
"5fb06d0a-3f10-46c6-a330-3b5a4c54a513": {
"main": [
[
{
"node": "f028f20a-6217-4022-ad94-d70e68803ef0",
"type": "main",
"index": 0
}
]
]
},
"72dbf078-bdee-4aec-af05-6962ba3641e3": {
"main": [
[
{
"node": "cd9073d7-7fdc-4d72-b03c-384437f03b87",
"type": "main",
"index": 0
}
]
]
}
}
}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é - Création de contenu, 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
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.
Partager ce workflow