動のHubSpotリードルーティング with GPT-4とAirtable営業チーム割り当て
上級
これはCRM, AI RAG分野の自動化ワークフローで、18個のノードを含みます。主にCode, Gmail, Slack, Hubspot, Airtableなどのノードを使用。 GPT-4とAirtableによる販売チーム割り当てを使った動のHubSpotリードルーティング
前提条件
- •Googleアカウント + Gmail API認証情報
- •Slack Bot Token または Webhook URL
- •HubSpot API Key
- •Airtable API Key
- •OpenAI API Key
- •Google Gemini API Key
使用ノード (18)
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "58401078fca0e18615dacf21a41e6807e184a744cb02c0f2b253f92dbf04c0e8",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "5c09bdc4-4447-4f89-bdf8-785b1d4f562b",
"name": "HubSpot Trigger",
"type": "n8n-nodes-base.hubspotTrigger",
"position": [
1712,
80
],
"webhookId": "5f24ac4f-904e-4dd2-b249-aa5e2eedaf3d",
"parameters": {
"eventsUi": {
"eventValues": [
{}
]
},
"additionalFields": {}
},
"credentials": {
"hubspotDeveloperApi": {
"id": "ZmdJO4a0TLh0dPq6",
"name": "HubSpot Developer account"
}
},
"typeVersion": 1
},
{
"id": "ccb53df7-842e-412e-b57c-d5c988ee32b4",
"name": "コンタクト情報取得",
"type": "n8n-nodes-base.hubspot",
"position": [
1952,
80
],
"parameters": {
"contactId": {
"__rl": true,
"mode": "id",
"value": "296267253463"
},
"operation": "get",
"authentication": "oAuth2",
"additionalFields": {
"propertiesCollection": {
"propertiesValues": {
"properties": [
"firstname",
"lastname",
"email",
"company",
"company_website",
"descriptions",
"mobilephone",
"jobtitle",
"team_size",
"aindustry",
"createdate"
],
"propertyMode": "valueOnly"
}
}
}
},
"credentials": {
"hubspotOAuth2Api": {
"id": "rZSiaJnA0L7A3Iuz",
"name": "HubSpot account"
}
},
"typeVersion": 2.2
},
{
"id": "d8f0393c-4c5c-4290-8cae-aab4bcd94998",
"name": "JavaScriptコード",
"type": "n8n-nodes-base.code",
"position": [
2176,
80
],
"parameters": {
"jsCode": "\nconst data = $input.first().json;\n\nconst get = (path, fallback = null) => {\n try {\n return path.split('.').reduce((obj, key) => obj && obj[key], data) ?? fallback;\n } catch {\n return fallback;\n }\n};\nconst lead = {\n \"Record ID\": get('vid'), \n \"First Name\": get('properties.firstname.value'),\n \"Last Name\": get('properties.lastname.value'),\n \"Email\": get('properties.email.value'),\n \"Phone Number\": get('properties.phone.value'),\n \"Description\": get('properties.descriptions.value'),\n \"Job Title\": get('properties.jobtitle.value'),\n \"Team Size\": get('properties.team_size.value'),\n\n \"Industry\":\n get('properties.aIndustry.value') ||\n get('associated-company.properties.aIndustry.value') ||\n get('properties.industry.value') ||\n get('associated-company.properties.industry.value') ||\n get('properties.hs_industry.value') ||\n get('associated-company.properties.hs_industry.value') ||\n get('properties.aindustry.value'),\n\n \"Company Website\":\n get('associated-company.properties.website') ||\n get('properties.company_website.value'),\n\n \"Company Name\": get('associated-company.properties.name'),\n};\n\nconst cleanLead = Object.fromEntries(\n Object.entries(lead).filter(([_, v]) => v && v !== 'null' && v !== 'undefined' && v !== '')\n);\n\nfor (const key of Object.keys(lead)) {\n if (!cleanLead[key]) cleanLead[key] = \"N/A\";\n}\n\nreturn [{ json: cleanLead }];\n"
},
"typeVersion": 2
},
{
"id": "ff7fd69e-be53-4cff-a118-9fb538518047",
"name": "レコード作成",
"type": "n8n-nodes-base.airtable",
"position": [
2416,
80
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appcEbIlJr6Vce1R7",
"cachedResultUrl": "https://airtable.com/appcEbIlJr6Vce1R7",
"cachedResultName": "Growify"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblYq8AAcldI4TZKP",
"cachedResultUrl": "https://airtable.com/appcEbIlJr6Vce1R7/tblYq8AAcldI4TZKP",
"cachedResultName": "Leads"
},
"columns": {
"value": {
"Email": "={{ $json.Email }}",
"Job Title": "={{ $json['Job Title'] }}",
"Last Name": "={{ $json['Last Name'] }}",
"TEAM SIZE": "={{ $json['Team Size'] }}",
"aIndustry": "={{ $json.Industry }}",
"First Name": "={{ $json['First Name'] }}",
"Company Name": "={{ $json['Company Name'].value }}",
"Descriptions": "={{ $json.Description }}",
"Phone Number": "={{ $json['Phone Number'] }}",
"Record ID (HS)": "={{ $json['Record ID'] }}",
"Company Website": "={{ $json['Company Website'].value }}"
},
"schema": [
{
"id": "Record ID (HS)",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Record ID (HS)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Descriptions",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Descriptions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TEAM SIZE",
"type": "options",
"display": true,
"options": [
{
"name": "11 - 50",
"value": "11 - 50"
},
{
"name": "51 - 200",
"value": "51 - 200"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "TEAM SIZE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "aIndustry",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "aIndustry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Website",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Company Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Persona (AI)",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Persona (AI)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Assigned to",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Assigned to",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Status",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Lead Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Create Date",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Create Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create",
"authentication": "airtableOAuth2Api"
},
"credentials": {
"airtableOAuth2Api": {
"id": "EbaOFDh1VDUEmgbD",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "cbdf53aa-982a-4616-aa25-090bddf3c9d7",
"name": "AIエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2736,
80
],
"parameters": {
"text": "={\n \"First Name\": {{ $json.fields['First Name'] }},\n \"Last Name\": {{ $json.fields['Last Name'] }},\n \"Job Title\": {{ $json.fields['Job Title'] }},\n \"Team Size\": {{ $json.fields['TEAM SIZE'] }},\n \"Industry\": {{ $json.fields.aIndustry }},\n \"Region\": {{ $('Get a contact').item.json.properties.ip_state.value }},\n \"Description\": {{ $json.fields.Descriptions }}\n}",
"options": {
"systemMessage": "=You are Growify AI — an intelligent routing agent for marketing automation.\n\nYou receive lead data from HubSpot and can access the Airtable tool named \"TeamDatabase\".\n\nWhen asked to analyze or match a lead, you must use the \"TeamDatabase\" tool to retrieve all team records.\n\nLead Routing Logic\n\nUse the following strict, numbered logic for all lead matching:\n\nAnalyze the incoming lead data, focusing on:\n\nIndustry\n\nRegion (matching IP city/country)\n\nTeam size\n\nDescription (primary needs)\n\nUse the TeamDatabase tool to find a record that matches the following criteria:\n\nSimilar or exact industry in the “Focus Industries” column.\n\nMatching or nearby region in the “Region” column.\n\nTeam still under Max Leads (capacity check).\n\nCompare multiple possible matches and choose the best one based on the closest match in both Industry and Region.\n\nRespond only after retrieving data from the TeamDatabase.\n\nRequired Output Format\n\nReturn your final answer as strict JSON with the following keys. All fields in the recommended_team, slack_notification, and email_notification objects must be populated.\n\n{\n \"lead_persona\": {\n \"summary\": \"A concise, single-sentence summary of the lead (Name, Company, Size, Region).\",\n \"primary_needs\": \"The specific pain point or solution requested (from the description field).\"\n },\n \"recommended_team\": {\n \"team_name\": \"The name of the assigned team.\",\n \"contact_person\": \"The assigned team's contact person's name.\",\n \"email\": \"The assigned contact person's email address.\",\n \"reason_for_match\": \"The rationale for the team match (e.g., region and industry fit, and capacity).\",\n \"slack_channel\": \"The Slack channel to post the notification to (e.g., #squad-innovate-eu).\"\n },\n \"slack_notification\": {\n \"message\": \"A brief, urgent summary message to send to the Slack channel.\",\n \"ping\": \"The assigned contact person's Slack handle (e.g., <@Maria Rossi>).\"\n },\n \"email_notification\": {\n \"subject\": \"The subject line for the internal email.\",\n \"body\": \"The full body of the email to the assigned contact person, detailing the lead and their specific need.\"\n }\n}\n\n\nIf the TeamDatabase cannot be accessed or no suitable team match is found after checking capacity, return the following response:\n\n{\n \"message\": \"No suitable team found in TeamDatabase.\"\n}\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "f4daa29b-5357-4dcf-bc72-a57111d275ed",
"name": "シンプルメモリ",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
2352,
320
],
"parameters": {
"sessionKey": "data",
"sessionIdType": "customKey",
"contextWindowLength": 10
},
"typeVersion": 1.3
},
{
"id": "8b66f010-f6b4-4b65-b43b-6aaecbb66931",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2608,
320
],
"parameters": {
"autoFix": true,
"jsonSchemaExample": "{\n \"lead_persona\": {\n \"summary\": \"Arjun Mehta, Founder of a mid-size SaaS company (11-50 employees) located in the Netherlands (Europe), submitted a form.\",\n \"primary_needs\": \"The lead is actively looking for a CRM automation and sales tracking solution with a direct integration for WhatsApp.\"\n },\n \"recommended_team\": {\n \"team_name\": \"InnovateEU\",\n \"contact_person\": \"Maria Rossi\",\n \"email\": \"maria.rossi@growify.ai\",\n \"reason_for_match\": \"Best regional fit (Europe) and primary industry match (SaaS), with current team capacity (3/7 leads).\",\n \"slack_channel\": \"#squad-innovate-eu\"\n },\n \"slack_notification\": {\n \"message\": \"New **HOT** Lead for InnovateEU! SaaS Founder Arjun Mehta is looking for a WhatsApp-integrated CRM/Sales Tracker. High intent. Please review and take action in HubSpot.\",\n \"ping\": \"<@Maria Rossi>\"\n },\n \"email_notification\": {\n \"subject\": \"[ACTION REQUIRED] High-Intent SaaS Lead Routed to You: Arjun Mehta @ TechVerse Pvt Ltd\",\n \"body\": \"Hi Maria,\\n\\nA new high-priority lead has been automatically routed to you.\\n\\n**Lead Name:** Arjun Mehta (Founder)\\n**Company:** TechVerse Pvt Ltd (SaaS, 11-50 employees)\\n**Region:** Netherlands (Europe)\\n**Need:** Looking for CRM automation and sales tracking with **WhatsApp integration**.\\n\\nThis is a high-intent inquiry. Please review the full contact record in HubSpot and follow up immediately.\\n\\nThank you,\\nGrowify AI\"\n }\n}"
},
"typeVersion": 1.3
},
{
"id": "5cc3faf8-318f-4bd8-bf42-38124b9479e5",
"name": "チームデータベース",
"type": "n8n-nodes-base.airtableTool",
"position": [
2480,
320
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appcEbIlJr6Vce1R7",
"cachedResultUrl": "https://airtable.com/appcEbIlJr6Vce1R7",
"cachedResultName": "Growify"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblmrChZlAaJSSVQq",
"cachedResultUrl": "https://airtable.com/appcEbIlJr6Vce1R7/tblmrChZlAaJSSVQq",
"cachedResultName": "Growify Sales Teams"
},
"options": {},
"operation": "search",
"authentication": "airtableOAuth2Api",
"descriptionType": "manual",
"toolDescription": "This Airtable contains team data: Team Name, Focus Industries, Region, Contact Person, Email, Max Leads, Strengths, Slack Channel."
},
"credentials": {
"airtableOAuth2Api": {
"id": "EbaOFDh1VDUEmgbD",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "23e2d128-e95e-45ae-8171-66ad12494240",
"name": "OpenAI チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2224,
320
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "wtMTeV2emnQK9uBx",
"name": "n8n free OpenAI API credits"
}
},
"typeVersion": 1.2
},
{
"id": "8527eb51-7452-469a-a53b-4167f3d0f9b6",
"name": "Google Gemini チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2880,
320
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"id": "Xhx7m5cwgQRZYO4I",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "9503f3eb-3722-4662-8a23-3ea06fd7f0ea",
"name": "レコード更新",
"type": "n8n-nodes-base.airtable",
"position": [
2016,
480
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appcEbIlJr6Vce1R7",
"cachedResultUrl": "https://airtable.com/appcEbIlJr6Vce1R7",
"cachedResultName": "Growify"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblYq8AAcldI4TZKP",
"cachedResultUrl": "https://airtable.com/appcEbIlJr6Vce1R7/tblYq8AAcldI4TZKP",
"cachedResultName": "Leads"
},
"columns": {
"value": {
"Email": "={{ $('Code in JavaScript').item.json.Email }}",
"Assigned to": "={{ $json.output.recommended_team.team_name }}",
"Lead Status": "=Asigned to {{ $json.output.recommended_team.contact_person }}",
"Persona (AI)": "={{ $json.output.lead_persona.summary }} {{ $json.output.lead_persona.primary_needs }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Record ID (HS)",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Record ID (HS)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Descriptions",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Descriptions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TEAM SIZE",
"type": "options",
"display": true,
"options": [
{
"name": "11 - 50",
"value": "11 - 50"
},
{
"name": "51 - 200",
"value": "51 - 200"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "TEAM SIZE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "aIndustry",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "aIndustry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Website",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Company Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Persona (AI)",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Persona (AI)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Assigned to",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Assigned to",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Status",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Lead Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Create Date",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Create Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"authentication": "airtableOAuth2Api"
},
"credentials": {
"airtableOAuth2Api": {
"id": "EbaOFDh1VDUEmgbD",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "1a6694ca-c981-4c27-bf19-b1248e6363a2",
"name": "メッセージ送信",
"type": "n8n-nodes-base.slack",
"position": [
2256,
480
],
"webhookId": "4835d7da-d91f-43ce-a5df-d104c6d37fa9",
"parameters": {
"text": "={{ '@' + $('AI Agent').item.json.output.slack_notification.ping.replace('<@', '').replace('>', '').split(' ')[0] }} {{ $('AI Agent').item.json.output.slack_notification.message }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "name",
"value": "={{ $('AI Agent').item.json.output.recommended_team.slack_channel }}"
},
"otherOptions": {},
"authentication": "oAuth2"
},
"credentials": {
"slackOAuth2Api": {
"id": "voioQ8kPnYUdOCh4",
"name": "Slack account"
}
},
"typeVersion": 2.3
},
{
"id": "f0cd8dd3-476a-4586-a171-2b5294061628",
"name": "メッセージ送信1",
"type": "n8n-nodes-base.gmail",
"position": [
2464,
480
],
"webhookId": "24a2c864-d5c1-404e-a024-a82242ec927c",
"parameters": {
"sendTo": "={{ $('AI Agent').item.json.output.recommended_team.email }}",
"message": "={{ $('AI Agent').item.json.output.email_notification.body }}",
"options": {
"senderName": "n8n Automation"
},
"subject": "={{ $('AI Agent').item.json.output.email_notification.subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "hnkmY7w8jrSeQt8m",
"name": "Gmail account_n8n_verified"
}
},
"typeVersion": 2.1
},
{
"id": "d18b2263-97cf-4501-b863-5b7ec99e5f51",
"name": "コンタクト作成または更新",
"type": "n8n-nodes-base.hubspot",
"position": [
2656,
480
],
"parameters": {
"email": "={{ $('Create a record').item.json.fields.Email }}",
"options": {},
"authentication": "oAuth2",
"additionalFields": {
"status": "active",
"message": "=Lead assigned to {{ $('AI Agent').item.json.output.recommended_team.team_name }} ({{ $('AI Agent').item.json.output.recommended_team.contact_person }})",
"persona": "={{ $('AI Agent').item.json.output.lead_persona.primary_needs }} {{ $('AI Agent').item.json.output.lead_persona.summary }} "
}
},
"credentials": {
"hubspotOAuth2Api": {
"id": "rZSiaJnA0L7A3Iuz",
"name": "HubSpot account"
}
},
"typeVersion": 2.2
},
{
"id": "b4511869-c295-44a1-8995-f90ef00f6f48",
"name": "操作なし（何もしない）",
"type": "n8n-nodes-base.noOp",
"position": [
2864,
480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5006a018-c511-493f-a762-c08f74a809a3",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
16
],
"parameters": {
"width": 1488,
"height": 672,
"content": ""
},
"typeVersion": 1
},
{
"id": "8f8c3d03-3ef9-404c-b663-87156bbc0750",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
-240
],
"parameters": {
"width": 752,
"height": 928,
"content": "# 🤖 AI-Powered Lead Routing and Sales Team Distribution\n\n## Overview\n\nThe **AI-Powered Lead Routing and Distribution System** automates how sales leads are qualified and assigned across teams. \n\nOnce a new lead is captured in **HubSpot**, an **AI Agent (powered by OpenAI)** analyzes it and instantly assigns the best-fit representative using data from **Airtable**. The workflow then updates **HubSpot**, logs the decision in **Airtable**, and notifies the assigned rep via **Slack** and **Gmail** — ensuring fast, data-driven lead handling. \n\n> ⚡ **Result:** Lightning-fast lead distribution, improved conversion rates, and transparent allocation across teams, sir.\n\n## 🎯 Ideal For\n\n- Sales Operations & RevOps Teams \n- Marketing & B2B SaaS Organizations \n- Enterprises managing multiple sales regions or specialists, sir \n\n\n# 🧭 User Guide — In 5 Quick Steps\n\n1. **Capture:** HubSpot detects a new lead and retrieves full contact details. \n2. **Clean:** Lead data is standardized and logged in Airtable. \n3. **Qualify:** The AI analyzes region, industry, and needs to find the ideal rep. \n4. **Distribute:** Allocation is logged; rep notified via Slack & Gmail. \n5. **Sync:** HubSpot updates with final status and AI summary, sir. \n\n\n## 🚀 Key Benefits\n\n✅ **AI Precision:** Smart, unbiased lead matching \n✅ **Speed:** Instant routing and team alerts \n✅ **Sync:** HubSpot ↔ Airtable real-time updates \n✅ **Scalable:** Built for high-volume sales teams, sir \n"
},
"typeVersion": 1
},
{
"id": "ee45d4a7-2072-426a-a444-f65da9b227b0",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
304,
-240
],
"parameters": {
"color": 6,
"width": 464,
"height": 928,
"content": "\n\n# Author Details\n\n## Manish Kumar\n### Expert Designer & Automation Engineer for Custom Shopify Apps\n\nI specialize in designing seamless customer experiences and automating workflows for Shopify, web, and business platforms. From custom apps integration to process optimization, my solutions empower teams to work smarter and scale faster.\n\n## Contact:\n### 📧 [manipritraj@gmail.com](mailto:manipritraj@gmail.com)\n### 📞 +91-9334888899\n"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"cbdf53aa-982a-4616-aa25-090bddf3c9d7": {
"main": [
[
{
"node": "9503f3eb-3722-4662-8a23-3ea06fd7f0ea",
"type": "main",
"index": 0
}
]
]
},
"5cc3faf8-318f-4bd8-bf42-38124b9479e5": {
"ai_tool": [
[
{
"node": "cbdf53aa-982a-4616-aa25-090bddf3c9d7",
"type": "ai_tool",
"index": 0
}
]
]
},
"ccb53df7-842e-412e-b57c-d5c988ee32b4": {
"main": [
[
{
"node": "d8f0393c-4c5c-4290-8cae-aab4bcd94998",
"type": "main",
"index": 0
}
]
]
},
"f4daa29b-5357-4dcf-bc72-a57111d275ed": {
"ai_memory": [
[
{
"node": "cbdf53aa-982a-4616-aa25-090bddf3c9d7",
"type": "ai_memory",
"index": 0
}
]
]
},
"9503f3eb-3722-4662-8a23-3ea06fd7f0ea": {
"main": [
[
{
"node": "1a6694ca-c981-4c27-bf19-b1248e6363a2",
"type": "main",
"index": 0
}
]
]
},
"1a6694ca-c981-4c27-bf19-b1248e6363a2": {
"main": [
[
{
"node": "f0cd8dd3-476a-4586-a171-2b5294061628",
"type": "main",
"index": 0
}
]
]
},
"ff7fd69e-be53-4cff-a118-9fb538518047": {
"main": [
[
{
"node": "cbdf53aa-982a-4616-aa25-090bddf3c9d7",
"type": "main",
"index": 0
}
]
]
},
"5c09bdc4-4447-4f89-bdf8-785b1d4f562b": {
"main": [
[
{
"node": "ccb53df7-842e-412e-b57c-d5c988ee32b4",
"type": "main",
"index": 0
}
]
]
},
"f0cd8dd3-476a-4586-a171-2b5294061628": {
"main": [
[
{
"node": "d18b2263-97cf-4501-b863-5b7ec99e5f51",
"type": "main",
"index": 0
}
]
]
},
"23e2d128-e95e-45ae-8171-66ad12494240": {
"ai_languageModel": [
[
{
"node": "cbdf53aa-982a-4616-aa25-090bddf3c9d7",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"d8f0393c-4c5c-4290-8cae-aab4bcd94998": {
"main": [
[
{
"node": "ff7fd69e-be53-4cff-a118-9fb538518047",
"type": "main",
"index": 0
}
]
]
},
"8527eb51-7452-469a-a53b-4167f3d0f9b6": {
"ai_languageModel": [
[
{
"node": "8b66f010-f6b4-4b65-b43b-6aaecbb66931",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"8b66f010-f6b4-4b65-b43b-6aaecbb66931": {
"ai_outputParser": [
[
{
"node": "cbdf53aa-982a-4616-aa25-090bddf3c9d7",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"d18b2263-97cf-4501-b863-5b7ec99e5f51": {
"main": [
[
{
"node": "b4511869-c295-44a1-8995-f90ef00f6f48",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 顧客管理, AI RAG検索拡張
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
ネイリストサロン（アメリカ）
WhatsApp、GPT、Googleカレンダーを使ったサロン予約管理の自動化
If
Set
Code
+
If
Set
Code
164 ノードDenis
サポート
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
Google GeminiとGoogleスプレッドシートを使用したShopify製品AIブログジェネレーター
GPT-4oとGoogleシートを使用したShopify製品AIブログジェネレーター
If
Code
Limit
+
If
Code
Limit
22 ノードMANISH KUMAR
その他
HubSpotコンテキストに基づくAIメール返信とSlack承認
HubSpotコンテキストに基づくAIメール返信とSlack承認
If
Code
Gmail
+
If
Code
Gmail
19 ノードMiha
顧客管理
GPT・Googleカレンダー・Supabaseを使用した自動メール管理システム
GPT、Googleカレンダー、Supabaseを使った自動メール管理システム
If
Code
Gmail
+
If
Code
Gmail
42 ノードAbdul Mir
チケット管理
Gemini AI と Airtable から画像で Shopify 製品一覧を生成
Gemini AI と Airtable を使用して、画像からShopify製品一覧を生成する
If
Set
Code
+
If
Set
Code
33 ノードMANISH KUMAR
コンテンツ作成
ワークフロー情報
難易度
上級
ノード数18
カテゴリー2
ノードタイプ14
作成者
MANISH KUMAR
@manipritrajAutomation Architect | n8n Expert I turn repetition into magic! Building workflows for: - Content creation (YouTube/social media) - Business ops (CRM/data pipelines) - Personal productivity (AI/smart home) Superpowers: API integrations • Debugging • Scalable solutions Featured: YouTube Shorts Automator • AI Report Generator • Custom ChatGPT+n8n "Automation should adapt to humans" 📧 manipritraj@gmail.com Fun fact: Automated my coffee+news+cat feeder! ☕🐈
外部リンク
n8n.ioで表示 →
このワークフローを共有