使用AI从Google Sheets自动查找社交媒体资料
中级
这是一个Lead Generation, AI Summarization领域的自动化工作流，包含 13 个节点。主要使用 Limit, Filter, GoogleSheets, ExecuteWorkflow, ScheduleTrigger 等节点。 使用Gemini AI从Google Sheets自动化多平台社交媒体查找
前置要求
- •Google Sheets API 凭证
使用的节点 (13)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "dZP8oRCxoLytRJDF",
"meta": {
"instanceId": "26bd595441827fb23edb0643d6d240e79b0b8993d278e90950f16e18bf9e3c4a"
},
"name": "使用AI从Google Sheets自动查找社交媒体资料",
"tags": [],
"nodes": [
{
"id": "f1a23673-c623-4406-9372-904ab0b8fbdd",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-192,
-32
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "89d5752d-ac86-4644-ad41-40600bb919ac",
"name": "OpenRouter 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
976,
160
],
"parameters": {
"model": "google/gemini-2.5-flash",
"options": {}
},
"credentials": {
"openRouterApi": {
"id": "QqgKARn52qQiKICN",
"name": "OpenRouter account"
}
},
"typeVersion": 1
},
{
"id": "42035af6-2e15-424a-86b6-9c536476b52d",
"name": "获取所有联系人",
"type": "n8n-nodes-base.googleSheets",
"position": [
32,
-32
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit?usp=drivesdk",
"cachedResultName": "Contact List Template"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "vWEw7oberM64Wqxn",
"name": "sam@openpaws.ai Google Sheets"
}
},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "4ac06442-ecd0-465d-ba9c-4830198b1783",
"name": "过滤已处理联系人",
"type": "n8n-nodes-base.filter",
"position": [
256,
-32
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "2fe5592c-8923-4409-b32a-b591acf7f85f",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ $json['Analysed?'] }}",
"rightValue": ""
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "8b250c01-9509-4c12-9d2a-d7bc68f9c06c",
"name": "限制为1个",
"type": "n8n-nodes-base.limit",
"position": [
464,
-32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "22d033ce-6163-4618-a4f7-18d346bc842b",
"name": "查找社交媒体链接",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
672,
-32
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "k053fXGjIF7dUIQZ",
"cachedResultName": "♻️ 🧩 📚 General Research Agent"
},
"workflowInputs": {
"value": {
"chatInput": "=Find the social media profile URLs for this individual or company across all major platforms. Return the results in a structured JSON format with null values for any platforms where the profile couldn't be found. Include the following platforms:\n\n1. Twitter/X\n2. LinkedIn\n3. Facebook\n4. Instagram\n5. YouTube\n6. TikTok\n7. Reddit\n8. Mastodon\n9. Truth Social\n10. Threads\n11. Bluesky\n12. Pinterest\n13. Snapchat\n14. Telegram\n15. WhatsApp Business\n16. Medium\n17. GitHub\n18. Twitch\n\nFor each platform, provide either:\n- The direct URL to the verified profile\n- Null if no profile exists or couldn't be found\n\nFormat the response as a JSON object with platform names as keys:\n\n{\n \"twitter\": \"https://twitter.com/example\",\n \"linkedin\": \"https://linkedin.com/in/example\",\n \"facebook\": \"https://facebook.com/example\",\n \"instagram\": \"https://instagram.com/example\",\n \"youtube\": \"https://youtube.com/example\",\n \"tiktok\": \"https://tiktok.com/@example\",\n \"reddit\": \"https://reddit.com/user/example\",\n \"mastodon\": \"https://mastodon.social/@example\",\n \"truth_social\": \"https://truthsocial.com/@example\",\n \"threads\": \"https://threads.net/@example\",\n \"bluesky\": \"https://bsky.app/profile/example.bsky.social\",\n \"pinterest\": \"https://pinterest.com/example\",\n \"snapchat\": \"https://snapchat.com/add/example\",\n \"telegram\": \"https://t.me/example\",\n \"whatsapp_business\": \"https://wa.me/example\",\n \"medium\": \"https://medium.com/@example\",\n \"github\": \"https://github.com/example\",\n \"twitch\": \"https://twitch.tv/example\"\n}\n\nWhen searching:\n\n Prioritize verified accounts when available\n Check common variations of the name (first name, last name, initials, nicknames)\n If multiple potential matches exist, choose the most likely one based on context\n\nAdditional instructions:\n\n If the contact is a business or organization, look for official company pages\n For public figures, check both personal and official accounts\n For researchers or academics, check ResearchGate and Academia.edu\n For developers, check Stack Overflow and Dev.to\n For journalists, check Substack and other publishing platforms\n\n# INPUT (this is the individual or company whose social media links you are looking for)\n\n{{ JSON.stringify($json) }}",
"sessionId": "={{ (Math.random().toString(36).substring(2) + Date.now().toString(36)) }}"
},
"schema": [
{
"id": "chatInput",
"type": "string",
"display": true,
"required": false,
"displayName": "chatInput",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sessionId",
"type": "string",
"display": true,
"required": false,
"displayName": "sessionId",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "e244c667-8205-48cd-9821-a6b1519b6902",
"name": "结构化响应",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
896,
-32
],
"parameters": {
"text": "={{ $json.output }}",
"options": {},
"schemaType": "manual",
"inputSchema": "{\n \"$schema\": \"http://json-schema.org/draft-07/schema#\",\n \"title\": \"Social Media Profiles Schema\",\n \"description\": \"A schema for capturing social media profile URLs for any contact\",\n \"type\": \"object\",\n \"required\": [\n \"twitter\",\n \"linkedin\",\n \"facebook\",\n \"instagram\",\n \"youtube\",\n \"tiktok\",\n \"reddit\",\n \"mastodon\",\n \"truth_social\",\n \"threads\",\n \"bluesky\",\n \"pinterest\",\n \"snapchat\",\n \"telegram\",\n \"whatsapp_business\",\n \"medium\",\n \"github\",\n \"twitch\"\n ],\n \"properties\": {\n \"twitter\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Twitter/X profile. Must be null if no profile exists.\"\n },\n \"linkedin\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to LinkedIn profile. Must be null if no profile exists.\"\n },\n \"facebook\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Facebook profile. Must be null if no profile exists.\"\n },\n \"instagram\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Instagram profile. Must be null if no profile exists.\"\n },\n \"youtube\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to YouTube channel. Must be null if no profile exists.\"\n },\n \"tiktok\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to TikTok profile. Must be null if no profile exists.\"\n },\n \"reddit\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Reddit profile. Must be null if no profile exists.\"\n },\n \"mastodon\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Mastodon profile. Must be null if no profile exists.\"\n },\n \"truth_social\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Truth Social profile. Must be null if no profile exists.\"\n },\n \"threads\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Threads profile. Must be null if no profile exists.\"\n },\n \"bluesky\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Bluesky profile. Must be null if no profile exists.\"\n },\n \"pinterest\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Pinterest profile. Must be null if no profile exists.\"\n },\n \"snapchat\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Snapchat profile. Must be null if no profile exists.\"\n },\n \"telegram\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Telegram profile. Must be null if no profile exists.\"\n },\n \"whatsapp_business\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to WhatsApp Business profile. Must be null if no profile exists.\"\n },\n \"medium\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Medium profile. Must be null if no profile exists.\"\n },\n \"github\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to GitHub profile. Must be null if no profile exists.\"\n },\n \"twitch\": {\n \"type\": [\"string\", \"null\"],\n \"format\": \"uri\",\n \"description\": \"URL to Twitch profile. Must be null if no profile exists.\"\n }\n },\n \"additionalProperties\": false,\n \"examples\": [\n {\n \"twitter\": \"https://twitter.com/example\",\n \"linkedin\": null,\n \"facebook\": \"https://facebook.com/example\",\n \"instagram\": null,\n \"youtube\": \"https://youtube.com/example\",\n \"tiktok\": null,\n \"reddit\": \"https://reddit.com/user/example\",\n \"mastodon\": null,\n \"truth_social\": null,\n \"threads\": null,\n \"bluesky\": null,\n \"pinterest\": null,\n \"snapchat\": null,\n \"telegram\": null,\n \"whatsapp_business\": null,\n \"medium\": \"https://medium.com/@example\",\n \"github\": null,\n \"twitch\": null\n },\n {\n \"twitter\": null,\n \"linkedin\": \"https://linkedin.com/in/example\",\n \"facebook\": null,\n \"instagram\": null,\n \"youtube\": null,\n \"tiktok\": null,\n \"reddit\": null,\n \"mastodon\": null,\n \"truth_social\": null,\n \"threads\": null,\n \"bluesky\": null,\n \"pinterest\": null,\n \"snapchat\": null,\n \"telegram\": null,\n \"whatsapp_business\": null,\n \"medium\": null,\n \"github\": \"https://github.com/example\",\n \"twitch\": null\n }\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "22503521-d238-4912-bd9f-3f50c2c1b933",
"name": "更新联系人",
"type": "n8n-nodes-base.googleSheets",
"position": [
1264,
-32
],
"parameters": {
"columns": {
"value": {
"github": "={{ $json.output.github }}",
"medium": "={{ $json.output.medium }}",
"reddit": "={{ $json.output.reddit }}",
"tiktok": "={{ $json.output.tiktok }}",
"twitch": "={{ $json.output.twitch }}",
"bluesky": "={{ $json.output.bluesky }}",
"threads": "={{ $json.output.threads }}",
"twitter": "={{ $json.output.twitter }}",
"youtube": "={{ $json.output.youtube }}",
"facebook": "={{ $json.output.facebook }}",
"linkedin": "={{ $json.output.linkedin }}",
"mastodon": "={{ $json.output.mastodon }}",
"snapchat": "={{ $json.output.snapchat }}",
"telegram": "={{ $json.output.telegram }}",
"instagram": "={{ $json.output.instagram }}",
"pinterest": "={{ $json.output.pinterest }}",
"row_number": "={{ $('Limit to 1').item.json.row_number }}",
"truth_social": "={{ $json.output.truth_social }}",
"whatsapp_business": "={{ $json.output.whatsapp_business }}"
},
"schema": [
{
"id": "Analysed?",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Analysed?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitter",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "twitter",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "facebook",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "youtube",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "youtube",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tiktok",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "tiktok",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reddit",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "reddit",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "mastodon",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "mastodon",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "truth_social",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "truth_social",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "threads",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "threads",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "bluesky",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "bluesky",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pinterest",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pinterest",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "snapchat",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "snapchat",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "telegram",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "telegram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "whatsapp_business",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "whatsapp_business",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "medium",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "medium",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "github",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "github",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitch",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "twitch",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PASTE ALL NAMES & KNOWN CONTACT DETAILS HERE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "PASTE ALL NAMES & KNOWN CONTACT DETAILS HERE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"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/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nZ8a7MCU-Ku99cRsBkyer-zUPUb-QcMBzovzU3E-IH4/edit?usp=drivesdk",
"cachedResultName": "Contact List Template"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "vWEw7oberM64Wqxn",
"name": "sam@openpaws.ai Google Sheets"
}
},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "13d7a754-aa74-4975-a489-fd1e4e307525",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-752,
-496
],
"parameters": {
"width": 448,
"height": 416,
"content": "# 🧭 工作流概览"
},
"typeVersion": 1
},
{
"id": "24536b2b-f0ac-4897-afa4-9a05bfb663a8",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-272,
-496
],
"parameters": {
"width": 624,
"height": 416,
"content": "# 📄 Google表格设置说明"
},
"typeVersion": 1
},
{
"id": "644a7f23-8c59-45e3-8a92-6f112cad326f",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
384,
-496
],
"parameters": {
"width": 448,
"height": 416,
"content": "# 🧠 子工作流：查找社交媒体链接"
},
"typeVersion": 1
},
{
"id": "7033615b-efdc-4d34-b6a3-063d9d3ef14d",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
864,
-496
],
"parameters": {
"width": 336,
"height": 416,
"content": "# 🧱 结构化和验证响应"
},
"typeVersion": 1
},
{
"id": "474fd9e7-36c7-4502-9e6a-f88a91f56028",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1232,
-496
],
"parameters": {
"width": 320,
"height": 416,
"content": "# 📝 Google表格：更新联系人"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1a5e2061-4cf6-493b-8ee9-8f3e4aa3c71d",
"connections": {
"Limit to 1": {
"main": [
[
{
"node": "Find Social Media Links",
"type": "main",
"index": 0
}
]
]
},
"Get All Contacts": {
"main": [
[
{
"node": "Filter Out Processed Contacts",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get All Contacts",
"type": "main",
"index": 0
}
]
]
},
"Structure Response": {
"main": [
[
{
"node": "Update Contact",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "Structure Response",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Find Social Media Links": {
"main": [
[
{
"node": "Structure Response",
"type": "main",
"index": 0
}
]
]
},
"Filter Out Processed Contacts": {
"main": [
[
{
"node": "Limit to 1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI驱动的谷歌地图商家数据抓取与表格导出
基于AI的谷歌地图商家数据抓取，支持数据丰富化并导出至表格
If
Code
Wait
+13
25 节点Msaid Mohamed el hadi
潜在客户开发
基于美国众议院法案使用Gemini AI生成周度动物权益行动简报
基于美国众议院法案使用Gemini AI生成周度动物权益行动简报
If
Set
Html
+13
26 节点Open Paws
社交媒体
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
每周动物权益简报
使用Claude AI和Serper的自动化动物权益新闻研究与每周摘要
Set
Email Send
Execute Workflow
+4
11 节点Open Paws
社交媒体
使用AI自动化分析公司可持续性与动物福利
使用OpenRouter AI和多源研究分析公司可持续性与动物福利
Set
Merge
Aggregate
+6
15 节点Open Paws
市场调研
08 - AI驱动的联系人智能分析
使用GPT-4o-mini为Google表格、Airtable和HubSpot分类和丰富联系人信息
Code
Filter
Hubspot
+6
15 节点Avkash Kakdiya
潜在客户开发
工作流信息
难度等级
中级
节点数量13
分类2
节点类型8
作者
Open Paws
@openpawsOpen Paws is a nonprofit building open-source AI tools to accelerate animal advocacy. We create machine learning models and automation workflows trained on real-world campaign data to help end industrial animal exploitation. All tools are free, transparent, and designed for real-world impact.
外部链接
在 n8n.io 查看 →
分享此工作流