Google Analytics洞察
中级
这是一个Market Research、Multimodal AI领域的自动化工作流，包含 15 个节点。主要使用 Gmail、Telegram、Aggregate、Agent、GoogleAnalytics 等节点。 使用Gemini AI自动分析Google Analytics数据并进行智能Gmail/Telegram路由
前置要求
- •Google 账号和 Gmail API 凭证
- •Telegram Bot Token
- •Google Gemini API Key
使用的节点 (15 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "zFO2MKhe5TtfOLB9",
"meta": {
"instanceId": "d02289ff41436fdfe97f97a509483d64007d2a482e6a216298112e027bb59fbf",
"templateCredsSetupCompleted": true
},
"name": "Google Analytics Insight",
"tags": [],
"nodes": [
{
"id": "f6917f16-25d4-4118-bc0d-1d53e4ca2da4",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"daysInterval": 7
}
]
}
},
"typeVersion": 1.2
},
{
"id": "6cd64c8e-48d4-4853-a47e-504c43d8cb88",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
416,
0
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "6925c157-aa0b-4838-a067-3c5eb6c45a76",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
816,
432
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"id": "LqsDVdm5OmSBk8zP",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "3ebc007d-f125-47b8-9b78-efe15bbed229",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
624,
0
],
"parameters": {
"text": "={{ $json.data }}",
"options": {
"systemMessage": "Acting as a experience data analyst who mainly working with the analytics data. Please analyze the those google analytics report with the past history. Give the insightful and important summary. Make it concise maximum 1000 chars. The important information must give `` so user can notice easily. The result must follow the telegram messenger format. Compare with your memory as well.\n\nThink step by step."
},
"promptType": "define"
},
"typeVersion": 2.1
},
{
"id": "3867152b-24bc-4755-9098-8adc0b290c17",
"name": "简单记忆",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
752,
160
],
"parameters": {
"sessionKey": "={{ $json.data }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "0b839f21-b96c-47c7-ac2c-4797432704ad",
"name": "获取每周报告",
"type": "n8n-nodes-base.googleAnalytics",
"position": [
208,
0
],
"parameters": {
"metricsGA4": {
"metricValues": [
{
"listName": "eventCount"
},
{
"listName": "userEngagementDuration"
},
{},
{
"listName": "active7DayUsers"
},
{
"listName": "active28DayUsers"
},
{
"listName": "sessions"
}
]
},
"propertyId": {
"__rl": true,
"mode": "list",
"value": "483751327",
"cachedResultUrl": "",
"cachedResultName": ""
},
"dimensionsGA4": {
"dimensionValues": [
{}
]
},
"additionalFields": {}
},
"credentials": {
"googleAnalyticsOAuth2": {
"id": "bIarKstIyNxZFNce",
"name": "Google Analytics account"
}
},
"typeVersion": 2
},
{
"id": "3fb80b30-c2ff-4d1c-a810-de96348d7b41",
"name": "向群组发送消息",
"type": "n8n-nodes-base.telegram",
"position": [
1328,
176
],
"webhookId": "c7abeda5-d1dd-4b61-b303-62dc3184cb56",
"parameters": {
"text": "=Weekly Analytics Report by Gemini \n`{{ $today.minus(7,'days').format('yyyy-MM-dd') }}` to `{{ $today.format('yyyy-MM-dd') }}`\n\n{{ $json.output }}",
"chatId": "",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "BDQbUISqJJFVGPsF",
"name": "Telegram account"
}
},
"typeVersion": 1.2
},
{
"id": "fa35b2b5-1ea3-42f5-a1ff-b10716e22e13",
"name": "洞察情感分析",
"type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
"position": [
976,
0
],
"parameters": {
"options": {
"categories": "Positive, Negative"
},
"inputText": "={{ $json.output }}"
},
"typeVersion": 1.1
},
{
"id": "605ceecc-27fe-4bf2-9315-290a82c7d6ff",
"name": "通知利益相关者",
"type": "n8n-nodes-base.gmail",
"position": [
1344,
-96
],
"webhookId": "d7ff25c2-3291-4320-8f99-1e7bfc6829ef",
"parameters": {
"sendTo": "",
"message": "={{ $('AI Agent').item.json.output }}",
"options": {},
"subject": "=GA Weekly Report - Positive Trends - {{ $today.minus(7,'days').format('yyyy-MM-dd') }} - {{ $today.format('yyyy-MM-dd') }}"
},
"credentials": {
"gmailOAuth2": {
"id": "jnWB2PPVjndum47v",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "dd9a5860-f6df-4e7e-a72d-699a772a804f",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-320
],
"parameters": {
"width": 480,
"height": 240,
"content": "## AI驱动的Google Analytics洞察+情感路由"
},
"typeVersion": 1
},
{
"id": "edde901a-8909-4c5d-a9b2-a9fa32026123",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
624,
-224
],
"parameters": {
"color": 7,
"width": 272,
"height": 176,
"content": "## AI Agent"
},
"typeVersion": 1
},
{
"id": "5d0523ed-85e4-4e43-a452-6dae0954b919",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
368,
144
],
"parameters": {
"color": 7,
"width": 176,
"height": 128,
"content": "## 聚合"
},
"typeVersion": 1
},
{
"id": "80607b8d-60fc-4ece-9f7c-5d09bd826a18",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1248,
-304
],
"parameters": {
"color": 7,
"width": 272,
"height": 176,
"content": "## 通知利益相关者"
},
"typeVersion": 1
},
{
"id": "32449586-884b-45b1-855c-8a6796c2de85",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1248,
384
],
"parameters": {
"color": 7,
"width": 272,
"height": 176,
"content": "## 发送消息"
},
"typeVersion": 1
},
{
"id": "e55512cb-9cea-455d-a3c1-1ae31593b1c0",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
496,
320
],
"parameters": {
"color": 7,
"width": 272,
"height": 176,
"content": "## 简单内存"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "2e96d5f2-7cb1-405f-8c51-631bb8e7b8d6",
"connections": {
"AI Agent": {
"main": [
[
{
"node": "Insight Sentiment Analysis",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Simple Memory": {
"ai_memory": [
[
{
"node": "AI Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get a weekly report",
"type": "main",
"index": 0
}
]
]
},
"Get a weekly report": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Insight Sentiment Analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Insight Sentiment Analysis": {
"main": [
[
{
"node": "Notify Stakeholders",
"type": "main",
"index": 0
}
],
[
{
"node": "Send a message to group",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个中级难度的工作流，适用于Market Research、Multimodal AI等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Jotform
使用Gemini、Jotform、Google Sheets和Gmail回复的自动化客户反馈分诊
Gmail
Switch
Telegram
+8
18 节点Rully Saputra
Gmail助手，含Google Gemini分类与Telegram通知
Gmail助手，含Google Gemini分类与Telegram通知
If
Gmail
Switch
+9
25 节点Roshan Ramani
AI Chatbot
深度研究智能体
深度研究智能体 - 自动化研究与 Notion 报告生成器
Set
Code
Filter
+17
43 节点Aziz B
Market Research
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
Other
AI行业趋势24/7监控（X、Gmail和网站）
基于GPT-5的AI行业趋势24/7监控（X、Gmail和网站）
Set
Gmail
Airtop
+13
35 节点LeeWei
Market Research
使用AI生成并发布独特的MCQ投票到Telegram
使用Gemini AI和Google Sheets生成独特的多选题投票并发布至Telegram
If
Aggregate
Http Request
+8
15 节点Pawan
Content Creation
工作流信息
难度等级
中级
节点数量15
分类2
节点类型10
作者
Rully Saputra
@rullysaputra15Specializing in software engineering with over 5 years of hands-on experience. In addition to my expertise in web development, I also have experience in creating Hybrid mobile apps.
外部链接
在 n8n.io 上查看 →
分享此工作流