每日Google广告表现同步到Notion和Google Sheets
高级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 19 个节点。主要使用 Set, Code, Merge, Notion, HttpRequest 等节点。 每日Google广告表现同步到Notion和Google Sheets
前置要求
- •Notion API Key
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "1ff3f71877f94a07ce0b138fce26fa00489eae8aeeb1e8b837f52d5baca65402",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "5ff5e3a4-baf5-4cbf-a75d-6d36a82a4e56",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
560,
760
],
"parameters": {
"color": 3,
"width": 640,
"height": 720,
"content": ""
},
"typeVersion": 1
},
{
"id": "4e646849-8389-4ee5-95d1-f1d50437c623",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
760
],
"parameters": {
"color": 3,
"width": 640,
"height": 740,
"content": "### Google Ads 点击与转化 (HTTP POST)"
},
"typeVersion": 1
},
{
"id": "33ddcd1d-f6f7-437c-b920-f8b3e17ffa3b",
"name": "G-Ads 查询点击",
"type": "n8n-nodes-base.httpRequest",
"position": [
380,
400
],
"parameters": {
"url": "https://googleads.googleapis.com/v20/customers/{{YOUR_CUSTOMER_ID}}/googleAds:search",
"method": "POST",
"options": {},
"jsonBody": "={{ \n {\n query: `SELECT \n campaign.id, \n campaign.name, \n metrics.impressions, \n metrics.clicks, \n metrics.cost_micros, \n segments.date \n FROM campaign \n WHERE segments.date = '${$json.yesterday}'`\n }\n}}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "developer-token"
},
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "login-customer-id"
}
]
},
"nodeCredentialType": "googleAdsOAuth2Api"
},
"credentials": {},
"typeVersion": 4.2
},
{
"id": "58d2857b-fbe7-4906-9878-985a99426f29",
"name": "G-Ads 查询转化",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
380,
600
],
"parameters": {
"url": "https://googleads.googleapis.com/v20/customers/{{YOUR_CUSTOMER_ID}}/googleAds:search",
"method": "POST",
"options": {},
"jsonBody": "={{ \n {\n query: `SELECT \n campaign.id,\n campaign.name,\n metrics.conversions,\n segments.conversion_action_name,\n segments.date \n FROM campaign \n WHERE segments.date = '${$json.yesterday}'`\n }\n}}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "developer-token"
},
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "login-customer-id"
}
]
},
"nodeCredentialType": "googleAdsOAuth2Api"
},
"credentials": {},
"typeVersion": 4.2
},
{
"id": "a6009cf3-afc3-4539-b58f-d8e3138564d5",
"name": "Notion1",
"type": "n8n-nodes-base.notion",
"onError": "continueRegularOutput",
"position": [
1200,
400
],
"parameters": {
"options": {},
"resource": "databasePage",
"databaseId": {
"__rl": true,
"mode": "id",
"value": ""
},
"propertiesUi": {
"propertyValues": [
{
"key": "Campaign Name|title",
"title": "={{ $json.campaign.name }}"
},
{
"key": "Campaign ID|number",
"numberValue": "={{ parseInt($json.campaign.id) }}"
},
{
"key": "Impressions|number",
"numberValue": "={{ parseInt($json.metrics.impressions)}}"
},
{
"key": "Clicks|number",
"numberValue": "={{ parseInt($json.metrics.clicks) }}"
},
{
"key": "Cost|number",
"numberValue": "={{ Math.floor($json.metrics.costMicros / 1000000) }}"
},
{
"key": "Conversion Type|rich_text",
"textContent": "={{ $json.segments.conversionActionName || \"N/A\" }}"
},
{
"key": "Conversions|number",
"numberValue": "={{ Math.round(Number($json.metrics.conversions || 0) * 100) / 100 }}"
},
{
"key": "Date|date",
"date": "={{ $json.segments.date }}"
}
]
}
},
"credentials": {},
"typeVersion": 2.2
},
{
"id": "049a0fc6-bf5b-4c82-96c7-da45563d1017",
"name": "Notion2",
"type": "n8n-nodes-base.notion",
"onError": "continueRegularOutput",
"position": [
1460,
760
],
"parameters": {
"options": {},
"resource": "databasePage",
"databaseId": {
"__rl": true,
"mode": "id",
"value": ""
},
"propertiesUi": {
"propertyValues": [
{
"key": "Tanggal|date",
"date": "={{ $json.date }}"
},
{
"key": "Total Impressions|number",
"numberValue": "={{ $json.total_impressions }}"
},
{
"key": "Total Clicks|number",
"numberValue": "={{ $json.total_clicks }}"
},
{
"key": "Total Conversions|number",
"numberValue": "={{ $json.total_conversions }}"
},
{
"key": "Total Cost|number",
"numberValue": "={{ $json.total_cost }}"
},
{
"key": "Conversion Types|rich_text",
"textContent": "={{ $json.conversion_types }}"
}
]
}
},
"credentials": {},
"typeVersion": 2.2
},
{
"id": "9e331b5a-2162-404c-9918-50b1f8a0c14b",
"name": "Google Sheets10",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
600
],
"parameters": {
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
}
},
"credentials": {},
"typeVersion": 4.5
},
{
"id": "59bd6861-0ceb-42a1-a85d-0d239dc607d5",
"name": "分割点击2",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
660,
400
],
"parameters": {
"jsCode": "return items[0].json.results.map(r => ({ json: r }));\n"
},
"typeVersion": 2
},
{
"id": "154beaed-97e3-42eb-8c36-34487cda7e0c",
"name": "分割转化2",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
660,
600
],
"parameters": {
"jsCode": "return items[0].json.results.map(r => ({ json: r }));"
},
"typeVersion": 2
},
{
"id": "7a981181-0a99-4446-bcc4-042b7b7e9dbe",
"name": "合并2",
"type": "n8n-nodes-base.merge",
"position": [
900,
500
],
"parameters": {
"mode": "combine",
"options": {},
"advanced": true,
"joinMode": "enrichInput1",
"mergeByFields": {
"values": [
{
"field1": "campaign.id",
"field2": "campaign.id"
},
{
"field1": "segments.date",
"field2": "segments.date"
}
]
}
},
"typeVersion": 3.1
},
{
"id": "29a7436f-61e9-42f7-bdfe-7a4b50f45d36",
"name": "每日回顾2",
"type": "n8n-nodes-base.code",
"position": [
1200,
860
],
"parameters": {
"jsCode": "let totalClicks = 0;\nlet totalImpressions = 0;\nlet totalCost = 0;\nlet totalConversions = 0;\nlet conversionTypes = new Set();\nlet date = null;\n\nfor (const item of items) {\n const d = item.json;\n\n totalClicks += parseInt(d.metrics?.clicks || 0);\n totalImpressions += parseInt(d.metrics?.impressions || 0);\n totalCost += parseInt(d.metrics?.costMicros || 0) / 1_000_000;\n totalConversions += parseFloat(d.metrics?.conversions || 0);\n\n const convType = d.segments?.conversionActionName;\n if (convType) conversionTypes.add(convType);\n\n date = d.segments?.date || date;\n}\n\nreturn [\n {\n json: {\n date,\n total_clicks: totalClicks,\n total_impressions: totalImpressions,\n total_cost: Number(totalCost.toFixed(2)),\n total_conversions: Number(totalConversions.toFixed(2)),\n conversion_types: Array.from(conversionTypes).join(', ') || 'N/A'\n }\n }\n];"
},
"typeVersion": 2
},
{
"id": "2708ffda-f942-4e55-990d-baeac0f1d8f3",
"name": "Google Sheets11",
"type": "n8n-nodes-base.googleSheets",
"position": [
1480,
960
],
"parameters": {
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
}
},
"credentials": {},
"typeVersion": 4.5
},
{
"id": "3be681d5-6941-443d-8485-2603107190f4",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1760,
600
],
"parameters": {
"color": 4,
"width": 640,
"height": 460,
"content": ""
},
"typeVersion": 1
},
{
"id": "9be455f9-4fe9-4bdd-882f-4ec4ec212f36",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1000,
0
],
"parameters": {
"color": 3,
"width": 640,
"height": 460,
"content": ""
},
"typeVersion": 1
},
{
"id": "b5865a91-1a2e-43d2-869d-6b321a94abea",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-100
],
"parameters": {
"color": 3,
"width": 640,
"height": 480,
"content": "---"
},
"typeVersion": 1
},
{
"id": "9aeaf3f7-798f-4ca9-b7e1-6ffad5ead9d1",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
620
],
"parameters": {
"width": 640,
"height": 800,
"content": "## 工作原理"
},
"typeVersion": 1
},
{
"id": "c0b96c74-15f6-4cea-8727-e1a9c5c0a9d1",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
500
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "be1b4d73-99b2-4fe6-a1a3-34df0eada594",
"name": "设置昨日日期2",
"type": "n8n-nodes-base.set",
"position": [
180,
500
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bfc7fb43-2b0f-4f44-a239-b35583c4d114",
"name": "=yesterday",
"type": "string",
"value": "={{ $now.minus({ days: 1 }).toFormat('yyyy-MM-dd') }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "79d493b6-2e71-45e7-8c05-a6f20e8b9b55",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
120
],
"parameters": {
"width": 640,
"height": 460,
"content": "## 描述"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge2": {
"main": [
[
{
"node": "Google Sheets10",
"type": "main",
"index": 0
},
{
"node": "Daily Recap2",
"type": "main",
"index": 0
}
]
]
},
"Daily Recap2": {
"main": [
[
{
"node": "Notion2",
"type": "main",
"index": 0
},
{
"node": "Google Sheets11",
"type": "main",
"index": 0
}
]
]
},
"Split Click2": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set Yesterday Date2",
"type": "main",
"index": 0
}
]
]
},
"G-Ads Query Click": {
"main": [
[
{
"node": "Split Click2",
"type": "main",
"index": 0
}
]
]
},
"Split Conversion2": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"Set Yesterday Date2": {
"main": [
[
{
"node": "G-Ads Query Conversion",
"type": "main",
"index": 0
},
{
"node": "G-Ads Query Click",
"type": "main",
"index": 0
}
]
]
},
"G-Ads Query Conversion": {
"main": [
[
{
"node": "Split Conversion2",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用OpenAI、Ahrefs和多平台集成的自动化内容营销智能
使用OpenAI、Ahrefs和多平台集成的自动化内容营销智能
If
Set
Code
+8
21 节点Nikan Noorafkan
市场调研
MetaAds创意洞察研究员v1.4
使用Google Vision和Video Intelligence API分析Meta广告创意
If
Set
Code
+9
32 节点Kirill Khatkevich
市场调研
YouTube评论情感和关键词提取器
使用Gemini AI分析YouTube评论情感和关键词并通过Telegram报告
Set
Code
Telegram
+10
20 节点Budi SJ
市场调研
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
Set
Code
Limit
+9
18 节点Cong Nguyen
市场调研
生成 PDF 报告的 SWOT 分析生成器
使用 OpenAI、Google Sheets 和 APITemplate PDF 导出生成 SWOT 分析报告
Set
Code
Gmail
+10
40 节点Sebastian/OptiLever
市场调研
每周创作者竞品创意到Google Sheets（Firecrawl + AI）
使用GPT4和Gemini监控竞争对手并生成内容创意到Google Sheets
If
Set
Code
+7
22 节点Shelly-Ann
市场调研
工作流信息
难度等级
高级
节点数量19
分类2
节点类型8
作者
Aziz dev
@azizdevI’m a technical automation specialist focused on marketing analytics, reporting workflows, and API integrations. I build reliable n8n workflows to help teams automate daily tasks, centralize campaign data, and reduce manual reporting work.
外部链接
在 n8n.io 查看 →
分享此工作流