18 分析购买趋势
中级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 15 个节点。主要使用 GoogleSheets, McpClientTool, ManualTrigger, Agent, LmChatOpenAi 等节点。 使用Bright Data、OpenAI和Google Sheets分析亚马逊购买趋势
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (15)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "FtPQQBuZOQRWsWkH",
"meta": {
"instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
"templateCredsSetupCompleted": true
},
"name": "18 分析购买趋势",
"tags": [],
"nodes": [
{
"id": "1ab29609-739c-4f42-b398-d40e275d2531",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a4117e05-67bc-42be-ba31-4b75be46ef9f",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
480,
260
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "99c92ba4-9af0-4808-8f5a-5729ab7c922b",
"name": "从 Google Sheets 获取亚马逊URL",
"type": "n8n-nodes-base.googleSheets",
"position": [
220,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/12ouaPrMp5HEKKctEhVmjmIBVSFu75P4NFFe20XKH9mM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "12ouaPrMp5HEKKctEhVmjmIBVSFu75P4NFFe20XKH9mM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/12ouaPrMp5HEKKctEhVmjmIBVSFu75P4NFFe20XKH9mM/edit?usp=drivesdk",
"cachedResultName": "Product purchase trends"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "a9a77a78-e60c-4329-ba4a-697c806bbf5c",
"name": "亚马逊产品分析器 (AI Agent)",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
500,
0
],
"parameters": {
"text": "=extract the unit sold, current price, stock availability, review count & rating, sales rank and based on it's purchasing performance give it rating out of 10.\nBelow is the url of the amazon product:\n{{ $json.url }}",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "353646b6-e2cb-42fd-aa8d-9d3c1693ef25",
"name": "工具: MCP Client (Bright Data)",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
660,
260
],
"parameters": {
"toolName": "web_data_amazon_product",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
},
"credentials": {
"mcpClientApi": {
"id": "eqq94k789oJCd6jU",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "8ef0d68c-c9f6-4fda-8421-318da2875715",
"name": "使用产品洞察更新表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1040,
0
],
"parameters": {
"columns": {
"value": {
"Ranking": "={{ $json.output[0].performance_rating }}",
"Sales rank": "={{ $json.output[0].sales_rank }}",
"Units sold": "={{ $json.output[0].units_sold_last_month }}",
"row_number": "={{ $('Fetch Amazon URLs from Google Sheets').item.json.row_number }}",
"Current price": "={{ $json.output[0].current_price }}",
"Stock availability": "={{ $json.output[0].stock_status }}",
"Review count & rating": "={{ $json.output[0].review_count }} & {{ $json.output[0].rating }}"
},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Units sold",
"type": "string",
"display": true,
"required": false,
"displayName": "Units sold",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Current price",
"type": "string",
"display": true,
"required": false,
"displayName": "Current price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Stock availability",
"type": "string",
"display": true,
"required": false,
"displayName": "Stock availability",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Review count & rating",
"type": "string",
"display": true,
"required": false,
"displayName": "Review count & rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sales rank",
"type": "string",
"display": true,
"required": false,
"displayName": "Sales rank",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Ranking",
"type": "string",
"display": true,
"required": false,
"displayName": "Ranking",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"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/12ouaPrMp5HEKKctEhVmjmIBVSFu75P4NFFe20XKH9mM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "12ouaPrMp5HEKKctEhVmjmIBVSFu75P4NFFe20XKH9mM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/12ouaPrMp5HEKKctEhVmjmIBVSFu75P4NFFe20XKH9mM/edit?usp=drivesdk",
"cachedResultName": "Product purchase trends"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "r2mDaisH6e9VkwHl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "f2b27f36-4860-4b98-8dac-1ca89192d7a4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-620
],
"parameters": {
"color": 5,
"width": 420,
"height": 820,
"content": "### 🔹 **第一部分：触发器与读取产品URL**"
},
"typeVersion": 1
},
{
"id": "20d538a0-6bec-4e2f-9d53-55a10c7f2236",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-1120
],
"parameters": {
"color": 3,
"width": 340,
"height": 1320,
"content": "### 🤖 **第二部分：AI代理 + 爬虫 + 解析器**"
},
"typeVersion": 1
},
{
"id": "d6bd1b54-2b77-490f-acf8-001c94affccd",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-720
],
"parameters": {
"color": 6,
"width": 260,
"height": 920,
"content": "### 📈 **第三部分：使用最终数据更新Google Sheet**"
},
"typeVersion": 1
},
{
"id": "c696695f-78b4-4baf-83b6-7939311bf1b0",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-720
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入Bright Data，我将获得少量佣金——感谢您支持更多免费内容！"
},
"typeVersion": 1
},
{
"id": "67d803eb-9a83-4fcd-8c73-e3f0f5bf6285",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1820,
-620
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "adf14924-8511-4c24-878b-0c766f869ec0",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1820,
-280
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2298,
"content": "## 🚀 亚马逊产品性能分析器工作流"
},
"typeVersion": 1
},
{
"id": "14b5ab60-1fac-4728-8ab3-b52f3ef476cd",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
800,
260
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "312c6667-4ee1-4a44-85a5-99e612928451",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
760,
480
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "a238a9f8-74ac-4a40-96fb-20c60f9b9dd9",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
940,
480
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"product_name\": \"UGREEN Revodok 105 USB-C Hub\",\n \"units_sold_last_month\": 8000,\n \"current_price\": 9.98,\n \"original_price\": 15.99,\n \"stock_status\": \"In Stock\",\n \"max_quantity_available\": 30,\n \"review_count\": 18381,\n \"rating\": 4.6,\n \"sales_rank\": {\n \"overall_category\": \"#11 in Computers & Accessories\",\n \"subcategory\": \"#2 in Laptop Docking Stations\"\n },\n \"performance_rating\": 9\n },\n {\n \"product_name\": \"Amazon Product (Unnamed)\",\n \"units_sold_last_month\": 7000,\n \"current_price\": 25.78,\n \"stock_status\": \"In Stock\",\n \"review_count\": 847,\n \"rating\": 4.7,\n \"sales_rank\": {\n \"overall_category\": \"#7 in Tablet Chargers & Adapters\"\n },\n \"performance_rating\": 8.5\n },\n {\n \"product_name\": \"UGREEN Power Bank 25,000mAh 145W Laptop Portable Charger\",\n \"seller\": \"UGREEN GROUP LIMITED\",\n \"units_sold_last_month\": 2000,\n \"current_price\": 69.99,\n \"original_price\": 99.99,\n \"discount_percent\": 30,\n \"stock_status\": \"In Stock\",\n \"review_count\": 3657,\n \"rating\": 4.4,\n \"sales_rank\": {\n \"overall_category\": \"#1,198 in Cell Phones & Accessories\",\n \"subcategory\": \"#105 in Cell Phone Portable Power Banks\"\n },\n \"performance_rating\": 8\n }\n]\n"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9c19383b-cabd-4530-8c1b-19eec6c6fb4a",
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Amazon Product Analyzer (AI Agent)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "Amazon Product Analyzer (AI Agent)",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Tool: MCP Client (Bright Data)": {
"ai_tool": [
[
{
"node": "Amazon Product Analyzer (AI Agent)",
"type": "ai_tool",
"index": 0
}
]
]
},
"Amazon Product Analyzer (AI Agent)": {
"main": [
[
{
"node": "Update Sheet with Product Insights",
"type": "main",
"index": 0
}
]
]
},
"Fetch Amazon URLs from Google Sheets": {
"main": [
[
{
"node": "Amazon Product Analyzer (AI Agent)",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Fetch Amazon URLs from Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
监控本地事件
使用 Bright Data MCP 和 OpenAI 分析自动监控本地事件
Set
Code
Google Sheets
+8
18 节点Yaron Been
市场调研
分析竞争对手反向链接
使用Bright Data MCP和GPT提取和分析竞争对手反向链接数据
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
35 监控竞争对手财务状况
使用Bright Data MCP、OpenAI和Google Sheets监控竞争对手财务表现
Set
Code
Gmail
+8
18 节点Yaron Been
市场调研
监控竞争对手社交媒体互动
使用Bright Data和AI监控LinkedIn竞争对手参与度与分析
Set
Code
Google Sheets
+7
19 节点Yaron Been
市场调研
跨平台追踪品牌提及
使用 Bright Data 和 OpenAI 进行品牌提及跟踪与情感分析
Set
Google Sheets
Mcp Client Tool
+6
15 节点Yaron Been
市场调研
追踪本地搜索趋势
使用Bright Data MCP和AI分析本地Google趋势搜索数据
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
工作流信息
难度等级
中级
节点数量15
分类2
节点类型8
作者
Yaron Been
@yaron-nofluffBuilding AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos
外部链接
在 n8n.io 查看 →
分享此工作流