获取Meta广告洞察并保存到Google表格
高级
这是一个Marketing领域的自动化工作流，包含 20 个节点。主要使用 Filter, SplitOut, GoogleSheets, ManualTrigger, ScheduleTrigger 等节点。 获取Meta广告洞察并保存到Google表格
前置要求
- •Google Sheets API 凭证
- •Facebook Graph API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "82313e22-7fea-4d64-95d6-577d1ac46775",
"name": "仅数据列",
"type": "n8n-nodes-base.splitOut",
"position": [
1320,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4ad67c87-ff93-460c-b2b4-5053f1393ed9",
"name": "拆分操作",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "79c0f6f5-6f44-4b1c-b8aa-ab4a5e963baf",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
860,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "23bedaf7-e02f-4947-9446-addf864302fd",
"name": "每天凌晨3点",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
860,
60
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b221a2b7-ac20-4c0d-a655-27849fa2649a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "43f806e2-92d5-4a02-8491-2ddeca3601c7",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b6e86b79-ddde-4095-a602-08f5ceadcfa8",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2600,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "55a38170-38ef-4c03-9284-d31c2d057e70",
"name": "任意时间段的广告洞察",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
1080,
560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "28e25544-838f-43a8-9fb9-8d9c7ba57bf1",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "88fdc9b5-c918-4756-9d66-f4694b87cffd",
"name": "昨日广告洞察",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
1080,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3287f957-9464-4cbc-93b9-5b6f07655b9c",
"name": "拆分操作值",
"type": "n8n-nodes-base.splitOut",
"position": [
2100,
500
],
"parameters": {},
"typeVersion": 1
},
{
"id": "422671e1-e054-45ed-b5f6-246085320f6c",
"name": "按操作类型筛选",
"type": "n8n-nodes-base.filter",
"position": [
2600,
240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "18202591-8208-4f4d-b861-640c4ccb1d8f",
"name": "仅货币操作",
"type": "n8n-nodes-base.filter",
"position": [
2340,
500
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "ac91d6d2-6d61-4687-8a8a-551cadc36516",
"name": "按货币操作类型筛选",
"type": "n8n-nodes-base.filter",
"position": [
2600,
500
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "54b9a7bd-0642-4c0f-9159-09ebf1baa8ce",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2600,
660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45ad5870-8381-46e3-a713-2ae31313c597",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3140,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6d8ad63c-a53e-4831-9ab4-dda7aaa71d5b",
"name": "添加通用指标",
"type": "n8n-nodes-base.googleSheets",
"position": [
1600,
20
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "3b530b1d-11d8-43b3-a60c-92bfb0a77297",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d22e5ce5-533d-4745-959c-38df65b17148",
"name": "添加非货币操作",
"type": "n8n-nodes-base.googleSheets",
"position": [
2920,
240
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "c7c25228-7a03-4ec8-b827-7a64da151be8",
"name": "添加货币操作",
"type": "n8n-nodes-base.googleSheets",
"position": [
2920,
500
],
"parameters": {},
"typeVersion": 4.4
}
],
"pinData": {},
"connections": {
"split actions": {
"main": [
[
{
"node": "split action values",
"type": "main",
"index": 0
},
{
"node": "filter by action type",
"type": "main",
"index": 0
}
]
]
},
"Everyday at 3am": {
"main": [
[
{
"node": "Ad insights from yesterday",
"type": "main",
"index": 0
}
]
]
},
"data column only": {
"main": [
[
{
"node": "split actions",
"type": "main",
"index": 0
},
{
"node": "Add General Metrics",
"type": "main",
"index": 0
}
]
]
},
"split action values": {
"main": [
[
{
"node": "Only monetary actions",
"type": "main",
"index": 0
}
]
]
},
"Only monetary actions": {
"main": [
[
{
"node": "filter by monetary action type",
"type": "main",
"index": 0
}
]
]
},
"filter by action type": {
"main": [
[
{
"node": "Add Non-Monetary actions",
"type": "main",
"index": 0
}
]
]
},
"Add Non-Monetary actions": {
"main": [
[]
]
},
"Ad insights from yesterday": {
"main": [
[
{
"node": "data column only",
"type": "main",
"index": 0
}
]
]
},
"filter by monetary action type": {
"main": [
[
{
"node": "Add Monetary actions",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Ad insights from yesterday",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
双向同步 Google 通讯录与 Notion
双向同步 Google 通讯录与 Notion
If
Set
Merge
+9
82 节点Solomon
其他
使用Google Maps生成潜在客户 - AlexK1919
使用Google Maps生成潜在客户
If
Set
Code
+13
42 节点Alex Kim
销售
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
模板 | Meta 广告余额低时获取通知
当 Meta 广告余额低时获取通知
If
Set
Telegram
+4
16 节点Solomon
营销
## 🤖 **LIGUA033/LOREALCANTARA - 其他生成工作流**
基于AI的Meta广告分析与创建：使用Gemini、GPT-4.1 Mini和广告管理器
If
Set
Wait
+13
61 节点Daniel Setzermann
人工智能
从Google趋势和Perplexity自动生成社交媒体帖子副本
基于Google趋势和Perplexity AI的AI驱动多社交媒体帖子自动化
Set
Code
Wait
+9
18 节点Gerald Denor
人工智能
工作流信息
难度等级
高级
节点数量20
分类1
节点类型7
作者
Solomon
@solomonFreelance consultant from Brazil, specializing in automations and data analysis. I work with select clients, addressing their toughest projects. For business inquiries, email me at automations.solomon@gmail.com or message me on Telegram for a faster response.
外部链接
在 n8n.io 查看 →
分享此工作流