Centralisez toutes les données environnementales, sociales et de gouvernance, générez des rapports conformes et anticipez les évolutions réglementaires.
Centralisez toutes les données environnementales, sociales et de gouvernance, générez des rapports conformes et anticipez les évolutions réglementaires.
{
"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 & GUIDELINESn=======================================nName:n LinkedIn Enrichment & Ice Breaker GeneratornnPurpose:n Automate the process of enriching LinkedIn profiles using Bright Data,n generate personalized ice breakers with an LLM, and update Google Sheets.nnTools Needed:n - n8n Nodes:n u2022 Manual Trigger or Schedule Triggern u2022 Setn u2022 SplitInBatchesn u2022 HTTP Requestn u2022 Ifn u2022 Waitn u2022 Google Sheetsn u2022 LangChain LLM (Claude via Anthropic)n - External Services:n u2022 Bright Data (Dataset API)n u2022 Anthropic Claude (Haiku)n u2022 Google Sheets APInnAPI Keys & Authentication Required:n u2022 Bright Data API Keyn u2192 Used in HTTP Request headers as:n `Authorization: Bearer YOUR_BRIGHTDATA_API_KEY`n u2022 Google Sheets OAuth2 Credentialsn u2192 Connects n8n to your Google account for reading/writing to Sheets.n u2022 Anthropic API Keyn u2192 Used for generating ice breakers via Claude models.n u2192 Must be set in the Anthropic credential section in n8n.nnGeneral Guidelines:n u2022 Use descriptive and consistent naming for all nodes.n u2022 Add retry limits to polling loops to avoid infinite cycles.n u2022 Ensure each LinkedIn URL maps to a unique `row_number`.n u2022 Obfuscate any keys before sharing the workflow publicly.nnThings to be Aware Of:n u2022 Bright Data may require some delay (via Wait node) before snapshot is ready.n u2022 Retry logic should not exceed API rate limits.n u2022 If snapshot fails or times out, ensure fallback logging is in place.n u2022 Claude model IDs and prompt formats may change u2014 validate before updates.nnAdditional Notes:n u2022 Make a copy of the Google Sheet template before use.n u2022 Replace placeholders in `Authorization` headers and credentials section.n u2022 Use test data first to avoid exhausting API quotas during setup.nn=======================================nnThis 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 schedulen"
},
"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. nnYou can use my template to get started faster:nn1. [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 Sheetsn3. Add the URL to this node and the node **"Google Sheets - Update Row with data"**nnn"
},
"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 ASSISTANCEn=======================================nFor any questions or support, please contact:n Yaron@nofluff.onlinennExplore more tips and tutorials here:n - YouTube: https://www.youtube.com/@YaronBeen/videosn - 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 BREAKERn"
},
"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 }}nnMake it 4 lines maximum. Focus more on his recent post, not the about. Just to make it feel personalized yet respectful and not creepy.nnWRITE 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
}
]
]
}
}
}