Cyril Nicko Gaspar This workflow corresponds to n8n.io template #4589 — we link there as the canonical source.
This workflow follows the Agent → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": "Process each leads one by one",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4620,
1260
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "e6f86e5f-f49f-4781-90d2-78747efd5053",
"name": "Filter the leads that needs enrichment",
"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": "Remove unneccessary fields for the 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": {
"name": "<your credential>"
}
},
"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": "Space requests by 5 seconds",
"type": "n8n-nodes-base.wait",
"position": [
940,
1440
],
"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\u2019s 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\u2e3b\n\n1. Person Enrichment Instructions:\n- Start with a Google Search:\nPrioritize locating the individual\u2019s 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\u2019s first name and last name.\n- Always append keywords like \u201clinkedin\u201d, \u201cfacebook\u201d, \u201cinstagram\u201d, 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\u2e3b\n\n2. Company Enrichment Instructions:\n- Email Domain Extraction:\nIf the person\u2019s 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 \u201ccompany\u201d field of the lead\u2019s 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\u2e3b\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": "Judge the accuracy of scraped data",
"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": {
"name": "<your credential>"
}
},
"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": "Extract the AI results only",
"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": "Check the 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": "Prepare the scraped output for 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": "Add confidence score to 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": "Add record if the confidence score is below 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": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "9a5a4808-a8d1-4b49-82b5-b33bc48b56f5",
"name": "Override the record if the confidence score is equal or greater than 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": {
"name": "<your credential>"
}
},
"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": "Update the status of the record",
"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.googl
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApigoogleSheetsTriggerOAuth2ApihubspotAppTokenhubspotDeveloperApiopenAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This template enables natural-language-driven automation using Bright Data's MCP tools, triggered directly by new leads in HubSpot. It dynamically extracts and executes the right tool based on lead context—powered by AI and configurable in N8N.
Source: https://n8n.io/workflows/4589/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This automation is designed to help you generate AI-powered music tracks, cover art, and fully rendered music videos — all triggered from a simple Telegram chat and managed via Google Sheets.
OpenAI Chat, Memory Buffer Window, Output Parser Structured +11
It’s a fully structured workflow for anyone who needs to analyze Instagram profiles at scale, with AI, and keep everything tracked and organized — no manual effort, no copy-paste, and total control ov
Airtop, Output Parser Autofixing, OpenAI Chat +4
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Agent, OpenAI Chat, N8N Nodes Mcp +4
🎯 Create viral TikToks, Shorts, Reels, podcasts, and ASMR videos in minutes — all on autopilot.
OpenAI, HTTP Request, Form Trigger +7
Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato 2. Uses @blotato/n8n-nodes-blotato, googleSheets, lmChatOpenAi, toolThink. Event-driven trigger; 94 nodes.
@Blotato/N8N Nodes Blotato, Google Sheets, OpenAI Chat +9