Amazon 键盘产品智能抓取与 Google Sheets 集成
中级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 8 个节点。主要使用 Code, GoogleSheets, ScheduleTrigger, ScrapegraphAi 等节点。 使用 ScrapeGraphAI 抓取 Amazon 键盘产品到 Google Sheets
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "JpP0OwP6cBEOvIgP",
"meta": {
"instanceId": "521567c5f495f323b77849c4cfd0c9f4f2396c986e324e0e66c8425b6f124744",
"templateCredsSetupCompleted": true
},
"name": "Amazon 键盘产品智能抓取与 Google Sheets 集成",
"tags": [],
"nodes": [
{
"id": "69b249d2-cc60-42c5-9e26-a9a739fb82a9",
"name": "自动化定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
700,
820
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "3f475331-5783-4b67-bfa3-99333f53255d",
"name": "AI 驱动的 Amazon 产品抓取器",
"type": "n8n-nodes-scrapegraphai.scrapegraphAi",
"position": [
1380,
820
],
"parameters": {
"userPrompt": "Extract all the products from this site. Use the following schema for response { \"title\": \"Logitech MX Keys Advanced Wireless Illuminated Keyboard\", \"url\": \"https://www.amazon.com/dp/B07S92QBCX\", \"category\": \"Electronics\" }",
"websiteUrl": "https://www.amazon.com/s?k=keyboard&crid=2FI5OSSH1T0Q8&sprefix=keyboar%2Caps%2C191&ref=nb_sb_ss_p13n-pd-dpltr-ranker_ci_hl-bn-left_1_7"
},
"credentials": {
"scrapegraphAIApi": {
"id": "",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "07915798-e59c-46af-b333-a9270e8dd2d8",
"name": "Google Sheets 数据存储",
"type": "n8n-nodes-base.googleSheets",
"position": [
2980,
820
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "category",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "bdc19893-aa0b-4e30-89cb-3fccc2d2d0ae",
"name": "数据格式化与处理",
"type": "n8n-nodes-base.code",
"notes": "Hey this is where \nyou \nformat results ",
"position": [
2140,
820
],
"parameters": {
"jsCode": "// Get the input data\nconst inputData = $input.all()[0].json;\n\n// Extract products array from result\nconst products = inputData.result.products;\n\n// Map each product and return only title, url, category\nreturn products.map(product => ({\n json: {\n title: product.title,\n url: product.url,\n category: product.category\n }\n}));"
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "36debe48-6a09-4036-af3f-5465aad6386e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1180,
460
],
"parameters": {
"color": 5,
"width": 574.9363634768473,
"height": 530.4701664623029,
"content": "# 步骤 2：AI 驱动的 Amazon 产品抓取器 🤖"
},
"typeVersion": 1
},
{
"id": "127e5d40-1c71-4752-97b4-6a25a00921d1",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
460
],
"parameters": {
"color": 5,
"width": 574.9363634768473,
"height": 530.4701664623029,
"content": "# 步骤 3：数据格式化与处理 🧱"
},
"typeVersion": 1
},
{
"id": "43a90a8b-c1b8-4129-8090-cc1e4110cc72",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
460
],
"parameters": {
"color": 5,
"width": 574.9363634768473,
"height": 530.4701664623029,
"content": "# 步骤 1：自动化定时触发器 ⏱️"
},
"typeVersion": 1
},
{
"id": "554bbdbe-1292-4947-8427-c29f817479be",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
2680,
460
],
"parameters": {
"color": 5,
"width": 574.9363634768473,
"height": 530.4701664623029,
"content": "# 步骤 4：Google Sheets 数据存储 📊"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a36e4f30-7663-4b7e-be9b-3e2a06cd58d1",
"connections": {
"Automated Schedule Trigger": {
"main": [
[
{
"node": "AI-Powered Amazon Product Scraper",
"type": "main",
"index": 0
}
]
]
},
"Data Formatting and Processing": {
"main": [
[
{
"node": "Google Sheets Data Storage",
"type": "main",
"index": 0
}
]
]
},
"AI-Powered Amazon Product Scraper": {
"main": [
[
{
"node": "Data Formatting and Processing",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
我的工作流程 2
AI驱动内容差距分析，使用ScrapeGraphAI和战略规划
Code
Google Sheets
Schedule Trigger
+2
18 节点vinci-king-01
市场调研
使用 ScrapegraphAI 自动抓取新闻文章并存储到 Google Sheets
使用ScrapegraphAI自动抓取新闻文章并存储到Google Sheets
Code
Google Sheets
Schedule Trigger
+2
8 节点vinci-king-01
市场调研
我的工作流 2
结合 AI 竞品监控和收入优化的自动化动态定价
If
Code
Merge
+8
25 节点vinci-king-01
市场调研
我的工作流2
使用ScrapeGraphAI和Google Sheets发现和分析SEO反向链接
Code
Filter
Email Send
+4
17 节点vinci-king-01
市场调研
我的工作流程2
使用AI、Slack和Google Sheets监控社交媒体内容趋势
Code
Merge
Slack
+5
17 节点vinci-king-01
市场调研
竞品价格监控
带AI组件和警报的价格监控仪表板
If
Code
Slack
+6
15 节点vinci-king-01
市场调研
