创建Google Play Store评论摘要
高级
这是一个Market Research、AI RAG领域的自动化工作流，包含 30 个节点。主要使用 Set、Slack、Filter、SplitOut、HttpRequest 等节点。 使用GPT-4-mini、Pinecone和Slack提醒汇总Google Play Store评论
前置要求
- •Slack Bot Token 或 Webhook URL
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
- •Pinecone API Key
使用的节点 (30 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "GE9244KEY5823lcB",
"meta": {
"instanceId": "fe52080916406a2a9812a7975b2d9b9e9838f3ce0f0b34614c611fb2ca1528d3"
},
"name": "创建 Google Play Store 评论摘要",
"tags": [],
"nodes": [
{
"id": "976a0252-5685-4678-83d8-925d06853179",
"name": "拆分输出4",
"type": "n8n-nodes-base.splitOut",
"position": [
288,
-384
],
"parameters": {
"include": "=",
"options": {
"destinationFieldName": ""
},
"fieldToSplitOut": "reviews"
},
"typeVersion": 1
},
{
"id": "9ad91b18-e9c3-4e43-b301-cc833747fbe2",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
-112,
-384
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "fd00f503-709f-472d-b0c3-8e8d617f8506",
"name": "遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
-192,
96
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "c67fa141-8df9-4010-8d46-b038bc540381",
"name": "AI Agent - 摘要创建器",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
32,
96
],
"parameters": {
"text": "=Create a summary of store reviews submitted. Start your message with \"Hi! This is your Google Play Store AI agent for *{{$json.app_name}}*\". In your output, include the number of reviews you processed to create the summary. The summary should be split into two groups: a summary about positive reviews and a summary about negative reviews. In your summary include also a breakdown of star ratings, ie. how many reviews there were for each star rating. Also include the average star rating.",
"options": {
"systemMessage": "=Your job is to respond to prompts using the information you gather from the Google Play Store reviews of an app called {{$json.app_name}}. Your main role is to help your users to gain insights from store review without having to read reviews one by one. Store review usually have star ratings with 1 star being the lowest rating and 5 star being the highest rating. They can also have a text description where the player of the game write a review about their experience with the app. These can be negative reviews or positive reviews. The lower the star rating is the more likely that the review is negative."
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "83cf0fc5-66cc-4598-b354-6dd0f4f9ef1c",
"name": "设置 bundle id",
"type": "n8n-nodes-base.set",
"position": [
-512,
-384
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ed79836f-8032-4daa-afc1-d0170157c8a0",
"name": "=apps",
"type": "array",
"value": "[\n \"com.bundle.id1\",\n \"com.bundle.id2\",\n \"com.bundle.id3\"\n]"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "93bea9f6-775f-4232-be24-b33bba745393",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-592,
-576
],
"parameters": {
"color": 7,
"width": 272,
"height": 336,
"content": "定义您要汇总评论的 Google Play Store 应用的 bundle id 列表。Bundle id 可以在应用的 Google Play Store URL 中找到。例如，URL 为 https://play.google.com/store/apps/details?id=com.tripledot.blockbash 的应用的 bundle id 是 com.tripledot.blockbash"
},
"typeVersion": 1
},
{
"id": "0bcfc993-e58e-49d6-aeba-ad7accb2087b",
"name": "每日触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "Daily at 10am ",
"position": [
-720,
-384
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 10
}
]
}
},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "53df7cef-c399-48a5-bd10-82ec4547999a",
"name": "分离",
"type": "n8n-nodes-base.splitOut",
"position": [
-288,
-384
],
"parameters": {
"options": {},
"fieldToSplitOut": "apps"
},
"typeVersion": 1
},
{
"id": "e1b05a7a-a9ce-4eed-89f9-c4162d76f1f0",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
-464
],
"parameters": {
"color": 7,
"width": 320,
"height": 224,
"content": "遍历列表中的 bundle id（应用）"
},
"typeVersion": 1
},
{
"id": "68a7de8f-ad17-4b8b-8a5e-fba73b66794f",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
112,
-384
],
"parameters": {
"url": "=https://androidpublisher.googleapis.com/androidpublisher/v3/applications/{{$json.apps}}/reviews",
"options": {
"pagination": {
"pagination": {
"parameters": {
"parameters": [
{
"name": "token",
"value": "={{$response.body.tokenPagination.nextPageToken}}"
}
]
},
"maxRequests": 10,
"requestInterval": 10,
"limitPagesFetched": true,
"completeExpression": "={{$response.body.tokenPagination.nextPageToken == null}}",
"paginationCompleteWhen": "other"
}
}
},
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleApi"
},
"credentials": {
"googleApi": {
"id": "Px4DvklLsQOnXqCH",
"name": "Google Service Account - n8n-ertay@n8n-ertay.iam.gserviceaccount.com"
}
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "9a2f22a9-294e-472f-862f-cad8f9209d60",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-464
],
"parameters": {
"color": 7,
"width": 336,
"height": 224,
"content": "使用服务账户从 Google 获取评论"
},
"typeVersion": 1
},
{
"id": "beb2b08e-f53d-4b36-82a8-ae282ae477ba",
"name": "过滤器",
"type": "n8n-nodes-base.filter",
"notes": "Fetch yesterday's reviews",
"position": [
496,
-384
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e5cc101a-9e06-4f33-8578-63c4acc66042",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $json.reviews.comments[0].userComment.lastModified.seconds.toDateTime('s').toISODate() }}",
"rightValue": "={{$today.minus({days: 1})}}\n"
}
]
}
},
"notesInFlow": true,
"typeVersion": 2.2,
"alwaysOutputData": true
},
{
"id": "63dfdf05-c792-49a9-830a-ec21edf907e1",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
464,
-464
],
"parameters": {
"color": 7,
"width": 464,
"height": 224,
"content": "将前一天的评论存储在向量存储中。为每个应用（bundle id）创建不同的命名空间。每周清除命名空间一次以删除旧评论。"
},
"typeVersion": 1
},
{
"id": "3107ffd9-94ea-43ef-9fad-d0c8c75c32b4",
"name": "Pinecone 向量存储",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
688,
-384
],
"parameters": {
"mode": "insert",
"options": {
"clearNamespace": "={{ new Date().getDay() === 6 }}",
"pineconeNamespace": "=google_play_store_reviews_{{ $('Split Out').item.json.apps }}"
},
"pineconeIndex": {
"__rl": true,
"mode": "list",
"value": "n8n-store-reviews",
"cachedResultName": "n8n-store-reviews"
}
},
"credentials": {
"pineconeApi": {
"id": "AhisTk5eS6H3HYiC",
"name": "PineconeApi account"
}
},
"typeVersion": 1.3
},
{
"id": "a7611074-702b-496a-bef4-be4eeffda2b9",
"name": "OpenAI 嵌入",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
672,
-160
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "iAPtqcVj4gp3rRy2",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "d6f865d0-fba7-456e-9bed-b531b11250c5",
"name": "默认数据加载器",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
864,
-160
],
"parameters": {
"options": {
"metadata": {
"metadataValues": [
{
"name": "star_rating",
"value": "={{ $json.reviews.comments[0].userComment.starRating }}"
},
{
"name": "date",
"value": "={{$json.reviews.comments[0].userComment.lastModified.seconds.toDateTime('s')}}\n"
},
{
"name": "app_version",
"value": "={{ $json.reviews.comments[0].userComment.appVersionName }}"
},
{
"name": "language",
"value": "={{ $json.reviews.comments[0].userComment.reviewerLanguage }}"
},
{
"name": "review_id",
"value": "={{ $json.reviews.reviewId }}"
}
]
}
},
"jsonData": "=comment: {{ $json.reviews.comments[0].userComment.text }} | date: {{ $json.reviews.comments[0].userComment.lastModified.seconds.toDateTime('s') }} | star rating: {{ $json.reviews.comments[0].userComment.starRating }} | app version: {{ $json.reviews.comments[0].userComment.appVersionName }} | language: {{ $json.reviews.comments[0].userComment.reviewerLanguage }}",
"jsonMode": "expressionData"
},
"typeVersion": 1.1
},
{
"id": "fd7a2f0c-69f4-446e-978c-1b67d0041f87",
"name": "设置应用详情",
"type": "n8n-nodes-base.set",
"position": [
-544,
96
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ed79836f-8032-4daa-afc1-d0170157c8a0",
"name": "=apps",
"type": "array",
"value": "=[\n { \n \"app\": \"com.bundle.id1\",\n \"app_name\": \"App1\"\n },\n {\n \"app\": \"com.bundle.id2\",\n \"app_name\": \"App2\"\n },\n {\n \"app\": \"com.bundle.id3\",\n \"app_name\": \"App3\"\n }\n]"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "d2a57fa1-b396-4132-9ab6-7316a20a11cd",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-384,
16
],
"parameters": {
"color": 7,
"width": 320,
"height": 224,
"content": "遍历列表中的 bundle id（应用）"
},
"typeVersion": 1
},
{
"id": "e9baa7a4-d0bc-4dd1-90da-4677d75d6c75",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-576,
16
],
"parameters": {
"color": 7,
"width": 176,
"height": 224,
"content": "定义应用 bundle id 和名称"
},
"typeVersion": 1
},
{
"id": "3e88c0ea-e6d5-412c-9aae-a702220d626d",
"name": "分离1",
"type": "n8n-nodes-base.splitOut",
"position": [
-368,
96
],
"parameters": {
"options": {},
"fieldToSplitOut": "apps"
},
"typeVersion": 1
},
{
"id": "4eac3a49-5126-47b6-b748-fb97770dbab8",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-32,
320
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "iAPtqcVj4gp3rRy2",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "044cd2a3-c3d4-41a2-8c46-4291b3ba0ac8",
"name": "OpenAI 嵌入1",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
96,
448
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "iAPtqcVj4gp3rRy2",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "ec306b60-8dbb-4ea9-a4c3-fa5ce4807f1d",
"name": "Pinecone 向量存储1",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
96,
304
],
"parameters": {
"mode": "retrieve-as-tool",
"topK": 500,
"options": {
"pineconeNamespace": "=google_play_store_reviews_{{ $('Loop Over Items1').item.json.app }}"
},
"pineconeIndex": {
"__rl": true,
"mode": "list",
"value": "n8n-store-reviews",
"cachedResultName": "n8n-store-reviews"
},
"toolDescription": "This is the vector store for the Google Play reviews data you need to answer queries"
},
"credentials": {
"pineconeApi": {
"id": "AhisTk5eS6H3HYiC",
"name": "PineconeApi account"
}
},
"typeVersion": 1.3
},
{
"id": "053e5a35-875e-4e16-a788-ec2c7eea8425",
"name": "发送到 Slack 频道",
"type": "n8n-nodes-base.slack",
"position": [
400,
80
],
"webhookId": "91dd6021-c694-4470-9013-53d5f2e213f8",
"parameters": {
"text": "={{ $json.output }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "id",
"value": "C1111"
},
"otherOptions": {}
},
"credentials": {
"slackApi": {
"id": "tVU8HVcP92PJGgqD",
"name": "Slack account"
}
},
"typeVersion": 2.3
},
{
"id": "18bd7d4e-7893-4c36-85fa-300cfe55f941",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
16
],
"parameters": {
"color": 7,
"width": 272,
"height": 224,
"content": "为应用生成 Google Play Store 评论摘要"
},
"typeVersion": 1
},
{
"id": "cc8b8188-9d76-4dc1-babc-37cfc0c6cd84",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
16
],
"parameters": {
"color": 7,
"width": 192,
"height": 224,
"content": "将摘要发布到 Slack 频道"
},
"typeVersion": 1
},
{
"id": "071bb344-81f1-45f6-bd41-b3df56e7ef4f",
"name": "每周触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "On Fridays at 11am",
"position": [
-736,
96
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
5
],
"triggerAtHour": 11
}
]
}
},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "89236196-49fa-4fc9-a9c1-b8388b0f83d7",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-768,
16
],
"parameters": {
"color": 7,
"width": 176,
"height": 224,
"content": "每周准备并发送摘要一次"
},
"typeVersion": 1
},
{
"id": "109b52b1-1223-49f2-88d5-60dc2d2d2b80",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
-608
],
"parameters": {
"width": 448,
"height": 928,
"content": "## 使用 Pinecone、OpenAI 和 Slack 通知的 Google Play Store 评论摘要"
},
"typeVersion": 1
},
{
"id": "f215d048-e697-4925-a471-260062de023c",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-464
],
"parameters": {
"color": 7,
"width": 176,
"height": 224,
"content": "每天获取一次评论"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "2b67c997-3545-4e0b-ab4c-4ea4f5d53535",
"connections": {
"Filter": {
"main": [
[
{
"node": "Pinecone Vector Store",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Split Out1": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Split Out4": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Split Out4",
"type": "main",
"index": 0
}
]
]
},
"Daily Trigger": {
"main": [
[
{
"node": "Set the bundle ids",
"type": "main",
"index": 0
}
]
]
},
"Weekly trigger": {
"main": [
[
{
"node": "Set app details",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Set app details": {
"main": [
[
{
"node": "Split Out1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "AI Agent - Summary creator",
"type": "main",
"index": 0
}
]
]
},
"Embeddings OpenAI": {
"ai_embedding": [
[
{
"node": "Pinecone Vector Store",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Embeddings OpenAI1": {
"ai_embedding": [
[
{
"node": "Pinecone Vector Store1",
"type": "ai_embedding",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "AI Agent - Summary creator",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Set the bundle ids": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Default Data Loader": {
"ai_document": [
[
{
"node": "Pinecone Vector Store",
"type": "ai_document",
"index": 0
}
]
]
},
"Pinecone Vector Store": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Send to Slack channel": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Pinecone Vector Store1": {
"ai_tool": [
[
{
"node": "AI Agent - Summary creator",
"type": "ai_tool",
"index": 0
}
]
]
},
"AI Agent - Summary creator": {
"main": [
[
{
"node": "Send to Slack channel",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Market Research、AI RAG等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Apple App Store评论摘要
使用Pinecone、GPT-4 Mini和Slack通知汇总Apple App Store评论
Jwt
Set
Slack
+11
32 节点Ertay Kaya
Market Research
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
Other
Zendesk -> Pinecone -> AI 智能体 -> Slack
基于 Pinecone、OpenAI 和 Slack 的 Zendesk 工单摘要生成器
Wait
Slack
Zendesk
+7
18 节点Ertay Kaya
Ticket Management
🤖 使用Gemini RAG流水线构建文档专家聊天机器人
使用OpenAI RAG流水线构建n8n文档专家聊天机器人
Set
Html
Filter
+16
46 节点Ayham
Internal Wiki
AIAutomationPro终极RAG聊天机器人v1 n8n市场模板
多语言Telegram RAG聊天机器人，集成监督AI和自动化Google Drive流程
If
Set
Wait
+29
128 节点Daniel Ng
Support Chatbot
AI行业趋势24/7监控（X、Gmail和网站）
基于GPT-5的AI行业趋势24/7监控（X、Gmail和网站）
Set
Gmail
Airtop
+13
35 节点LeeWei
Market Research
