Workflow n8n
Automatisation Google Sheets avec n8n : enrichissement de données
Ce workflow n8n a pour objectif d'automatiser l'enrichissement de données dans Google Sheets en utilisant des modèles de langage avancés. Dans un contexte où les entreprises cherchent à optimiser leur gestion de données, ce workflow permet de récupérer des informations pertinentes et de les intégrer directement dans des feuilles de calcul. Parfait pour les équipes marketing et commerciales, il facilite la mise à jour des données clients et prospects.
- Étape 1 : le workflow est déclenché manuellement via un nœud de déclenchement.
- Étape 2 : il utilise un nœud Google Sheets pour récupérer les lignes à enrichir.
- Étape 3 : les données sont ensuite traitées par un modèle de langage (Anthropic Chat Model) pour générer des réponses adaptées.
- Étape 4 : les résultats sont vérifiés via un appel API, et en fonction de la réponse, les données sont mises à jour dans Google Sheets. Ce processus permet non seulement de gagner du temps, mais aussi d'améliorer la qualité des données. En intégrant cette automatisation n8n, les entreprises peuvent réduire les erreurs manuelles et augmenter leur efficacité opérationnelle.
Tags clés :automatisationGoogle Sheetsworkflowenrichissement de donnéesn8n
Catégorie: Manual · Tags: automatisation, Google Sheets, workflow, enrichissement de données, n8n❤ 0
Workflow n8n Google Sheets, enrichissement de données : vue d'ensemble
Schéma des nœuds et connexions de ce workflow n8n, généré à partir du JSON n8n.
Workflow n8n Google Sheets, enrichissement de données : détail des nœuds
Inscris-toi pour voir l'intégralité du workflow
Inscription gratuite
S'inscrire gratuitementBesoin d'aide ?{
"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 <BRIGHT_DATA_API_KEY>"
}
]
}
},
"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 <BRIGHT_DATA_API_KEY>"
}
]
}
},
"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 <Bright_Data_API_KEY>"
}
]
}
},
"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
}
]
]
}
}
}Workflow n8n Google Sheets, enrichissement de données : pour qui est ce workflow ?
Ce workflow s'adresse aux équipes marketing et commerciales des PME et grandes entreprises qui souhaitent automatiser la gestion de leurs données. Un niveau technique intermédiaire est recommandé pour la personnalisation et l'intégration des API.
Workflow n8n Google Sheets, enrichissement de données : problème résolu
Ce workflow résout le problème de la mise à jour manuelle des données dans Google Sheets, qui peut être chronophage et sujette à des erreurs. En automatisant ce processus, les utilisateurs peuvent enrichir leurs données rapidement et avec précision, réduisant ainsi le risque d'erreurs humaines et améliorant la réactivité de leurs équipes face aux besoins des clients.
Workflow n8n Google Sheets, enrichissement de données : étapes du workflow
Étape 1 : Le workflow est déclenché manuellement.
- Étape 1 : Récupération des lignes à enrichir depuis Google Sheets.
- Étape 2 : Traitement des données via le modèle de langage Anthropic.
- Étape 3 : Envoi d'une requête API pour vérifier le statut des données.
- Étape 4 : Mise à jour des lignes dans Google Sheets avec les nouvelles informations.
- Étape 5 : Répétition du processus pour chaque prospect en utilisant un nœud de boucle.
Workflow n8n Google Sheets, enrichissement de données : guide de personnalisation
Pour personnaliser ce workflow, il est possible de modifier l'ID du document Google Sheets et le nom de la feuille dans les nœuds correspondants. Vous pouvez également ajuster les paramètres du modèle de langage pour affiner les réponses générées. Si vous souhaitez intégrer d'autres API, il suffit d'ajouter des nœuds HTTP Request et de configurer les paramètres d'envoi. Assurez-vous de sécuriser vos appels API avec des clés d'authentification appropriées.