Anreicherung von LinkedIn-Profil-URLs, die in Google Tabellen gespeichert sind
Fortgeschritten
Dies ist ein Sales, Marketing-Bereich Automatisierungsworkflow mit 11 Nodes. Hauptsächlich werden If, Set, Merge, HttpRequest, GoogleSheets und andere Nodes verwendet. Anreichung von LinkedIn-Profil-URL-Informationen, die in Google Sheets gespeichert sind
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (11)
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"meta": {
"instanceId": "21754f977ce20b07e6fe64be3fbc663f6e6f730423d6e46c6cd2bf5b5e70a383"
},
"nodes": [
{
"id": "49a3829e-3127-4761-8ac0-edaa6d0224c2",
"name": "HTTP-Anfrage - Prospeo.io LinkedIn Email Finder API1 nutzen",
"type": "n8n-nodes-base.httpRequest",
"position": [
3820,
680
],
"parameters": {
"url": "https://api.prospeo.io/linkedin-email-finder",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $json['Linkden URL'] }}"
},
{
"name": "id",
"value": "={{ $json.ID }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-KEY",
"value": "43b7e4f5c6558ccaa539e0e5f5778f09"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "705aef1b-5e45-4fe8-b1fd-5ebb5d461dd5",
"name": "Keine Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"position": [
3760,
1140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f2b8a1b8-13b6-4de3-9cde-336494bf31dc",
"name": "Zeitplan-Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
3140,
940
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "28b1d9c4-c89e-460d-8a5b-0fea42d2d1d8",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
3660,
460
],
"parameters": {
"color": 4,
"width": 468.54622634118857,
"height": 380.67540639666913,
"content": "- Utilized the following API: \n - [Prospeo.io LinkedIn Email Finder API](https://prospeo.io/api/linkedin-email-finder)\n\n- **Benefit:**\n - The benefit of this API is to provide an efficient way to find email addresses of users on LinkedIn, aiding in updating and enriching data more accurately and comprehensively in Google Sheets or any other system used in the workflow.\n"
},
"typeVersion": 1
},
{
"id": "d8edc9fa-3012-46ab-9ed2-473f55213e78",
"name": "Conditional Check",
"type": "n8n-nodes-base.if",
"position": [
3520,
940
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "2b355bc4-0ef4-415a-a437-d8ed6538c1e3",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Name }}",
"rightValue": ""
},
{
"id": "1757a7d7-ce91-4df1-b54d-c9285f88e3ee",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Gender }}",
"rightValue": ""
},
{
"id": "78089c18-e9d6-40e5-8d0c-e2b96c1f1348",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json['Job Title'] }}",
"rightValue": ""
},
{
"id": "0ee10296-113d-4467-92d7-368111426cf5",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Summery }}",
"rightValue": ""
},
{
"id": "2ec7486d-e753-4c87-a6df-10056c7ee4b2",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json['Linkden URL'] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "bdf82dbf-7b6b-4d42-9a6a-34d5cfb691ad",
"name": "Field Editing",
"type": "n8n-nodes-base.set",
"position": [
4100,
900
],
"parameters": {
"fields": {
"values": [
{
"name": "Name",
"stringValue": "={{ $json.response.full_name }}"
},
{
"name": "Gender",
"stringValue": "={{ $json.response.gender }}"
},
{
"name": "Email",
"stringValue": "={{ $json.response.email.email }}"
},
{
"name": "Summary",
"stringValue": "={{ $json.response.summary}}"
},
{
"name": "Education",
"stringValue": "={{ $json.response.education[0].school.name }}"
},
{
"name": "Skills",
"stringValue": "={{ $json.response.skills }}"
},
{
"name": "Picture",
"stringValue": "={{ $json.response.picture }}"
},
{
"name": "Job Title",
"stringValue": "={{ $json.response.job_title }}"
},
{
"name": "Location",
"stringValue": "={{ $json.response.location.raw }}"
},
{
"name": "Linkden link",
"stringValue": "={{ $json.response.linkedin }}"
},
{
"name": "ID",
"stringValue": "={{ $json.ID }}"
}
]
},
"include": "selected",
"options": {}
},
"typeVersion": 3.2
},
{
"id": "897734e2-5d05-4480-a24b-e4b3ae44dce6",
"name": "Data Zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
3860,
900
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1
},
{
"id": "92a9861d-9e42-4fe2-84a7-03b3b0dbb1b0",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
2300,
520
],
"parameters": {
"color": 5,
"width": 803.4846614963799,
"height": 938.2393052135303,
"content": "\n- **Schedule Trigger:**\n - Description: This node triggers the workflow based on a defined schedule interval, in this case, based on minutes.\n - Documentation: [Schedule Trigger Node](https://docs.n8n.io/nodes/n8n-nodes-base.scheduleTrigger)\n\n- **Google Sheets Read:**\n - Description: This node reads data from a Google Sheets document and sheet based on the provided document ID and sheet name.\n - Documentation: [Google Sheets Node](https://docs.n8n.io/nodes/n8n-nodes-base.googleSheets)\n\n- **Conditional Check:**\n - Description: This node checks multiple conditions based on the input data and performs further actions based on the conditions.\n - Documentation: [Conditional Node](https://docs.n8n.io/nodes/n8n-nodes-base.if)\n\n- **HTTP Request:**\n - Description: This node sends an HTTP POST request to a specified URL with the provided headers and body parameters.\n - Documentation: [HTTP Request Node](https://docs.n8n.io/nodes/n8n-nodes-base.httpRequest)\n\n- **No Operation, do nothing:**\n - Description: This node does not perform any operation and is used as a placeholder.\n - Documentation: [No Operation Node](https://docs.n8n.io/nodes/n8n-nodes-base.noOp)\n\n\n- **Data Merge:**\n - Description: This node merges data based on the specified mode and combination settings to combine multiple fields into a single object.\n - Documentation: [Merge Node](https://docs.n8n.io/nodes/n8n-nodes-base.merge)\n\n- **Field Editing:**\n - Description: This node edits fields by setting specific values for each field based on the provided input data.\n - Documentation: [Set Node](https://docs.n8n.io/nodes/n8n-nodes-base.set)\n\n\n- **Google Sheets Update:**\n - Description: This node updates data in a Google Sheets document and sheet based on the specified columns and values.\n - Documentation: [Google Sheets Node](https://docs.n8n.io/nodes/n8n-nodes-base.googleSheets)\n\n"
},
"typeVersion": 1
},
{
"id": "644f38d3-ccf0-4ce3-b759-e129e1074512",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2260,
240
],
"parameters": {
"width": 2292.975584892399,
"height": 1214.0709576942727,
"content": "## Find contact information for linkedin profile URLs stored in a Google Sheet\n**Video link.** [Guide](https://www.canva.com/design/DAF9a_UBxWY/xSSlSUzRdxCPtfgx9RzGSg/watch?utm_content=DAF9a_UBxWY&utm_campaign=designshare&utm_medium=link&utm_source=editor)"
},
"typeVersion": 1
},
{
"id": "8ddaddad-b976-46c5-b8a1-e49ecb493e87",
"name": "Get links from Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3340,
940
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ochnGSCy8V5Mz-nr51dBmugqR50m62K7d6pvbwOHewo/edit#gid=0",
"cachedResultName": "الورقة1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1ochnGSCy8V5Mz-nr51dBmugqR50m62K7d6pvbwOHewo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ochnGSCy8V5Mz-nr51dBmugqR50m62K7d6pvbwOHewo/edit?usp=drivesdk",
"cachedResultName": "linkden URls"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "L5CnisK8R3BgVGcO",
"name": "Omar sheet"
}
},
"typeVersion": 4.2
},
{
"id": "0923a13d-1097-432d-b22e-375fec9f383e",
"name": "Update the sheet with information",
"type": "n8n-nodes-base.googleSheets",
"position": [
4320,
900
],
"parameters": {
"columns": {
"value": {
"ID": "={{ $json.ID }}",
"Name": "={{ $json.Name }}",
"Email": "={{ $json.Email }}",
"Gender": "={{ $json.Gender }}",
"Skills": "={{ $json.Skills }}",
"Picture": "={{ $json.Picture }}",
"Summery": "={{ $json.Summary }}",
"Location": "={{ $json.Location }}",
"Education": "={{ $json.Education }}",
"Job Title": "={{ $json['Job Title'] }}"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkden URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Linkden URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Gender",
"type": "string",
"display": true,
"required": false,
"displayName": "Gender",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Education",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summery",
"type": "string",
"display": true,
"required": false,
"displayName": "Summery",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skills",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Picture",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Picture",
"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": [
"ID"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ochnGSCy8V5Mz-nr51dBmugqR50m62K7d6pvbwOHewo/edit#gid=0",
"cachedResultName": "الورقة1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1ochnGSCy8V5Mz-nr51dBmugqR50m62K7d6pvbwOHewo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ochnGSCy8V5Mz-nr51dBmugqR50m62K7d6pvbwOHewo/edit?usp=drivesdk",
"cachedResultName": "linkden URls"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "L5CnisK8R3BgVGcO",
"name": "Omar sheet"
}
},
"typeVersion": 4.2
}
],
"pinData": {},
"connections": {
"Data Merge": {
"main": [
[
{
"node": "bdf82dbf-7b6b-4d42-9a6a-34d5cfb691ad",
"type": "main",
"index": 0
}
]
]
},
"bdf82dbf-7b6b-4d42-9a6a-34d5cfb691ad": {
"main": [
[
{
"node": "0923a13d-1097-432d-b22e-375fec9f383e",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "8ddaddad-b976-46c5-b8a1-e49ecb493e87",
"type": "main",
"index": 0
}
]
]
},
"d8edc9fa-3012-46ab-9ed2-473f55213e78": {
"main": [
[
{
"node": "Data Merge",
"type": "main",
"index": 1
},
{
"node": "HTTP Request - Prospeo.io LinkedIn Email Finder API1 nutzen",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"8ddaddad-b976-46c5-b8a1-e49ecb493e87": {
"main": [
[
{
"node": "d8edc9fa-3012-46ab-9ed2-473f55213e78",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request - Prospeo.io LinkedIn Email Finder API1 nutzen": {
"main": [
[
{
"node": "Data Merge",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Fortgeschritten - Vertrieb, Marketing
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
KI-gesteuerte Informationsüberwachung mit OpenAI, Google Sheets, Jina AI und Slack
Eine KI-gesteuerte Informationsüberwachung, die OpenAI, Google Sheets, Jina AI und Slack integriert
If
Set
Code
+
If
Set
Code
31 NodesDataki
Vertrieb
Overpass Lead-Generierungssystem
Mit OpenStreetMap-Daten Geschäftskontakte generieren und in Google Sheets speichern
If
Set
Code
+
If
Set
Code
27 NodesAkram Kadri
Vertrieb
Massenindividualisierte Outreach-Automatisierung mit Bright Data und LLMs
Großskalige Hyper-Personalisierung und Outreach-Automatisierung durch Bright Data und Large Language Models
If
Set
Wait
+
If
Set
Wait
21 NodesYaron Been
Vertrieb
Automatisierung von LinkedIn-Anfragen und Einstiegsnachrichten mit Browserflow und Google Sheets
Automatisierte LinkedIn-Anfragen und Eisbrecher-Nachrichten mit Browserflow und Google Sheets
If
Set
Sort
+
If
Set
Sort
44 NodesPollupAI
Vertrieb
Lead-Forscher LinkedIn
Automatisierte Lead-Recherche - von LinkedIn zu sendbaren Berichten
If
Set
Wait
+
If
Set
Wait
36 NodesLukaszB
Vertrieb
LinkedIn Lead-Scraping mit Datenanreicherung für Kopien
Generieren und bereichern Sie LinkedIn-Leads mit Apollo.io, LinkedIn API, Mail.so und GPT-3.5
If
Set
Code
+
If
Set
Code
53 NodesJoseph
Vertrieb
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes11
Kategorie2
Node-Typen8
Autor
AlQaisi
@omarI'm specialize in automation and AI, developing innovative solutions to enhance efficiency and drive innovation. With expertise in advanced technologies, I create predictive models for optimal resource allocation. Collaborating with teams, I implement customized automation solutions. Passionate about shaping the future of intelligent automation through digital transformation.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen