丰富存储在Google表格中的LinkedIn个人资料URL
中级
这是一个Sales, Marketing领域的自动化工作流，包含 11 个节点。主要使用 If, Set, Merge, HttpRequest, GoogleSheets 等节点。 丰富存储在Google表格中的LinkedIn个人资料URL信息
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "21754f977ce20b07e6fe64be3fbc663f6e6f730423d6e46c6cd2bf5b5e70a383"
},
"nodes": [
{
"id": "49a3829e-3127-4761-8ac0-edaa6d0224c2",
"name": "HTTP请求 - 使用Prospeo.io LinkedIn邮箱查找API1",
"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": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
3760,
1140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f2b8a1b8-13b6-4de3-9cde-336494bf31dc",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
3140,
940
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "28b1d9c4-c89e-460d-8a5b-0fea42d2d1d8",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
3660,
460
],
"parameters": {
"color": 4,
"width": 468.54622634118857,
"height": 380.67540639666913,
"content": "- 使用了以下API："
},
"typeVersion": 1
},
{
"id": "d8edc9fa-3012-46ab-9ed2-473f55213e78",
"name": "条件检查",
"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": "字段编辑",
"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": "数据合并",
"type": "n8n-nodes-base.merge",
"position": [
3860,
900
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1
},
{
"id": "92a9861d-9e42-4fe2-84a7-03b3b0dbb1b0",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
2300,
520
],
"parameters": {
"color": 5,
"width": 803.4846614963799,
"height": 938.2393052135303,
"content": ""
},
"typeVersion": 1
},
{
"id": "644f38d3-ccf0-4ce3-b759-e129e1074512",
"name": "便签2",
"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": "Field Editing",
"type": "main",
"index": 0
}
]
]
},
"Field Editing": {
"main": [
[
{
"node": "Update the sheet with information",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get links from Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Conditional Check": {
"main": [
[
{
"node": "Data Merge",
"type": "main",
"index": 1
},
{
"node": "HTTP Request - Utilize Prospeo.io LinkedIn Email Finder API1",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Get links from Google Sheet": {
"main": [
[
{
"node": "Conditional Check",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request - Utilize Prospeo.io LinkedIn Email Finder API1": {
"main": [
[
{
"node": "Data Merge",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 销售, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 OpenAI、Google Sheets、Jina AI 和 Slack 的 AI 驱动信息监控
基于AI的信息监控，集成OpenAI、Google Sheets、Jina AI和Slack
If
Set
Code
+10
31 节点Dataki
销售
Overpass 潜在客户生成系统
使用 OpenStreetMap 数据生成商业线索并保存到 Google Sheets
If
Set
Code
+12
27 节点Akram Kadri
销售
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
Smartlead 至 HubSpot 性能分析
Smartlead 至 HubSpot 性能分析
If
Set
Code
+8
23 节点victor de coster
销售
使用Bright Data和LLMs自动化大规模超个性化外联
通过Bright Data和大语言模型实现大规模超个性化外联自动化
If
Set
Wait
+8
21 节点Yaron Been
销售
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
If
Set
Sort
+15
44 节点PollupAI
销售
工作流信息
难度等级
中级
节点数量11
分类2
节点类型8
作者
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.
外部链接
在 n8n.io 查看 →
分享此工作流