从Google表格自动创建Facebook广告
中级
这是一个Marketing领域的自动化工作流,包含 8 个节点。主要使用 Set, HttpRequest, GoogleSheets, FacebookGraphApi, GoogleSheetsTrigger 等节点。 从Google表格自动创建Facebook广告
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Facebook Graph API 凭证
分类
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"meta": {
"instanceId": "2718e70d3927cc6f222cd0fca1f41929053688eb8b4504451ee7746fdfef7be1"
},
"nodes": [
{
"id": "d82a3afd-4d22-4886-b175-d2f78ec54f94",
"name": "获取图片",
"type": "n8n-nodes-base.httpRequest",
"position": [
480,
20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "9aaf29e7-17f9-453f-88fb-cd9f90611706",
"name": "上传广告图片",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
700,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d1539410-3b66-4790-a20d-ec48276bc61d",
"name": "Facebook 广告创意",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
920,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0481e563-bffb-4c97-addc-74ff3620270f",
"name": "创建广告",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
1140,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "762da443-fcc0-4dc7-b024-b90b9ec563ba",
"name": "Google Sheets 触发器",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-180,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "42c1cf13-b87d-4700-bee6-655fcc7afe8c",
"name": "创建广告组",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
260,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f42f413-b004-4ee3-9f1e-8bcb943e8088",
"name": "更新 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1360,
20
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "1bbafbf9-5848-4009-b6b5-49e1ea6a2471",
"name": "指定变量",
"type": "n8n-nodes-base.set",
"position": [
40,
20
],
"parameters": {},
"typeVersion": 3.4
}
],
"pinData": {
"Google Sheets Trigger": [
{
"Hooks": "\"Ever wish you could sprinkle a little magic into their day, even with your busy schedule?\"",
"ad id": "120219801541720760",
"Render URL": "https://templated-assets.s3.amazonaws.com/render/d8785acf-a6f4-4f25-bb17-46abe7376cd4.jpg",
"generate ad": "generated"
}
]
},
"connections": {
"Get image": {
"main": [
[
{
"node": "Upload Ad image",
"type": "main",
"index": 0
}
]
]
},
"Create an Ad": {
"main": [
[
{
"node": "Update Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Upload Ad image": {
"main": [
[
{
"node": "Facebook Ad Creative",
"type": "main",
"index": 0
}
]
]
},
"Create an Ad Set": {
"main": [
[
{
"node": "Get image",
"type": "main",
"index": 0
}
]
]
},
"Specify variables": {
"main": [
[
{
"node": "Create an Ad Set",
"type": "main",
"index": 0
}
]
]
},
"Facebook Ad Creative": {
"main": [
[
{
"node": "Create an Ad",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Specify variables",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 营销
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
使用AI、ElevenLabs和多平台发布创建和审批POV视频
使用AI、ElevenLabs和多平台发布创建和审批POV视频(TikTok/IG/YT)
If
Set
Code
+20
60 节点Immanuel
设计
使用AI将Reddit帖子转换为短视频
使用AI将Reddit帖子转换为短视频
If
Set
Code
+11
43 节点Artur
人工智能
AI YouTube分析助手:评论分析与洞察报告
AI YouTube分析助手:评论分析器与洞察报告生成器
If
Set
Code
+9
19 节点Yaron Been
人工智能
自动博客推广器 - 社交媒体帖子发布器
基于GPT的AI驱动博客文章推广器,用于Instagram、Facebook和X平台
If
Set
Code
+12
44 节点LukaszB
人工智能
## 🤖 **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
人工智能