AI-Powered Lead Enrichment with Bright Data MCP and Google Sheets
Experte
Dies ist ein Sales, AI-Bereich Automatisierungsworkflow mit 51 Nodes. Hauptsächlich werden If, Set, Wait, Merge, Filter und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung.
Voraussetzungen
- •HubSpot API Key
- •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
Verwendete Nodes (51)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"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": "Verarbeite Leads einzeln",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4620,
1260
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "e6f86e5f-f49f-4781-90d2-78747efd5053",
"name": "Filtere anreicherungsbedürftige Leads",
"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": "Entferne unnötige Felder für den Prompt",
"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": "Bright Data MCP Client",
"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": "Anfragen um 5 Sekunden verzögern",
"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": "Scraper AI Agent",
"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": "Beurteile Genauigkeit der gescrapten Daten",
"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": "Dient nur zum Ordnen der Verbindung",
"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": "Extrahiere nur KI-Ergebnisse",
"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": "Prüfe Confidence Score",
"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": "Bereite gescrapte Ausgabe für Google Sheets vor",
"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": "Füge Confidence Score zu Google Sheet hinzu",
"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": "Füge Datensatz hinzu bei Confidence Score unter 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": "Überschreibe Datensatz bei Confidence Score ≥ 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": "Aktualisiere Status des Datensatzes",
"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": "Aktualisiere row_id und Status",
"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": "Aktualisiere Status des Originaldatensatzes",
"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": "Bei Klick auf 'Workflow ausführen'",
"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": "Aktualisiere 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
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Vertrieb, Künstliche Intelligenz
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
[Template] KI-Haustierladen v8
🐥 KI-Assistent für Tiernahrungsshops - Integriert GPT-4o, Google Kalender und WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NodesAmanda Benks
Vertrieb
Haustierladen 4
🐥 KI-Terminassistent für Tierbedarfsgeschäfte
If
Set
Code
+
If
Set
Code
187 NodesBruno Dias
Künstliche Intelligenz
KI-Agent Restaurant [Vorlage]
🤖 KI-Restaurantassistent für WhatsApp, Instagram und Messenger
If
N8n
Set
+
If
N8n
Set
239 NodesAmanda Benks
Sonstiges
AI-Personalized Multi-Product Email Outreach with SMTP Rotation (GPT-4o-o3-mini)
If
Code
Wait
+
If
Code
Wait
41 NodesBadr
Vertrieb
Erstellung eines automatisierten Kundensupport-Assistenten mit GPT-4o und GoHighLevel SMS
Erstelle einen automatisierten Kundensupport-Assistenten mit GPT-4o und GoHighLevel SMS
If
Set
Xml
+
If
Set
Xml
43 NodesCyril Nicko Gaspar
Support
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes51
Kategorie2
Node-Typen22
Autor
Cyril Nicko Gaspar
@cngasparExterne Links
Auf n8n.io ansehen →
Diesen Workflow teilen