基于AIde潜在client信息增强（Bright Data MCPetGoogle Sheets）
Avancé
Ceci est unSales, AIworkflow d'automatisation du domainecontenant 51 nœuds.Utilise principalement des nœuds comme If, Set, Wait, Merge, Filter, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. 基于AIde潜在client信息增强：utilisationBright Data MCPetGoogle Sheets
Prérequis
- •Clé API HubSpot
- •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
Nœuds utilisés (51)
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
{
"meta": {
"instanceId": "4e6be3a68285934388a854ac0ffdc5e5500688d5cdb88d0ec2d734e85f097355",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "80ffc9b5-2a35-46e3-a641-45ae6f9556bd",
"name": "Google Sheets Trigger",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-5820,
2140
],
"parameters": {
"options": {
"columnsToWatch": [
"status"
]
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "VNqOvRgnzQaAingt",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "06d817c6-f625-495e-bfd3-d019a98f0ebb",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-3260,
2280
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\"$schema\": \"http://json-schema.org/draft-07/schema#\",\n\"title\": \"UserData\",\n\"type\": \"object\",\n\"properties\": {\n \"first_name\": {\n \"type\": \"string\"\n },\n \"last_name\": {\n \"type\": \"string\"\n },\n \"middle_name\": {\n \"type\": \"string\"\n },\n \"gender\": {\n \"type\": \"string\"\n },\n \"address\": {\n \"type\": \"string\"\n },\n \"city\": {\n \"type\": \"string\"\n },\n \"state\": {\n \"type\": \"string\"\n },\n \"zip\": {\n \"type\": \"integer\"\n },\n \"country\": {\n \"type\": \"string\"\n },\n \"email\": {\n \"type\": \"string\",\n \"format\": \"email\"\n },\n \"phone\": {\n \"type\": \"string\"\n },\n \"date_of_birth\": {\n \"type\": \"string\"\n },\n \"field_of_study\": {\n \"type\": \"string\"\n },\n \"graduation_date\": {\n \"type\": \"string\"\n },\n \"company\": {\n \"type\": \"string\"\n },\n \"job_title\": {\n \"type\": \"string\"\n },\n \"department\": {\n \"type\": \"string\"\n },\n \"facebook_handle\": {\n \"type\": \"string\"\n },\n \"linkedin_url\": {\n \"type\": \"string\",\n \"format\": \"uri\"\n },\n \"x_handle\": {\n \"type\": \"string\"\n },\n \"instagram_handle\": {\n \"type\": \"string\"\n },\n \"company_address\": {\n \"type\": \"string\"\n },\n \"company_city\": {\n \"type\": \"string\"\n },\n \"company_state\": {\n \"type\": \"string\"\n },\n \"company_zip\": {\n \"type\": \"integer\"\n },\n \"company_country\": {\n \"type\": \"string\"\n },\n \"company_phone\": {\n \"type\": \"string\"\n },\n \"company_email\": {\n \"type\": \"string\",\n \"format\": \"email\"\n },\n \"company_industry\": {\n \"type\": \"string\"\n },\n \"company_size\": {\n \"type\": \"integer\"\n },\n \"company_founded_year\": {\n \"type\": \"integer\"\n },\n \"degree\": {\n \"type\": \"string\"\n },\n \n \"job_function\": {\n \"type\": \"string\"\n },\n \"marital_status\": {\n \"type\": \"string\"\n },\n \"salutation\": {\n \"type\": \"string\"\n },\n \"school\": {\n \"type\": \"string\"\n },\n \"scrape_error\": {\n \"type\": \"string\"\n }\n},\n\"required\": [\n \"first_name\",\n \"last_name\",\n \"email\"\n],\n\"additionalProperties\": false\n}"
},
"typeVersion": 1.2
},
{
"id": "18ef61dc-5134-4c8b-817b-da162c093b06",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5880,
1920
],
"parameters": {
"color": 4,
"width": 460,
"height": 540,
"content": "## Watch for the updated record in Google Sheets based on the column 'status'\nWrite 'needs more enrichment' in the status column if you want to retry the enrichment\n"
},
"typeVersion": 1
},
{
"id": "e3b79eff-1504-4da3-85ef-4423f5ee71cd",
"name": "Auto-fixing Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
-3480,
2080
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease only return the first_name, last_name, email, and scrape_error (put the error details in this field)"
}
},
"typeVersion": 1
},
{
"id": "1023e561-8f92-4fe1-8d21-1b6fcd2bbb6e",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-3500,
2200
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "K4cmCYcro5viwUfR",
"name": "Thijs 2"
}
},
"typeVersion": 1.2
},
{
"id": "ac4f57e8-f7f0-47b8-b039-9a93f198083a",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6620,
1440
],
"parameters": {
"color": 4,
"width": 520,
"height": 540,
"content": "## Manually run the records that is needed enrichment\n"
},
"typeVersion": 1
},
{
"id": "c46b338f-ccb6-4ce4-a1a3-623a615d19b2",
"name": "Traiter chaque prospect un par un",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4620,
1260
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "e6f86e5f-f49f-4781-90d2-78747efd5053",
"name": "Filtrer les prospects nécessitant un enrichissement",
"type": "n8n-nodes-base.filter",
"position": [
-5600,
2140
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "1ec242aa-557e-434a-8bb5-d043b5645e88",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.status?.toString() }}",
"rightValue": ""
},
{
"id": "400fe682-5882-441f-a506-ea8f9bdb9df8",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "needs more enrichment"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "46203489-bdd1-48ea-a020-8f5e1734cbdb",
"name": "Supprimer les champs inutiles pour l'invite",
"type": "n8n-nodes-base.set",
"position": [
-4100,
1260
],
"parameters": {
"include": "except",
"options": {},
"excludeFields": "row_number, status, row_id",
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "838ba8a6-3f41-4973-b5aa-805b9abc6baa",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
720
],
"parameters": {
"color": 4,
"width": 980,
"height": 1620,
"content": "# Update the record in Google Sheet"
},
"typeVersion": 1
},
{
"id": "1315c393-9cb2-4345-ba01-34faa5673e72",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4260,
1040
],
"parameters": {
"color": 6,
"width": 840,
"height": 740,
"content": "# AI Agent with Bright Data MCP attached\nPlease play around which model suited best"
},
"typeVersion": 1
},
{
"id": "f77f311d-20c4-4e5d-a679-f905a5e1680a",
"name": "Client Bright Data MCP",
"type": "@n8n/n8n-nodes-langchain.mcpClientTool",
"position": [
-3760,
1540
],
"parameters": {
"include": "selected",
"sseEndpoint": "http://localhost:8000/sse",
"includeTools": [
"search_engine",
"web_data_linkedin_person_profile",
"web_data_linkedin_company_profile",
"web_data_linkedin_people_search",
"web_data_crunchbase_company",
"web_data_tiktok_profiles",
"web_data_instagram_profiles"
]
},
"typeVersion": 1
},
{
"id": "f5d6bf43-d9c0-4272-9d5f-cf1371f0e27a",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-4000,
1540
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "3wONK02jjm23nMHf",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "370ea5eb-0abc-418a-836f-f9e28d3f11be",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3360,
1040
],
"parameters": {
"width": 1160,
"height": 760,
"content": "# Formating the results and comparing it to the original"
},
"typeVersion": 1
},
{
"id": "cc8043c0-6306-4808-9caf-0776b9a29553",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
-2980,
1440
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "54ed6517-f4b9-48ff-baf1-37c7551c85ed",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.first_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.first_name }}"
},
{
"id": "465b70a3-9830-4521-8248-a1236795b296",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.last_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.last_name }}"
},
{
"id": "5a2f38ab-64e6-4e5d-92e2-7a88135e7884",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.email }}",
"rightValue": "={{ $('Process each leads one by one').item.json.email }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7cfe0f1d-d2ef-4630-b4d4-5ef155852f4c",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
-3240,
1280
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Email only",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "26b1eb37-80d1-4966-a223-fe7a6d032083",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $('Process each leads one by one').item.json.email !== \"\" && ($('Process each leads one by one').item.json.first_name + \" \" + $('Process each leads one by one').item.json.last_name).trim() === \"\" }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "Name only",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7a4f68df-3d5b-4476-b186-8a5fb847d78e",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $('Process each leads one by one').item.json.email === \"\" && ($('Process each leads one by one').item.json.first_name + \" \" + $('Process each leads one by one').item.json.last_name).trim() !== \"\" }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "Both email and name exists",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "13d089ae-1fd1-4a15-a35c-edae907141f5",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $('Process each leads one by one').item.json.email !== \"\" && ($('Process each leads one by one').item.json.first_name + \" \" + $('Process each leads one by one').item.json.last_name).trim() !== \"\" }}",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "f4357d32-0d4f-4131-8367-63ac527bb9e2",
"name": "If2",
"type": "n8n-nodes-base.if",
"position": [
-2980,
1120
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5a2f38ab-64e6-4e5d-92e2-7a88135e7884",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.email }}",
"rightValue": "={{ $('Process each leads one by one').item.json.email }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0efb7c41-869f-4803-b725-7133fe74dfd6",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
-2620,
1620
],
"parameters": {
"mode": "chooseBranch",
"useDataOfInput": 2
},
"typeVersion": 3.1
},
{
"id": "5478a933-3704-4282-a043-b61e7c84c86e",
"name": "If1",
"type": "n8n-nodes-base.if",
"position": [
-2980,
1280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "54ed6517-f4b9-48ff-baf1-37c7551c85ed",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.first_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.first_name }}"
},
{
"id": "465b70a3-9830-4521-8248-a1236795b296",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.last_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.last_name }}"
},
{
"id": "5a2f38ab-64e6-4e5d-92e2-7a88135e7884",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.email }}",
"rightValue": "={{ $('Process each leads one by one').item.json.email }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b96100ab-1edf-46ce-8c1d-c16c7617b327",
"name": "Not matched route",
"type": "n8n-nodes-base.noOp",
"position": [
-2400,
1200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "896fdbd8-e6b2-4e5e-8cbb-8c347714f541",
"name": "Espacement des requêtes de 5 secondes",
"type": "n8n-nodes-base.wait",
"position": [
940,
1440
],
"webhookId": "ca47f66b-d536-4751-ab54-7d1e049ca14a",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5e4b65b7-30b6-4980-a851-43b8112d6347",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3740,
1960
],
"parameters": {
"color": 6,
"width": 840,
"height": 560,
"content": "## Format the output"
},
"typeVersion": 1
},
{
"id": "146b61b9-cd18-4e72-b07f-4f848d909a66",
"name": "Agent IA de scraping",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "\nSteps:\n1. Scrape the url and find for the input fields common in the form such as text, radio buttons, checkboxes. etc. Identify selectors for these input fields. Find the submit button too or the button to proceed to the next section or step.",
"position": [
-3880,
1280
],
"parameters": {
"text": "=Here's the lead's data:\n\n{{ $json.toJsonString() }}",
"options": {
"maxIterations": 30,
"systemMessage": "=Prompt: Person and Company Enrichment Task\n\nObjective:\nEnrich the lead’s information as completely and accurately as possible. Avoid fabricating data and maintain strict adherence to the correct tool schema for each tool used in the MCP client.\n\n⸻\n\n1. Person Enrichment Instructions:\n- Start with a Google Search:\nPrioritize locating the individual’s LinkedIn profile URL using the available information.\n- Query Guidelines:\n- If the email address is available, use it in your search query.\n- If not, use the person’s first name and last name.\n- Always append keywords like “linkedin”, “facebook”, “instagram”, or other relevant social media platforms to refine the search.\n- LinkedIn-Based Enrichment:\nOnce the LinkedIn URL is found, use it to gather available details from their profile.\n\n⸻\n\n2. Company Enrichment Instructions:\n- Email Domain Extraction:\nIf the person’s email is not from a generic provider (e.g., gmail.com, outlook.com, hotmail.com, icloud.com), extract the domain and use it in your search.\n- Query Composition:\n- Combine the extracted domain with any existing value in the “company” field of the lead’s details.\n- Do not rely on or reuse company data obtained from other tool outputs.\n- Focus on sourcing reliable company information from LinkedIn and Crunchbase.\n\n⸻\n\nOutput Format:\n\nReturn the enriched data in valid JSON format using the original key structure. Exclude any fields that remain empty. Example output:\n\n{\n \"first_name\": \"John\",\n \"last_name\": \"Doe\",\n \"address\": \"123 Maple Street, Apt 4\",\n \"instagram_handle\": \"johndoe38\"\n}\n\n",
"returnIntermediateSteps": true
},
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": true,
"typeVersion": 1.9
},
{
"id": "bfbf1be5-96a7-470e-a3d2-006dbf948c4d",
"name": "Merge1",
"type": "n8n-nodes-base.merge",
"position": [
-1560,
1460
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3.1
},
{
"id": "fa2096a7-56d7-45aa-b10f-4ae7456339b4",
"name": "Évaluer la précision des données scrapées",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-2020,
1280
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "id",
"value": "=gpt-4o-mini"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "Task:\nEvaluate the accuracy of the scraped data compared to the original source data.\n\nInstructions:\n- Assess how closely the scraped output matches the original data in terms of content, structure, and completeness.\n- Provide a confidence score based on the overall accuracy.\n- Explain your reasoning in concise, clear remarks.\n\nOutput Format (JSON):\n\n{\n \"confidence\": [decimal between 0 and 1, e.g., 0.98 for 98% accuracy],\n \"remarks\": \"A brief explanation justifying the confidence score, highlighting any discrepancies or issues found.\"\n}\n"
},
{
"content": "=Original source data:\n{{ $('Remove unneccessary fields for the prompt').item.json.toJsonString() }}\n\nScraped output:\n{{ $json.output.toJsonString() }}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "K4cmCYcro5viwUfR",
"name": "Thijs 2"
}
},
"typeVersion": 1.8
},
{
"id": "32f37490-752b-4ee1-b68f-c56f17615bf4",
"name": "Just to make the connection neat",
"type": "n8n-nodes-base.noOp",
"position": [
1480,
2480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "01f944b6-e821-4ca3-ba09-bbc33f562ef4",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2080,
1020
],
"parameters": {
"color": 2,
"width": 1160,
"height": 740,
"content": "# Identify the accuracy of the scraped data\nThis may serve as another layer of accuracy filtering"
},
"typeVersion": 1
},
{
"id": "08a34aec-7419-4cb9-b495-dff406c6f61d",
"name": "Extraire uniquement les résultats IA",
"type": "n8n-nodes-base.set",
"position": [
-1820,
1280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "298abc40-159e-4aa3-ab4d-039829c2d1a0",
"name": "confidence",
"type": "number",
"value": "={{ $json.message.content.confidence }}"
},
{
"id": "c2662984-8fa9-46eb-bc6d-fb7be5fc4451",
"name": "remarks",
"type": "string",
"value": "={{ $json.message.content.remarks }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "716a21d4-230d-4747-a031-ca8aac1bc3af",
"name": "Vérifier le score de confiance",
"type": "n8n-nodes-base.if",
"position": [
-720,
1580
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f153193c-b517-49fc-8ae4-1bea6bd0ff91",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.confidence }}",
"rightValue": 0.85
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a4eb12f7-26b9-4f8f-a51a-ff54c769c06b",
"name": "Préparer la sortie scrapée pour Google Sheets",
"type": "n8n-nodes-base.set",
"position": [
-1340,
1560
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={{ $json.output }}"
},
"typeVersion": 3.4
},
{
"id": "06bf86dc-c92f-4540-8963-219015d745fb",
"name": "Ajouter le score de confiance à Google Sheet",
"type": "n8n-nodes-base.set",
"position": [
-1140,
1580
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3d437c0b-ff3e-4c21-95e0-5557866806c5",
"name": "remarks",
"type": "string",
"value": "={{ $('Merge1').item.json.remarks }}"
},
{
"id": "5ef03fde-ee61-49a3-8c73-1ab4b66654a6",
"name": "confidence",
"type": "number",
"value": "={{ $('Merge1').item.json.confidence }}"
},
{
"id": "745b0dd7-7ac9-4e97-9192-db95ff2d2706",
"name": "row_id",
"type": "string",
"value": "={{ $('Process each leads one by one').item.json.row_id }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "f6ba009f-47f1-428e-95e6-b3d8ca23208d",
"name": "Ajouter un enregistrement si le score de confiance < 85%",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
2020
],
"parameters": {
"columns": {
"value": {
"first_name": "={{ $json.output.first_name }}"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"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": "middle_name",
"type": "string",
"display": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"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": "company",
"type": "string",
"display": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9a5a4808-a8d1-4b49-82b5-b33bc48b56f5",
"name": "Remplacer l'enregistrement si le score de confiance ≥ 85%",
"type": "n8n-nodes-base.googleSheets",
"position": [
-220,
1400
],
"parameters": {
"columns": {
"value": {
"first_name": "={{ $json.output.first_name }}",
"row_number": "={{ $('Google Sheets').item.json.row_number }}"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"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": "middle_name",
"type": "string",
"display": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"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": "company",
"type": "string",
"display": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "1eb07d73-aa8f-4cba-a760-5d142eea9734",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
1260
],
"parameters": {
"color": 7,
"width": 480,
"height": 360,
"content": "## Override the record if the confidence score is equal or greater than 85%"
},
"typeVersion": 1
},
{
"id": "274d8c92-9094-4b26-8d6e-689e38fe9540",
"name": "Mettre à jour le statut de l'enregistrement",
"type": "n8n-nodes-base.googleSheets",
"position": [
-220,
1020
],
"parameters": {
"columns": {
"value": {
"row_id": "={{ $('Process each leads one by one').item.json.row_id }}",
"status": "no information found"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "middle_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9958acae-7675-48c2-a400-0ee00267745f",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
1700
],
"parameters": {
"color": 7,
"width": 480,
"height": 560,
"content": "## Append row if the confidence score is below 85%"
},
"typeVersion": 1
},
{
"id": "ae5d281a-31a3-46a0-b5af-8dcf376d2947",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
840
],
"parameters": {
"color": 7,
"width": 480,
"height": 360,
"content": "## Scraped data doesn't match the source. This will only update the status of the record."
},
"typeVersion": 1
},
{
"id": "a5aa4f8f-d7ec-4d28-87a2-c774ba627a95",
"name": "Mettre à jour row_id et statut",
"type": "n8n-nodes-base.set",
"position": [
-300,
2020
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "9edb1a8c-d71c-4b13-aa89-6a329a58fd67",
"name": "row_id",
"type": "string",
"value": "={{ $('Process each leads one by one').item.json.row_id }}-{{ $now.toMillis() }}"
},
{
"id": "e95fdab0-79a5-4546-9b6d-0750fd44932c",
"name": "status",
"type": "string",
"value": "human review needed"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "2eb2c10a-1ab8-408f-9411-13fa356b4664",
"name": "Mettre à jour le statut de l'enregistrement original",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
1780
],
"parameters": {
"columns": {
"value": {
"row_id": "={{ $json.row_id }}",
"status": "human review needed"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "middle_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "e2cb5ff7-3d0d-4766-bda2-2ea5d1b8cf54",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
-5960,
780
],
"parameters": {
"options": {},
"fieldToSplitOut": "body"
},
"typeVersion": 1
},
{
"id": "da05a953-9e66-49b5-8c62-5cd48f439772",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-5420,
900
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json.properties.email.value }}",
"phone": "={{ $json.properties.phone.value }}",
"row_id": "={{ $json.vid }}",
"last_name": "={{ $json.properties.lastname.value }}",
"first_name": "={{ $json.properties.firstname.value }}"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"required": false,
"displayName": "row_id",
"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": "middle_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "48243a45-396f-4610-b97f-808ca39e90a6",
"name": "HubSpot",
"type": "n8n-nodes-base.hubspot",
"position": [
-5680,
900
],
"parameters": {
"contactId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.contactId || $json.objectId }}"
},
"operation": "get",
"authentication": "appToken",
"additionalFields": {}
},
"credentials": {
"hubspotAppToken": {
"id": "udy2ya160kahX72n",
"name": "HubSpot App Token account 2"
}
},
"typeVersion": 2.1
},
{
"id": "1088136d-5530-47f2-b08f-3c91c28bd383",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-6280,
1620
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "status"
},
{
"lookupValue": "needs more enrichment",
"lookupColumn": "status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
},
"combineFilters": "OR"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "16a4e5d7-3d4f-4aa4-b802-5bc61c6767b6",
"name": "When clicking ‘Execute workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-6520,
1620
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2cf15cf0-be32-41d8-82f6-78a142e32b4a",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6500,
540
],
"parameters": {
"color": 3,
"width": 1380,
"height": 720,
"content": "# New Contact trigger in Hubspot and Save it to Google Drive"
},
"typeVersion": 1
},
{
"id": "6a2d33a9-c2f9-412e-a70c-8a64b7da252b",
"name": "New Contact in Hubpost (OAuth2)",
"type": "n8n-nodes-base.hubspotTrigger",
"position": [
-6340,
1020
],
"webhookId": "dab75ae0-affc-4616-bad6-2e88d1afabc7",
"parameters": {
"eventsUi": {
"eventValues": [
{}
]
},
"additionalFields": {}
},
"credentials": {
"hubspotDeveloperApi": {
"id": "HjFlmcRCWYRjI6nD",
"name": "New HS Dev"
}
},
"typeVersion": 1
},
{
"id": "fd273f08-9d98-4539-bad1-96a1ea6c0fc5",
"name": "New Contact in Hubpost (Private App)",
"type": "n8n-nodes-base.webhook",
"position": [
-6320,
680
],
"webhookId": "40d4eddf-4f9f-471f-a029-4a95f5f045b9",
"parameters": {
"path": "hsleads",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "d348c77a-7782-45c5-9d6d-d7464ff876c6",
"name": "No Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"position": [
300,
1560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6a1149d6-186f-49ce-a8b3-3a97b83b10a7",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
1840
],
"parameters": {
"color": 3,
"width": 680,
"height": 500,
"content": "# Update the Hubspot contact for the high confidence score"
},
"typeVersion": 1
},
{
"id": "2c3f4e27-a1ee-4a0a-8fb8-180b5de97ae6",
"name": "Update the Hubspot Contact",
"type": "n8n-nodes-base.hubspot",
"position": [
880,
2080
],
"parameters": {
"email": "={{ $json.email }}",
"options": {},
"authentication": "appToken",
"additionalFields": {
"city": "={{ $json.city }}",
"degree": "={{ $json.degree }}",
"gender": "={{ $json.gender }}",
"school": "={{ $json.school }}",
"country": "={{ $json.country }}",
"industry": "={{ $json.company_industry }}",
"jobTitle": "={{ $json.job_title }}",
"lastName": "={{ $json.last_name }}",
"firstName": "={{ $json.first_name }}",
"postalCode": "={{ $json.zip }}",
"salutation": "={{ $json.salutation }}",
"companyName": "={{ $json.company }}",
"dateOfBirth": "={{ $json.date_of_birth?.toDateTime() }}",
"jobFunction": "={{ $json.job_function }}",
"phoneNumber": "={{ $json.phone }}",
"fieldOfStudy": "={{ $json.field_of_study }}",
"maritalStatus": "={{ $json.marital_status }}",
"streetAddress": "={{ $json.address }}",
"graduationDate": "={{ $json.graduation_date?.toDateTime() }}",
"twitterUsername": "={{ $json.x_handle }}",
"customPropertiesUi": {
"customPropertiesValues": [
{
"value": "={{ $json.instagram_handle }}",
"property": "=instagram_handle"
},
{
"value": "={{ $json.facebook_handle }}",
"property": "=facebook_handle"
},
{
"value": "={{ $json.linkedin_url }}",
"property": "=linkedin_url"
}
]
}
}
},
"credentials": {
"hubspotAppToken": {
"id": "udy2ya160kahX72n",
"name": "HubSpot App Token account 2"
}
},
"typeVersion": 2.1
},
{
"id": "fdadcb0e-f66e-4755-8939-ab28d51301eb",
"name": "Set Desired Confidence Score",
"type": "n8n-nodes-base.if",
"position": [
580,
2100
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8f546fac-c14d-40f8-9fd0-7c431e1ae7f8",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.confidence }}",
"rightValue": 0.89
}
]
}
},
"typeVersion": 2.2
}
],
"pinData": {
"New Contact in Hubpost (OAuth2)": [
{
"appId": 7851008,
"eventId": 1468606353,
"portalId": 46194715,
"sourceId": "userId:60775145",
"contactId": 126603412869,
"changeFlag": "CREATED",
"occurredAt": 1748880900273,
"changeSource": "CRM_UI",
"attemptNumber": 0,
"subscriptionId": 3713763,
"subscriptionType": "contact.creation"
}
],
"New Contact in Hubpost (Private App)": [
{
"body": [
{
"appId": 10626375,
"eventId": 3048592825,
"objectId": 126603412869,
"portalId": 23861635,
"sourceId": "25200",
"changeFlag": "CREATED",
"occurredAt": 1746526735728,
"changeSource": "INTEGRATION",
"attemptNumber": 0,
"subscriptionId": 3429387,
"subscriptionType": "contact.creation"
}
],
"query": {},
"params": {},
"headers": {
"host": "hostmetric.app.n8n.cloud",
"accept": "*/*",
"cf-ray": "93b7bc86b08cd695-IAD",
"cdn-loop": "cloudflare; loops=1; subreqs=1",
"cf-ew-via": "15",
"cf-worker": "n8n.cloud",
"x-real-ip": "54.174.62.144",
"cf-visitor": "{\"scheme\":\"https\"}",
"user-agent": "HubSpot Connect 2.0 (http://dev.hubspot.com/) (namespace: webhooks-nio-http-client) - WebhooksExecutorDaemon-executor",
"cf-ipcountry": "US",
"content-type": "application/json",
"x-is-trusted": "yes",
"content-length": "264",
"accept-encoding": "gzip, br",
"x-forwarded-for": "54.174.62.144, 162.158.79.214",
"cf-connecting-ip": "54.174.62.144",
"x-forwarded-host": "hostmetric.app.n8n.cloud",
"x-forwarded-port": "443",
"x-forwarded-proto": "https",
"x-forwarded-server": "traefik-prod-users-gwc-36-bc488dfd9-8q4qs",
"x-hubspot-signature": "c9e6138e683ed3092c5e223f3046cab7940dca29417666154796d1cffbfe4e58",
"x-hubspot-signature-v3": "9f5gSQ/tiqplcUzRVIHzK0igKjJYRxqzKraiB7URkIY=",
"x-hubspot-timeout-millis": "10000",
"x-hubspot-request-timestamp": "1746526736409",
"x-hubspot-signature-version": "v1"
},
"webhookUrl": "https://hostmetric.app.n8n.cloud/webhook/overnightleads",
"executionMode": "production"
}
]
},
"connections": {
"cc8043c0-6306-4808-9caf-0776b9a29553": {
"main": [
[
{
"node": "0efb7c41-869f-4803-b725-7133fe74dfd6",
"type": "main",
"index": 0
}
],
[
{
"node": "b96100ab-1edf-46ce-8c1d-c16c7617b327",
"type": "main",
"index": 0
}
]
]
},
"5478a933-3704-4282-a043-b61e7c84c86e": {
"main": [
[
{
"node": "0efb7c41-869f-4803-b725-7133fe74dfd6",
"type": "main",
"index": 0
}
],
[
{
"node": "b96100ab-1edf-46ce-8c1d-c16c7617b327",
"type": "main",
"index": 0
}
]
]
},
"f4357d32-0d4f-4131-8367-63ac527bb9e2": {
"main": [
[
{
"node": "0efb7c41-869f-4803-b725-7133fe74dfd6",
"type": "main",
"index": 0
}
],
[
{
"node": "b96100ab-1edf-46ce-8c1d-c16c7617b327",
"type": "main",
"index": 0
}
]
]
},
"0efb7c41-869f-4803-b725-7133fe74dfd6": {
"main": [
[
{
"node": "bfbf1be5-96a7-470e-a3d2-006dbf948c4d",
"type": "main",
"index": 1
},
{
"node": "fa2096a7-56d7-45aa-b10f-4ae7456339b4",
"type": "main",
"index": 0
}
]
]
},
"bfbf1be5-96a7-470e-a3d2-006dbf948c4d": {
"main": [
[
{
"node": "a4eb12f7-26b9-4f8f-a51a-ff54c769c06b",
"type": "main",
"index": 0
}
]
]
},
"7cfe0f1d-d2ef-4630-b4d4-5ef155852f4c": {
"main": [
[
{
"node": "f4357d32-0d4f-4131-8367-63ac527bb9e2",
"type": "main",
"index": 0
}
],
[
{
"node": "5478a933-3704-4282-a043-b61e7c84c86e",
"type": "main",
"index": 0
}
],
[
{
"node": "cc8043c0-6306-4808-9caf-0776b9a29553",
"type": "main",
"index": 0
}
]
]
},
"48243a45-396f-4610-b97f-808ca39e90a6": {
"main": [
[
{
"node": "da05a953-9e66-49b5-8c62-5cd48f439772",
"type": "main",
"index": 0
}
]
]
},
"e2cb5ff7-3d0d-4766-bda2-2ea5d1b8cf54": {
"main": [
[
{
"node": "48243a45-396f-4610-b97f-808ca39e90a6",
"type": "main",
"index": 0
}
]
]
},
"da05a953-9e66-49b5-8c62-5cd48f439772": {
"main": [
[
{
"node": "c46b338f-ccb6-4ce4-a1a3-623a615d19b2",
"type": "main",
"index": 0
}
]
]
},
"1088136d-5530-47f2-b08f-3c91c28bd383": {
"main": [
[
{
"node": "c46b338f-ccb6-4ce4-a1a3-623a615d19b2",
"type": "main",
"index": 0
}
]
]
},
"146b61b9-cd18-4e72-b07f-4f848d909a66": {
"main": [
[
{
"node": "7cfe0f1d-d2ef-4630-b4d4-5ef155852f4c",
"type": "main",
"index": 0
},
{
"node": "0efb7c41-869f-4803-b725-7133fe74dfd6",
"type": "main",
"index": 1
}
]
]
},
"b96100ab-1edf-46ce-8c1d-c16c7617b327": {
"main": [
[
{
"node": "274d8c92-9094-4b26-8d6e-689e38fe9540",
"type": "main",
"index": 0
}
]
]
},
"f5d6bf43-d9c0-4272-9d5f-cf1371f0e27a": {
"ai_languageModel": [
[
{
"node": "146b61b9-cd18-4e72-b07f-4f848d909a66",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"1023e561-8f92-4fe1-8d21-1b6fcd2bbb6e": {
"ai_languageModel": [
[
{
"node": "e3b79eff-1504-4da3-85ef-4423f5ee71cd",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"80ffc9b5-2a35-46e3-a641-45ae6f9556bd": {
"main": [
[
{
"node": "e6f86e5f-f49f-4781-90d2-78747efd5053",
"type": "main",
"index": 0
}
]
]
},
"f77f311d-20c4-4e5d-a679-f905a5e1680a": {
"ai_tool": [
[
{
"node": "146b61b9-cd18-4e72-b07f-4f848d909a66",
"type": "ai_tool",
"index": 0
}
]
]
},
"d348c77a-7782-45c5-9d6d-d7464ff876c6": {
"main": [
[
{
"node": "fdadcb0e-f66e-4755-8939-ab28d51301eb",
"type": "main",
"index": 0
}
]
]
},
"06d817c6-f625-495e-bfd3-d019a98f0ebb": {
"ai_outputParser": [
[
{
"node": "e3b79eff-1504-4da3-85ef-4423f5ee71cd",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"a5aa4f8f-d7ec-4d28-87a2-c774ba627a95": {
"main": [
[
{
"node": "f6ba009f-47f1-428e-95e6-b3d8ca23208d",
"type": "main",
"index": 0
}
]
]
},
"e3b79eff-1504-4da3-85ef-4423f5ee71cd": {
"ai_outputParser": [
[
{
"node": "146b61b9-cd18-4e72-b07f-4f848d909a66",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"716a21d4-230d-4747-a031-ca8aac1bc3af": {
"main": [
[
{
"node": "9a5a4808-a8d1-4b49-82b5-b33bc48b56f5",
"type": "main",
"index": 0
},
{
"node": "d348c77a-7782-45c5-9d6d-d7464ff876c6",
"type": "main",
"index": 0
}
],
[
{
"node": "a5aa4f8f-d7ec-4d28-87a2-c774ba627a95",
"type": "main",
"index": 0
},
{
"node": "2eb2c10a-1ab8-408f-9411-13fa356b4664",
"type": "main",
"index": 0
}
]
]
},
"08a34aec-7419-4cb9-b495-dff406c6f61d": {
"main": [
[
{
"node": "bfbf1be5-96a7-470e-a3d2-006dbf948c4d",
"type": "main",
"index": 0
}
]
]
},
"896fdbd8-e6b2-4e5e-8cbb-8c347714f541": {
"main": [
[
{
"node": "32f37490-752b-4ee1-b68f-c56f17615bf4",
"type": "main",
"index": 0
}
]
]
},
"fdadcb0e-f66e-4755-8939-ab28d51301eb": {
"main": [
[
{
"node": "2c3f4e27-a1ee-4a0a-8fb8-180b5de97ae6",
"type": "main",
"index": 0
}
]
]
},
"c46b338f-ccb6-4ce4-a1a3-623a615d19b2": {
"main": [
[],
[
{
"node": "46203489-bdd1-48ea-a020-8f5e1734cbdb",
"type": "main",
"index": 0
}
]
]
},
"6a2d33a9-c2f9-412e-a70c-8a64b7da252b": {
"main": [
[
{
"node": "48243a45-396f-4610-b97f-808ca39e90a6",
"type": "main",
"index": 0
}
]
]
},
"274d8c92-9094-4b26-8d6e-689e38fe9540": {
"main": [
[
{
"node": "896fdbd8-e6b2-4e5e-8cbb-8c347714f541",
"type": "main",
"index": 0
}
]
]
},
"32f37490-752b-4ee1-b68f-c56f17615bf4": {
"main": [
[
{
"node": "c46b338f-ccb6-4ce4-a1a3-623a615d19b2",
"type": "main",
"index": 0
}
]
]
},
"fa2096a7-56d7-45aa-b10f-4ae7456339b4": {
"main": [
[
{
"node": "08a34aec-7419-4cb9-b495-dff406c6f61d",
"type": "main",
"index": 0
}
]
]
},
"06bf86dc-c92f-4540-8963-219015d745fb": {
"main": [
[
{
"node": "716a21d4-230d-4747-a031-ca8aac1bc3af",
"type": "main",
"index": 0
}
]
]
},
"fd273f08-9d98-4539-bad1-96a1ea6c0fc5": {
"main": [
[
{
"node": "e2cb5ff7-3d0d-4766-bda2-2ea5d1b8cf54",
"type": "main",
"index": 0
}
]
]
},
"16a4e5d7-3d4f-4aa4-b802-5bc61c6767b6": {
"main": [
[
{
"node": "1088136d-5530-47f2-b08f-3c91c28bd383",
"type": "main",
"index": 0
}
]
]
},
"e6f86e5f-f49f-4781-90d2-78747efd5053": {
"main": [
[
{
"node": "c46b338f-ccb6-4ce4-a1a3-623a615d19b2",
"type": "main",
"index": 0
}
]
]
},
"46203489-bdd1-48ea-a020-8f5e1734cbdb": {
"main": [
[
{
"node": "146b61b9-cd18-4e72-b07f-4f848d909a66",
"type": "main",
"index": 0
}
]
]
},
"a4eb12f7-26b9-4f8f-a51a-ff54c769c06b": {
"main": [
[
{
"node": "06bf86dc-c92f-4540-8963-219015d745fb",
"type": "main",
"index": 0
}
]
]
},
"f6ba009f-47f1-428e-95e6-b3d8ca23208d": {
"main": [
[
{
"node": "896fdbd8-e6b2-4e5e-8cbb-8c347714f541",
"type": "main",
"index": 0
}
]
]
},
"9a5a4808-a8d1-4b49-82b5-b33bc48b56f5": {
"main": [
[
{
"node": "896fdbd8-e6b2-4e5e-8cbb-8c347714f541",
"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é - Ventes, Intelligence Artificielle
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
[Modèle] AI Pet Shop v8
🐶 Assistant de magasin de pets IA - Intégration de GPT-4o, Google Calendar et WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NœudsAmanda Benks
Ventes
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
Agent IA restaurant [Modèle]
🤖 Assistant IA pour WhatsApp, Instagram et Messenger
If
N8n
Set
+
If
N8n
Set
239 NœudsAmanda Benks
Autres
marketinge-mailAI个性化多produit
基于SMTP轮换deAI个性化多produite-mailmarketing（GPT-4o/o3-mini）
If
Code
Wait
+
If
Code
Wait
41 NœudsBadr
Ventes
Créer un assistant de support client automatisé avec GPT-4o et GoHighLevel SMS
Créer un assistant de support client automatisé avec GPT-4o et GoHighLevel SMS
If
Set
Xml
+
If
Set
Xml
43 NœudsCyril Nicko Gaspar
Support
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds51
Catégorie2
Types de nœuds22
Description de la difficulté
Auteur
Cyril Nicko Gaspar
@cngasparLiens externes
Voir sur n8n.io →
Partager ce workflow