使用 Dumpling AI 从 Google Sheets 中的网站 URL 抓取产品信息
初级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 5 个节点。主要使用 SplitOut, HttpRequest, GoogleSheets, GoogleSheetsTrigger 等节点。 使用 Dumpling AI 从 Google Sheets 中的网站 URL 抓取产品信息
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "rZUGnDWjoGy2pTfc",
"meta": {
"instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
"templateCredsSetupCompleted": true
},
"name": "使用 Dumpling AI 从 Google Sheets 中的网站 URL 抓取产品信息",
"tags": [],
"nodes": [
{
"id": "723c50fc-f9bb-4a9c-ba59-929afa88affc",
"name": "监控 Google Sheets 中的新网站 URL",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-400,
-40
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yUCXVTVaFZTAx3x-5CgqwOx1syJ0Xhop9XcPZUFKojI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yUCXVTVaFZTAx3x-5CgqwOx1syJ0Xhop9XcPZUFKojI/edit?usp=drivesdk",
"cachedResultName": "lead's website"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "qDzHSzTkclwDHpSR",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "2adc3154-b6d7-4e70-8dea-d41ab6d76e60",
"name": "使用 Dumpling AI 提取产品信息",
"type": "n8n-nodes-base.httpRequest",
"position": [
-180,
-40
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/extract",
"method": "POST",
"options": {},
"jsonBody": "={\n \"url\": \"{{ $json.Website }}\",\n \"schema\": {\n \"productName\": \"string\",\n \"price\": \"string\",\n \"review\": \"string?\",\n \"productDescription\": \"string\"\n }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "RLFzAcGRepr5eXZB",
"name": "Dumpling AI-n8n"
}
},
"typeVersion": 4.2
},
{
"id": "7e9fad7a-df64-4dbd-b78c-680f25e0cdab",
"name": "拆分提取的产品",
"type": "n8n-nodes-base.splitOut",
"position": [
40,
-40
],
"parameters": {
"options": {},
"fieldToSplitOut": "results"
},
"typeVersion": 1
},
{
"id": "bbc22f2d-a5df-4461-aaa2-ada5ea1cc348",
"name": "将产品信息追加到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
260,
-40
],
"parameters": {
"columns": {
"value": {
"price": "={{ $json.price }}",
"productName": "={{ $json.productName }}",
"productDescription": "={{ $json.productDescription }}"
},
"schema": [
{
"id": "productName",
"type": "string",
"display": true,
"required": false,
"displayName": "productName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "price",
"type": "string",
"display": true,
"required": false,
"displayName": "price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review",
"type": "string",
"display": true,
"required": false,
"displayName": "review",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "productDescription",
"type": "string",
"display": true,
"required": false,
"displayName": "productDescription",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1143304403,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yUCXVTVaFZTAx3x-5CgqwOx1syJ0Xhop9XcPZUFKojI/edit#gid=1143304403",
"cachedResultName": "product details"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yUCXVTVaFZTAx3x-5CgqwOx1syJ0Xhop9XcPZUFKojI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yUCXVTVaFZTAx3x-5CgqwOx1syJ0Xhop9XcPZUFKojI/edit?usp=drivesdk",
"cachedResultName": "lead's website"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GaJqJHuS5mQxap7q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "d93a9076-63e9-46fe-9b29-efe78215dc98",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
-280
],
"parameters": {
"width": 540,
"height": 320,
"content": "### 🛍️ 使用 Dumpling AI 从 Google Sheets 中的网站 URL 抓取产品信息"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "b90d016a-e6b0-4629-a5d6-d5e6636868b4",
"connections": {
"Split Extracted Products": {
"main": [
[
{
"node": "Append Product Info to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Extract Product Info with Dumpling AI": {
"main": [
[
{
"node": "Split Extracted Products",
"type": "main",
"index": 0
}
]
]
},
"Watch New Website URL in Google Sheets": {
"main": [
[
{
"node": "Extract Product Info with Dumpling AI",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
初级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Dumpling AI + GPT-4从Google评论中提取营销洞察
使用Dumpling AI + GPT-4从Google评论中提取营销洞察
Split Out
Aggregate
Form Trigger
+7
10 节点Yang
市场调研
使用Dumpling AI和GPT-4o从任何网站提取产品选择
使用Dumpling AI和GPT-4o从任何网站提取热门产品
Code
Gmail
Split Out
+5
9 节点Yang
市场调研
使用 Dumpling AI + GPT-4o + Google Sheets 的 AI 竞争对手评论分析器
基于Dumpling AI + GPT-4o + Google Sheets的AI竞争对手评论分析器
Split Out
Aggregate
Http Request
+4
8 节点Yang
使用Dumpling AI和GPT-4o从网页截图提取产品信息
通过Dumpling AI和GPT-4o从网页截图中提取产品信息
Split Out
Google Drive
Http Request
+4
11 节点Yang
人工智能
使用Dumpling AI和GPT-4o生成YouTube视频创意
通过视频分析使用Dumpling AI和GPT-4o生成YouTube内容创意
Code
Wait
Gmail
+8
13 节点Yang
内容创作
01 使用AI媒体买家分析Facebook广告表现并将洞察发送到Google Sheets
使用Gemini AI分析Facebook广告并将洞察发送到Google Sheets
If
Set
Code
+13
34 节点JJ Tham
市场调研
