{ "meta": { "instanceId": "5aaf4236c70e34e423fbdb2c7b754d19253a933bb1476d548f75848a01e473cf", "templateId": "3561" }, "nodes": [ { "id": "f3641141-a880-4400-bad7-909558848c20", "name": "When clicking \"Test workflow\"", "type": "n8n-nodes-base.manualTrigger", "position": [ 2260, 820 ], "parameters": [], "typeVersion": 1 }, { "id": "7b1ddbd1-f918-4ef9-a05e-2c02e6de75df", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [ 380, 580 ], "parameters": { "color": 4, "width": 1289, "height": 2698, "content": "=======================================\n WORKFLOW DETAILS & GUIDELINES\n=======================================\nName:\n LinkedIn Enrichment & Ice Breaker Generator\n\nPurpose:\n Automate the process of enriching LinkedIn profiles using Bright Data,\n generate personalized ice breakers with an LLM, and update Google Sheets.\n\nTools Needed:\n - n8n Nodes:\n • Manual Trigger or Schedule Trigger\n • Set\n • SplitInBatches\n • HTTP Request\n • If\n • Wait\n • Google Sheets\n • LangChain LLM (Claude via Anthropic)\n - External Services:\n • Bright Data (Dataset API)\n • Anthropic Claude (Haiku)\n • Google Sheets API\n\nAPI Keys & Authentication Required:\n • Bright Data API Key\n → Used in HTTP Request headers as:\n `Authorization: Bearer YOUR_BRIGHTDATA_API_KEY`\n • Google Sheets OAuth2 Credentials\n → Connects n8n to your Google account for reading\/writing to Sheets.\n • Anthropic API Key\n → Used for generating ice breakers via Claude models.\n → Must be set in the Anthropic credential section in n8n.\n\nGeneral Guidelines:\n • Use descriptive and consistent naming for all nodes.\n • Add retry limits to polling loops to avoid infinite cycles.\n • Ensure each LinkedIn URL maps to a unique `row_number`.\n • Obfuscate any keys before sharing the workflow publicly.\n\nThings to be Aware Of:\n • Bright Data may require some delay (via Wait node) before snapshot is ready.\n • Retry logic should not exceed API rate limits.\n • If snapshot fails or times out, ensure fallback logging is in place.\n • Claude model IDs and prompt formats may change — validate before updates.\n\nAdditional Notes:\n • Make a copy of the Google Sheet template before use.\n • Replace placeholders in `Authorization` headers and credentials section.\n • Use test data first to avoid exhausting API quotas during setup.\n\n=======================================\n\nThis workflow allows you to enrich LinkedIn profiles using Bright Data,\ngenerate AI-written ice breakers with Claude, and log everything into Google Sheets.\n" }, "typeVersion": 1 }, { "id": "215cd515-149b-41b1-adbe-fa203cbc9b5d", "name": "Get rows to enrich", "type": "n8n-nodes-base.googleSheets", "position": [ 2540, 820 ], "parameters": { "options": [], "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1g8Dum0tfZ1nQdd3b6sLhZX2aMu6FzwoVvD0EAXMpPx8\/edit#gid=0", "cachedResultName": "input" }, "documentId": { "__rl": true, "mode": "list", "value": "1g8Dum0tfZ1nQdd3b6sLhZX2aMu6FzwoVvD0EAXMpPx8", "cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1g8Dum0tfZ1nQdd3b6sLhZX2aMu6FzwoVvD0EAXMpPx8\/edit?usp=drivesdk", "cachedResultName": "NoFluff-N8N-Sheet-Template-Hyper Personalization" } }, "credentials": { "googleSheetsOAuth2Api": { "id": "gq9mwBL5a74eYjfd", "name": "Google Sheets account" } }, "typeVersion": 4.3 }, { "id": "f140e851-6409-4169-b5af-28ab6f16d99c", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [ 3220, 680 ], "parameters": { "width": 1420, "height": 460, "content": "Personal Data" }, "typeVersion": 1 }, { "id": "8878ae56-0772-498a-b153-b628222f6688", "name": "Sticky Note5", "type": "n8n-nodes-base.stickyNote", "position": [ 2220, 680 ], "parameters": { "width": 266.12865147126786, "height": 627.5654650079845, "content": "Run the workflow manually or activate it to run on schedule\n" }, "typeVersion": 1 }, { "id": "df3f1f83-1092-40fe-bc5d-301e9a118601", "name": "Sticky Note7", "type": "n8n-nodes-base.stickyNote", "position": [ 2500, 460 ], "parameters": { "width": 194.6864335083109, "height": 525.6560478822986, "content": "In this workflow, I use Google Sheets to store the results. \n\nYou can use my template to get started faster:\n\n1. [Click on this link to get the template](https:\/\/docs.google.com\/spreadsheets\/d\/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4\/edit?usp=sharing)\n2. Make a copy of the Sheets\n3. Add the URL to this node and the node **\"Google Sheets - Update Row with data\"**\n\n\n" }, "typeVersion": 1 }, { "id": "1c294196-206a-4add-8d47-8558ba99515d", "name": "Sticky Note9", "type": "n8n-nodes-base.stickyNote", "position": [ 380, 240 ], "parameters": { "color": 4, "width": 1280, "height": 320, "content": "=======================================\n WORKFLOW ASSISTANCE\n=======================================\nFor any questions or support, please contact:\n Yaron@nofluff.online\n\nExplore more tips and tutorials here:\n - YouTube: https:\/\/www.youtube.com\/@YaronBeen\/videos\n - LinkedIn: https:\/\/www.linkedin.com\/in\/yaronbeen\/\n=======================================\n" }, "typeVersion": 1 }, { "id": "3491b2bf-83a0-4966-9ff5-9c7c55f316e0", "name": "Anthropic Chat Model", "type": "@n8n\/n8n-nodes-langchain.lmChatAnthropic", "position": [ 4800, 1240 ], "parameters": { "model": { "__rl": true, "mode": "list", "value": "claude-3-5-haiku-20241022", "cachedResultName": "Claude 3.5 Haiku" }, "options": [] }, "typeVersion": 1.3 }, { "id": "66b79bfc-3447-4b42-9617-308e490079bb", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [ 4720, 880 ], "parameters": { "width": 1120, "height": 580, "content": "ICE BREAKER\n" }, "typeVersion": 1 }, { "id": "7557e53f-b898-4831-a52e-be9eeb0f4964", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [ 2940, 560 ], "parameters": { "color": 4, "width": 2980, "height": 1000, "content": "LOOP" }, "typeVersion": 1 }, { "id": "0119ee4c-bc70-4aef-84e0-881cdea57aa9", "name": "Basic LLM Chain- Ice Breaker", "type": "@n8n\/n8n-nodes-langchain.chainLlm", "position": [ 4920, 900 ], "parameters": { "text": "=Help me with writing a witty Ice breaker to try to persuade {{ $json.name }} from{{ $('BrightData_Get_Linkedin').item.json.city }}. His About section in his Linkedin profile says:{{ $('BrightData_Get_Linkedin').item.json.about }}. \nHe also had a recent post about:{{ $('BrightData_Get_Linkedin').item.json.posts[0].title }}\n\nMake it 4 lines maximum. Focus more on his recent post, not the about. Just to make it feel personalized yet respectful and not creepy.\n\nWRITE THE ICE BREAKER Straight away. Dont write \"here's a draft\" or any other text before your actual response.", "promptType": "define" }, "retryOnFail": true, "typeVersion": 1.6 }, { "id": "e3965132-4d21-4252-ab26-525128d79d29", "name": "BrightData_Get_Linkedin", "type": "n8n-nodes-base.httpRequest", "position": [ 4120, 740 ], "parameters": { "url": "=https:\/\/api.brightdata.com\/datasets\/v3\/snapshot\/{{ $json.snapshot_id }}", "options": [], "sendQuery": true, "sendHeaders": true, "queryParameters": { "parameters": [ { "name": "format", "value": "json" } ] }, "headerParameters": { "parameters": [ { "name": "Authorization", "value": "Bearer " } ] } }, "typeVersion": 4.2 }, { "id": "0e55b67e-7ddb-4431-8250-59be59c6c557", "name": "Adjust_input_for_loop", "type": "n8n-nodes-base.set", "position": [ 2740, 820 ], "parameters": { "options": [], "assignments": { "assignments": [ { "id": "fcc97354-b9f6-4459-a004-46e87902c77c", "name": "person_input", "type": "string", "value": "={{ $json.Linkedin_URL_Person }}" }, { "id": "e5415c49-5204-45b1-a0e9-814157127b12", "name": "row_number", "type": "number", "value": "={{ $json.row_number }}" } ] } }, "typeVersion": 3.3 }, { "id": "0cc85426-64f7-41f8-bd9a-215aaaad3299", "name": "HTTP_Request_Post_Request_BrightData", "type": "n8n-nodes-base.httpRequest", "position": [ 3300, 740 ], "parameters": { "url": "https:\/\/api.brightdata.com\/datasets\/v3\/trigger", "method": "POST", "options": [], "jsonBody": "=[\n {\n \"url\": \"{{ $json.person_input }}\"\n }\n]", "sendBody": true, "sendQuery": true, "sendHeaders": true, "specifyBody": "json", "queryParameters": { "parameters": [ { "name": "dataset_id", "value": "gd_l1viktl72bvl7bjuj0" }, { "name": "include_errors", "value": "true" } ] }, "headerParameters": { "parameters": [ { "name": "Authorization", "value": "Bearer " } ] } }, "typeVersion": 4.2 }, { "id": "851b23e0-6a1b-4a47-95e9-d2f769243a57", "name": "Wait_For_API_Call_Results", "type": "n8n-nodes-base.wait", "position": [ 3500, 740 ], "webhookId": "8005a2b3-2195-479e-badb-d90e4240e699", "parameters": { "amount": 10 }, "executeOnce": false, "typeVersion": 1.1 }, { "id": "294a7c03-2268-4d7a-b4e7-a52faa78d929", "name": "API_Call_Snapshot_Progress", "type": "n8n-nodes-base.httpRequest", "position": [ 3660, 840 ], "parameters": { "url": "=https:\/\/api.brightdata.com\/datasets\/v3\/progress\/{{ $json.snapshot_id }}", "options": [], "sendHeaders": true, "headerParameters": { "parameters": [ { "name": "Authorization", "value": "Bearer " } ] } }, "typeVersion": 4.2 }, { "id": "d568403b-c323-4798-b7e5-e4a89dfe7830", "name": "IF-Checking_Status_API_Call", "type": "n8n-nodes-base.if", "position": [ 3860, 900 ], "parameters": { "options": [], "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "7932282b-71bb-4bbb-ab73-4978e554de7e", "operator": { "name": "filter.operator.equals", "type": "string", "operation": "equals" }, "leftValue": "={{ $json.status }}", "rightValue": "running" } ] } }, "typeVersion": 2.2 }, { "id": "b44b5f4b-8aef-4ea3-bbd7-1e72548dda64", "name": "Google Sheets - Update Row with data From API", "type": "n8n-nodes-base.googleSheets", "position": [ 4500, 940 ], "parameters": { "columns": { "value": { "city": "={{ $json.city }}", "name": "={{ $json.name }}", "about": "={{ $json.about }}", "row_number": "={{ $('Loop Over Items- All Prospects').item.json.row_number }}", "country_code": "={{ $json.country_code }}", "Linkedin_URL_Person": "={{ $json.input.url }}", "current_company.name": "={{ $json.current_company.name }}" }, "schema": [ { "id": "Linkedin_URL_Person", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Linkedin_URL_Person", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "city", "type": "string", "display": true, "removed": false, "required": false, "displayName": "city", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "country_code", "type": "string", "display": true, "removed": false, "required": false, "displayName": "country_code", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Position", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Position", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "about", "type": "string", "display": true, "removed": false, "required": false, "displayName": "about", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "current_company.name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "current_company.name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Post 1", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Post 1", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Post 2", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Post 2", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Post 3", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Post 3", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Ice Breaker 1", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Ice Breaker 1", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Ice Breaker 2", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Ice Breaker 2", "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": "defineBelow", "matchingColumns": [ "row_number" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": [], "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4\/edit#gid=0", "cachedResultName": "input" }, "documentId": { "__rl": true, "mode": "list", "value": "1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4", "cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4\/edit?usp=drivesdk", "cachedResultName": "NoFluff-N8N-Sheet-Template" } }, "typeVersion": 4.3, "alwaysOutputData": true }, { "id": "081f9e1d-6325-4645-bb0c-368a8ac3be99", "name": "Google Sheets - Update Row with Ice Breaker", "type": "n8n-nodes-base.googleSheets", "position": [ 5400, 1340 ], "parameters": { "columns": { "value": { "row_number": "={{ $('Loop Over Items- All Prospects').item.json.row_number }}", "Ice Breaker 1": "={{ $json.text }}" }, "schema": [ { "id": "Linkedin_URL_Person", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Linkedin_URL_Person", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "name", "type": "string", "display": true, "removed": true, "required": false, "displayName": "name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "city", "type": "string", "display": true, "removed": true, "required": false, "displayName": "city", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "country_code", "type": "string", "display": true, "removed": true, "required": false, "displayName": "country_code", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Position", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Position", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "about", "type": "string", "display": true, "removed": true, "required": false, "displayName": "about", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "current_company.name", "type": "string", "display": true, "removed": true, "required": false, "displayName": "current_company.name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Post 1", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Post 1", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Post 2", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Post 2", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Post 3", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Post 3", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Ice Breaker 1", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Ice Breaker 1", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Ice Breaker 2", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Ice Breaker 2", "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": "defineBelow", "matchingColumns": [ "row_number" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": [], "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4\/edit#gid=0", "cachedResultName": "input" }, "documentId": { "__rl": true, "mode": "list", "value": "1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4", "cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1_jbr5zBllTy_pGbogfGSvyv1_0a77I8tU-Ai7BjTAw4\/edit?usp=drivesdk", "cachedResultName": "NoFluff-N8N-Sheet-Template" } }, "typeVersion": 4.3, "alwaysOutputData": true }, { "id": "7709c869-5283-4760-b929-fde27167f040", "name": "Run Workflow on a certain Schedule", "type": "n8n-nodes-base.scheduleTrigger", "position": [ 2260, 1000 ], "parameters": { "rule": { "interval": [ [] ] } }, "typeVersion": 1.2 }, { "id": "84e08531-b548-43f2-a17a-b2809f833d32", "name": "Loop Over Items- All Prospects", "type": "n8n-nodes-base.splitInBatches", "position": [ 2980, 720 ], "parameters": { "options": [] }, "typeVersion": 3 } ], "pinData": [], "connections": { "Get rows to enrich": { "main": [ [ { "node": "Adjust_input_for_loop", "type": "main", "index": 0 } ] ] }, "Anthropic Chat Model": { "ai_languageModel": [ [ { "node": "Basic LLM Chain- Ice Breaker", "type": "ai_languageModel", "index": 0 } ] ] }, "Adjust_input_for_loop": { "main": [ [ { "node": "Loop Over Items- All Prospects", "type": "main", "index": 0 } ] ] }, "BrightData_Get_Linkedin": { "main": [ [ { "node": "Google Sheets - Update Row with data From API", "type": "main", "index": 0 } ] ] }, "Wait_For_API_Call_Results": { "main": [ [ { "node": "API_Call_Snapshot_Progress", "type": "main", "index": 0 } ] ] }, "API_Call_Snapshot_Progress": { "main": [ [ { "node": "IF-Checking_Status_API_Call", "type": "main", "index": 0 } ] ] }, "IF-Checking_Status_API_Call": { "main": [ [ { "node": "Wait_For_API_Call_Results", "type": "main", "index": 0 } ], [ { "node": "BrightData_Get_Linkedin", "type": "main", "index": 0 } ] ] }, "Basic LLM Chain- Ice Breaker": { "main": [ [ { "node": "Google Sheets - Update Row with Ice Breaker", "type": "main", "index": 0 } ] ] }, "When clicking \"Test workflow\"": { "main": [ [ { "node": "Get rows to enrich", "type": "main", "index": 0 } ] ] }, "Loop Over Items- All Prospects": { "main": [ [], [ { "node": "HTTP_Request_Post_Request_BrightData", "type": "main", "index": 0 } ] ] }, "Run Workflow on a certain Schedule": { "main": [ [ { "node": "Get rows to enrich", "type": "main", "index": 0 } ] ] }, "HTTP_Request_Post_Request_BrightData": { "main": [ [ { "node": "Wait_For_API_Call_Results", "type": "main", "index": 0 } ] ] }, "Google Sheets - Update Row with Ice Breaker": { "main": [ [ { "node": "Loop Over Items- All Prospects", "type": "main", "index": 0 } ] ] }, "Google Sheets - Update Row with data From API": { "main": [ [ { "node": "Basic LLM Chain- Ice Breaker", "type": "main", "index": 0 } ] ] } } }