8
n8n Françaisamn8n.com

AI评分 et Routage des Prospects (Google Gemini, Sheets et Notifications Slack)

Intermédiaire

Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 13 nœuds.Utilise principalement des nœuds comme Set, Merge, Slack, Webhook, GoogleSheets. AI评分 et Routage des Prospects (Google Gemini, Sheets et Notifications Slack)

Prérequis
  • •Token Bot Slack ou URL Webhook
  • •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
  • •Informations d'identification Google Sheets API
  • •Clé API Google Gemini

Nœuds utilisés (13)

Set
Merge
Slack
Webhook
StickyNote
GoogleSheets
SentimentAnalysis
LmChatGoogleGemini

Catégorie

Création de contenu
IA Multimodale
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "meta": {
    "instanceId": "0a25db4fd0692af64b58f35e01611f2ef0b5bb9d6654c57ef3741021e7d8cc11",
    "templateId": "4322",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "e74de2ca-d3e1-499b-893c-972bb6bd9ad0",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1424,
        736
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "MOufOXyoLNgKIzCu",
          "name": "Google Gemini(PaLM) Api account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "01b4b86b-8798-405e-93c9-5881f3d27d20",
      "name": "Recevoir un Nouveau Prospect (Typeform)",
      "type": "n8n-nodes-base.webhook",
      "position": [
        896,
        480
      ],
      "webhookId": "20426827-714d-4a48-ab87-4a3216665bde",
      "parameters": {
        "path": "lead-webhook",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "b4007cc1-6332-42d3-a7d1-12db9bc35fec",
      "name": "Préparer les Données du Prospect",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        480
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3.4
    },
    {
      "id": "d274436b-f5f6-4c13-948d-f1e2f822e85c",
      "name": "Classer le Sentiment (Gemini ou autre modèle d'IA)",
      "type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
      "position": [
        1344,
        480
      ],
      "parameters": {
        "options": {},
        "inputText": "={{$json[\"message\"] || $json[\"mensagem\"] || $json[\"resposta\"]}}\n"
      },
      "typeVersion": 1
    },
    {
      "id": "20839991-6176-4485-98fe-1d188ac552f1",
      "name": "Combiner les Données du Prospect",
      "type": "n8n-nodes-base.merge",
      "position": [
        1920,
        464
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.1
    },
    {
      "id": "31b9506f-0537-4b58-9c51-fbdfcf05a3f0",
      "name": "Envoyer un Message",
      "type": "n8n-nodes-base.slack",
      "position": [
        2144,
        480
      ],
      "webhookId": "17d27255-fdc2-4b45-ab04-b35b00fabc99",
      "parameters": {
        "text": "wefwe",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09BP1AGRT9",
          "cachedResultName": "alle-in-meakcodes"
        },
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "BFRW6GiYcJw58eeZ",
          "name": "Slack account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "52a61391-f621-484a-b395-e72bffed9654",
      "name": "Stocker le Prospect Neutre",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        480
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "4cae6f1b-e73f-4497-9ded-2cf241fb2dfd",
      "name": "Stocker le Prospect Froid",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        672
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "8d4b6ad0-6ba4-48c2-9662-91bcdfbf7ded",
      "name": "Stocker le Prospect Chaud",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        288
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "23596639-84c4-438f-a820-1809957a6cdf",
      "name": "Note Adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        192
      ],
      "parameters": {
        "color": 4,
        "height": 256,
        "content": "## STEP 1 · Intake (Webhook)\n**Receive New Lead (Typeform):** POST /lead-webhook\n**Prepare Lead Data:** clean/map fields you need (name, email, message, timestamp).\nTip: Ensure the Typeform payload keys match what you reference later."
      },
      "typeVersion": 1
    },
    {
      "id": "b5c93a1c-55df-47d9-b9bc-b97831a331fa",
      "name": "Note Adhésive 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1328,
        176
      ],
      "parameters": {
        "color": 5,
        "height": 272,
        "content": "## STEP 2 · Sentiment Classification\n**Sentiment node** analyzes message text (fallbacks: message | mensagem | resposta).\n**Gemini model** (via LLM node) powers the classifier.\nOutput branches: Hot / Neutral / Cold (used for routing)."
      },
      "typeVersion": 1
    },
    {
      "id": "c25b0dc7-9bf5-463c-bfb4-b03f5c24960d",
      "name": "Note Adhésive 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        0
      ],
      "parameters": {
        "color": 6,
        "height": 256,
        "content": "## STEP 3 · Store by Segment (Sheets)\nEach branch writes to Google Sheets (appendOrUpdate).\nTip: Set **matchingColumns** (e.g., Email or Submitted) to avoid duplicates.\nIf no mapping is defined, enable auto-map or define column mapping explicitly."
      },
      "typeVersion": 1
    },
    {
      "id": "34e7fb02-48d3-43ff-ab15-bab12a60f3ea",
      "name": "Note Adhésive 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1968,
        176
      ],
      "parameters": {
        "color": 7,
        "height": 256,
        "content": "## STEP 4 · Combine & Notify\n**Merge (3 inputs)** recombines Hot/Neutral/Cold.\n**Slack message** posts to the channel.\nTip: Replace placeholder text with a formatted summary (name, sentiment, link to row)."
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "8d4b6ad0-6ba4-48c2-9662-91bcdfbf7ded": {
      "main": [
        [
          {
            "node": "20839991-6176-4485-98fe-1d188ac552f1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4cae6f1b-e73f-4497-9ded-2cf241fb2dfd": {
      "main": [
        [
          {
            "node": "20839991-6176-4485-98fe-1d188ac552f1",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "20839991-6176-4485-98fe-1d188ac552f1": {
      "main": [
        [
          {
            "node": "31b9506f-0537-4b58-9c51-fbdfcf05a3f0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b4007cc1-6332-42d3-a7d1-12db9bc35fec": {
      "main": [
        [
          {
            "node": "d274436b-f5f6-4c13-948d-f1e2f822e85c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "52a61391-f621-484a-b395-e72bffed9654": {
      "main": [
        [
          {
            "node": "20839991-6176-4485-98fe-1d188ac552f1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "e74de2ca-d3e1-499b-893c-972bb6bd9ad0": {
      "ai_languageModel": [
        [
          {
            "node": "d274436b-f5f6-4c13-948d-f1e2f822e85c",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "01b4b86b-8798-405e-93c9-5881f3d27d20": {
      "main": [
        [
          {
            "node": "b4007cc1-6332-42d3-a7d1-12db9bc35fec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d274436b-f5f6-4c13-948d-f1e2f822e85c": {
      "main": [
        [
          {
            "node": "8d4b6ad0-6ba4-48c2-9662-91bcdfbf7ded",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "52a61391-f621-484a-b395-e72bffed9654",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "4cae6f1b-e73f-4497-9ded-2cf241fb2dfd",
            "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 - 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

Automatisation des appels prospects : VAPI, enregistrements Google Sheets et rendez-vous sur le calendrier
Automatisation des appels prospects : VAPI, enregistrement Google Sheets et rendez-vous dans le calendrier
Set
Code
Webhook
+
Set
Code
Webhook
13 NœudsMeak
Création de contenu
Automatisation du suivi des prospects : Analyse GPT-4o mini pour Gmail, HubSpot et Slack
Automatisation du suivi des prospects : analyse GPT-4o mini pour Gmail, HubSpot et Slack
If
Set
Code
+
If
Set
Code
14 NœudsMeak
Création de contenu
Recherche automatisée de prospects locaux et envoi de courriels froids
Recherche automatique de prospects locaux et envoi de cold e-mails avec Apify, AI et Gmail
If
Set
Wait
+
If
Set
Wait
18 NœudsMeak
Création de contenu
Évaluation et approche personnalisée des prospects basées sur l'IA (avec Relevance AI)
Évaluation et approche personnalisée des prospects basées sur l'IA : utilisation de Relevance AI
Set
Code
Gmail
+
Set
Code
Gmail
34 NœudsDiptamoy Barman
Création de contenu
Automatisation de la publication RSS vers Medium avec Groq, Gemini et un système d'approbation Slack
Automatisation du flux de publication de RSS vers Medium avec Groq, Gemini et le système d'approbation Slack
If
Set
Code
+
If
Set
Code
41 NœudsObisDev
Création de contenu
Système de capture et de qualification des prospects anti-fraude
Capturer et faire mûrir les prospects anti-fraude via un score AI, un suivi dans les feuilles de calcul et des rappels multi-canaux
If
Set
Code
+
If
Set
Code
28 NœudsJitesh Dugar
Création de contenu
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds13
Catégorie2
Types de nœuds8
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
Meak

Meak

@meak

I help people build $5k+/month online by starting their own AI agency. Without BS.

Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34