使用Google Gemini和Decode总结提取Glassdoor公司信息
中级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 15 个节点。主要使用 Set, Code, Merge, Function, ManualTrigger 等节点。 使用Google Gemini和Decode总结提取Glassdoor公司信息
前置要求
- •Google Gemini API Key
使用的节点 (15)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "in11m3CofWPWeo7h",
"meta": {
"instanceId": "885b4fb4a6a9c2cb5621429a7b972df0d05bb724c20ac7dac7171b62f1c7ef40",
"templateCredsSetupCompleted": true
},
"name": "使用Google Gemini和Decode总结提取Glassdoor公司信息",
"tags": [
{
"id": "Kujft2FOjmOVQAmJ",
"name": "Engineering",
"createdAt": "2025-04-09T01:31:00.558Z",
"updatedAt": "2025-04-09T01:31:00.558Z"
},
{
"id": "ddPkw7Hg5dZhQu2w",
"name": "AI",
"createdAt": "2025-04-13T05:38:08.053Z",
"updatedAt": "2025-04-13T05:38:08.053Z"
},
{
"id": "rKOa98eAi3IETrLu",
"name": "HR",
"createdAt": "2025-04-13T04:59:30.580Z",
"updatedAt": "2025-04-13T04:59:30.580Z"
}
],
"nodes": [
{
"id": "e17438ec-00e7-4f0a-b57b-9597ffbae1ad",
"name": "点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-560,
128
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ad1c0eee-3b2d-4e15-8d4c-7756adea4fc2",
"name": "设置输入字段",
"type": "n8n-nodes-base.set",
"position": [
-336,
128
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "0bd5c0c2-dc62-466a-941c-98fdb0404d6c",
"name": "company_url",
"type": "string",
"value": "https://www.glassdoor.co.in/Overview/Working-at-Decode-Technologies-EI_IE4772827.11,30.htm"
},
{
"id": "31a57370-3210-4ece-b329-c10a0afc53af",
"name": "geo",
"type": "string",
"value": "India"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "db9ecca5-7fcb-4c0d-b80b-f6675ade9d34",
"name": "Decodo",
"type": "@decodo/n8n-nodes-decodo.decodo",
"position": [
-112,
128
],
"parameters": {
"geo": "={{ $('Set the Input Fields').item.json.geo }}",
"url": "={{ $('Set the Input Fields').item.json.company_url }}"
},
"credentials": {
"decodoApi": {
"id": "7xLvINFuwxDiyBde",
"name": "Decodo Credentials account"
}
},
"retryOnFail": true,
"typeVersion": 1
},
{
"id": "a80fabf3-d506-4896-8efa-71abc8f8fdd3",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
352,
48
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\n \"text\": {\n \"type\": \"string\",\n \"description\": \"Full summarized text including company overview, ratings, and insights\"\n },\n \"overview\": {\n \"type\": \"object\",\n \"properties\": {\n \"companyName\": { \"type\": \"string\" },\n \"rating\": { \"type\": \"number\" },\n \"location\": { \"type\": \"string\" },\n \"size\": { \"type\": \"string\" },\n \"type\": { \"type\": \"string\" },\n \"website\": { \"type\": \"string\" }\n }\n },\n \"keyTakeaways\": {\n \"type\": \"array\",\n \"items\": { \"type\": \"string\" }\n },\n \"ratingsBreakdown\": {\n \"type\": \"object\",\n \"properties\": {\n \"cultureAndValues\": { \"type\": \"number\" },\n \"diversityAndInclusion\": { \"type\": \"number\" },\n \"workLifeBalance\": { \"type\": \"number\" },\n \"seniorManagement\": { \"type\": \"number\" },\n \"compensationAndBenefits\": { \"type\": \"number\" },\n \"careerOpportunities\": { \"type\": \"number\" }\n }\n },\n \"reviewSnippets\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\n \"role\": { \"type\": \"string\" },\n \"pros\": { \"type\": \"array\", \"items\": { \"type\": \"string\" } },\n \"cons\": { \"type\": \"array\", \"items\": { \"type\": \"string\" } }\n }\n }\n },\n \"faq\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\n \"question\": { \"type\": \"string\" },\n \"answer\": { \"type\": \"string\" }\n }\n }\n },\n \"callToAction\": { \"type\": \"string\" }\n },\n \"required\": [\"text\"]\n }\n}\n"
},
"typeVersion": 1.3
},
{
"id": "97034fba-e1f5-43c4-8357-c5300033662c",
"name": "结构化数据提取器",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
208,
-176
],
"parameters": {
"text": "=Analyze and extract structured data\n\n{{ $json.data.results[0].content }}",
"batching": {},
"promptType": "define",
"hasOutputParser": true
},
"executeOnce": false,
"retryOnFail": true,
"typeVersion": 1.7
},
{
"id": "ca125524-bf97-44b2-a3d1-30cc4ab9d865",
"name": "总结器",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
208,
328
],
"parameters": {
"text": "=Summarize the following content {{ $json.data.results[0].content }}",
"options": {},
"schemaType": "manual",
"inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\n\t\t\"detailed_summary\": {\n\t\t\t\"type\": \"string\"\n\t\t}\n\t}\n}"
},
"typeVersion": 1.2
},
{
"id": "95bdc9dd-c788-4650-a87c-5ebd79cfa07a",
"name": "用于总结的Google Gemini聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
280,
552
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "YeO7dHZnuGBVQKVZ",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "24837733-309c-4078-9197-36b4de71f330",
"name": "用于结构化数据提取的Google Gemini聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
192,
48
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "YeO7dHZnuGBVQKVZ",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "2917a190-f43a-4d7b-9a6a-36222e6f39ad",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
672,
96
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "574fbde4-7dc1-4996-b7a7-50138b589b68",
"name": "从磁盘读取/写入文件",
"type": "n8n-nodes-base.readWriteFile",
"position": [
1344,
96
],
"parameters": {
"options": {},
"fileName": "=C:\\\\{{ $json.overview.companyName }}.json",
"operation": "write",
"dataPropertyName": "=data"
},
"typeVersion": 1
},
{
"id": "9140952a-0ba9-4d1e-b89a-5bd2b0a4dc16",
"name": "格式化响应",
"type": "n8n-nodes-base.code",
"position": [
896,
96
],
"parameters": {
"jsCode": "\nreturn $input.first().json.output[0];"
},
"typeVersion": 2
},
{
"id": "fa3f7f87-d789-4404-a0ed-684035ee3931",
"name": "创建二进制响应",
"type": "n8n-nodes-base.function",
"position": [
1120,
96
],
"parameters": {
"functionCode": "\n\nitems[0].binary = {\n data: {\n data: new Buffer(JSON.stringify(items[0].json, null, 2)).toString('base64')\n }\n};\nreturn items;"
},
"typeVersion": 1
},
{
"id": "4e19fb55-a7b8-4ecf-b35c-857eb02f4cfc",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-560,
-128
],
"parameters": {
"color": 7,
"width": 384,
"height": 208,
"content": ""
},
"typeVersion": 1
},
{
"id": "96511f0b-a610-4b2d-b73e-9f67f3ee121d",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
-240
],
"parameters": {
"color": 6,
"width": 592,
"height": 928,
"content": "## Google Gemini LLM数据提取"
},
"typeVersion": 1
},
{
"id": "312bdbbb-6073-4891-bac4-d13e02390853",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-576,
304
],
"parameters": {
"width": 592,
"height": 624,
"content": "### **用途**"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "4cdc168b-a6bc-4012-b49f-b61531f33e36",
"connections": {
"Merge": {
"main": [
[
{
"node": "Format the Response",
"type": "main",
"index": 0
}
]
]
},
"Decodo": {
"main": [
[
{
"node": "Structured Data Extractor",
"type": "main",
"index": 0
},
{
"node": "Summarizer",
"type": "main",
"index": 0
}
]
]
},
"Summarizer": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Format the Response": {
"main": [
[
{
"node": "Create a Binary Response",
"type": "main",
"index": 0
}
]
]
},
"Set the Input Fields": {
"main": [
[
{
"node": "Decodo",
"type": "main",
"index": 0
}
]
]
},
"Create a Binary Response": {
"main": [
[
{
"node": "Read/Write Files from Disk",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Structured Data Extractor",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Data Extractor": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Set the Input Fields",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model for Summarization": {
"ai_languageModel": [
[
{
"node": "Summarizer",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Google Gemini Chat Model for Structured Data Extract": {
"ai_languageModel": [
[
{
"node": "Structured Data Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Bright Data和Google Gemini的Google Maps企业抓取和线索丰富
使用Bright Data和Google Gemini的Google Maps企业抓取和线索丰富工具
Set
Code
Wait
+11
29 节点Ranjan Dailata
潜在客户开发
竞争对手情报代理：SERP监控+Thordata+OpenAI的摘要洞察
竞争对手情报代理：SERP 监控 + Thordata + OpenAI 摘要洞察
Set
Merge
Google Sheets
+8
23 节点Ranjan Dailata
市场调研
使用Decodo和GPT-4o-mini进行LinkedIn人才情报与数据挖掘
利用LinkedIn、Decodo和GPT-4o-mini提取并分析人才情报与数据挖掘
Set
Code
Merge
+9
19 节点Ranjan Dailata
人力资源
使用Bright Data MCP服务器和Google Gemini进行LinkedIn网页抓取
使用Bright Data MCP服务器和Google Gemini提取和转换LinkedIn数据
Set
Code
Merge
+9
20 节点Ranjan Dailata
人工智能
法律案例研究提取器，使用Bright Data MCP和Google Gemini的数据挖掘器
法律案例研究提取器，使用Bright Data MCP和Google Gemini的数据挖掘器
Set
Code
Wait
+10
22 节点Ranjan Dailata
人工智能
LinkedIn个人资料提取与JSON简历构建（Bright Data与Google Gemini）
LinkedIn个人资料提取与JSON简历构建（Bright Data与Google Gemini）
Set
Code
Function
+7
19 节点Ranjan Dailata
人力资源
工作流信息
难度等级
中级
节点数量15
分类2
节点类型12
作者
Ranjan Dailata
@ranjancseA Professional based out of India specialized in handling AI-powered automations. Contact me at ranjancse@gmail.com
外部链接
在 n8n.io 查看 →
分享此工作流