将月度CrUX报告从BigQuery自动传输至NocoDB并进行数据清理
中级
这是一个自动化工作流，包含 14 个节点。主要使用 Set, Code, NocoDb, GoogleBigQuery, SplitInBatches 等节点。 自动化月度CrUX报告从BigQuery传输至NocoDB并进行数据清理
前置要求
- •无特殊前置要求，导入即可使用
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "B0aEQAsAIg2pLUfx",
"meta": {
"instanceId": "c24388df44432e8ff2c4acecd7ab0dd2faec628bd83c70beb384cea105f7a50a",
"templateCredsSetupCompleted": true
},
"name": "将月度CrUX报告从BigQuery自动传输至NocoDB并进行数据清理",
"tags": [
{
"id": "RhAmCaLYc9EkF42I",
"name": "n8n",
"createdAt": "2025-08-24T08:04:35.027Z",
"updatedAt": "2025-08-24T08:04:35.027Z"
}
],
"nodes": [
{
"id": "b3ff85fe-b34b-4426-8c0b-83b15d22b6f4",
"name": "Google BigQuery",
"type": "n8n-nodes-base.googleBigQuery",
"position": [
980,
60
],
"parameters": {
"options": {},
"sqlQuery": "SELECT\n origin,\n experimental.popularity.rank AS crux_rank\nFROM\n `chrome-ux-report.all.{{ $json.table }}`\nWHERE\n experimental.popularity.rank IS NOT NULL\nORDER BY\n crux_rank ASC\nLIMIT 10;",
"projectId": {
"__rl": true,
"mode": "list",
"value": "crucial-ray-454512-g1",
"cachedResultUrl": "https://console.cloud.google.com/bigquery?project=crucial-ray-454512-g1",
"cachedResultName": "n8n-test"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "FVkLDtIfwMFJz4Sb",
"name": "bigquery admin - n8n test - nima40"
}
},
"typeVersion": 2.1
},
{
"id": "9072f57b-a4b3-4f2c-912b-cb60450c9cf2",
"name": "获取上月数据",
"type": "n8n-nodes-base.nocoDb",
"position": [
600,
460
],
"parameters": {
"table": "m4fowxbiwoqqj2m",
"options": {},
"operation": "getAll",
"projectId": "p4lnw5vwzf2yy3i",
"returnAll": true,
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "8f293e9a-c763-4e8a-afb3-2350dcfee4f4",
"name": "在NocoDB中删除",
"type": "n8n-nodes-base.nocoDb",
"position": [
1100,
460
],
"parameters": {
"id": "={{ $json.Id }}",
"table": "m4fowxbiwoqqj2m",
"operation": "delete",
"projectId": "p4lnw5vwzf2yy3i",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "66d662f4-46e9-42a6-801e-fff09dd173db",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
840,
460
],
"parameters": {
"options": {},
"batchSize": 100
},
"typeVersion": 3
},
{
"id": "3ddb8941-047f-41ef-83b5-cf7245fba81b",
"name": "将CrUX数据追加至NocoDB",
"type": "n8n-nodes-base.nocoDb",
"position": [
1320,
60
],
"parameters": {
"table": "m4fowxbiwoqqj2m",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "origin",
"fieldValue": "={{ $json.origin }}"
},
{
"fieldName": "crux_rank",
"fieldValue": "={{ $json.crux_rank }}"
}
]
},
"operation": "create",
"projectId": "p4lnw5vwzf2yy3i",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "c3e55cfa-f46e-48f8-9d5c-de83dd57d894",
"name": "将月份名称转换为数字",
"type": "n8n-nodes-base.code",
"position": [
460,
60
],
"parameters": {
"jsCode": "// Get all input items\nconst items = $input.all();\n\nconst monthMap = {\n January: '01',\n February: '02',\n March: '03',\n April: '04',\n May: '05',\n June: '06',\n July: '07',\n August: '08',\n September: '09',\n October: '10',\n November: '11',\n December: '12'\n};\n\nconst output = items.map(item => {\n const monthName = item.json.Month || \"\";\n const formattedName = monthName.trim().charAt(0).toUpperCase() + monthName.trim().slice(1).toLowerCase();\n const monthNumber = monthMap[formattedName] || null;\n\n return {\n json: {\n Month: monthName,\n Month_Number: monthNumber // string like \"01\"\n }\n };\n});\n\nreturn output;"
},
"typeVersion": 2
},
{
"id": "e874c5f0-b894-4fc2-a81d-46b49247a6a8",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
720,
60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "e8ea6d77-9952-4d86-9042-fd38f53fac71",
"name": "table",
"type": "string",
"value": "={{ $('Monthly Trigger2').item.json.Year }}{{ $json.Month_Number }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0cf7f728-87aa-411e-b2bb-174ae10c06eb",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
-300
],
"parameters": {
"color": 5,
"width": 280,
"height": 540,
"content": "此节点将**公历月份名称**转换为数字："
},
"typeVersion": 1
},
{
"id": "07188746-d762-467e-b40c-773bb865f903",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
-300
],
"parameters": {
"color": 5,
"width": 280,
"height": 540,
"content": "## **Google BigQuery**"
},
"typeVersion": 1
},
{
"id": "3b463b1c-1d3a-4868-8944-6552dcaa725a",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
340
],
"parameters": {
"color": 5,
"width": 1160,
"height": 320,
"content": "## **删除上月数据**"
},
"typeVersion": 1
},
{
"id": "225a6af1-8761-41d5-b328-805a5abd473a",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-300
],
"parameters": {
"color": 5,
"width": 280,
"height": 540,
"content": "## Monthly Trigger2"
},
"typeVersion": 1
},
{
"id": "60266227-51f4-4076-aa10-265a1a13cf3f",
"name": "Monthly Trigger1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
340,
460
],
"parameters": {
"rule": {
"interval": [
{
"field": "months",
"triggerAtHour": 1
}
]
}
},
"typeVersion": 1.2
},
{
"id": "57deaa20-2727-4bcc-b8e6-cb31931223f0",
"name": "Monthly Trigger2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
120,
60
],
"parameters": {
"rule": {
"interval": [
{
"field": "months",
"triggerAtHour": 12
}
]
}
},
"typeVersion": 1.2
},
{
"id": "87a6421a-51e6-4d95-af2e-6a0dcf107c2a",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1220,
-300
],
"parameters": {
"color": 5,
"width": 300,
"height": 540,
"content": "## 将CrUX数据追加至NocoDB"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Google BigQuery": [
{
"json": {
"origin": "https://www.epfindia.gov.in",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://mail.yahoo.com",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://tw.stock.yahoo.com",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://www.epfindia.gov.in",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://triunfobet.com",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://tw.stock.yahoo.com",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://tw.stock.yahoo.com",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://mail.yahoo.com",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://homepage.vivo.com",
"crux_rank": "1000"
}
},
{
"json": {
"origin": "https://triunfobet.com",
"crux_rank": "1000"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "88273070-007c-4f34-92e5-2360b84603c7",
"connections": {
"Edit Fields": {
"main": [
[
{
"node": "Google BigQuery",
"type": "main",
"index": 0
}
]
]
},
"Google BigQuery": {
"main": [
[
{
"node": "Append Crux Data into NocoDB",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Delete in NocoDB",
"type": "main",
"index": 0
}
]
]
},
"Delete in NocoDB": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Monthly Trigger1": {
"main": [
[
{
"node": "Get Last Month Data",
"type": "main",
"index": 0
}
]
]
},
"Monthly Trigger2": {
"main": [
[
{
"node": "Convert month name to number",
"type": "main",
"index": 0
}
]
]
},
"Get Last Month Data": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Convert month name to number": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
将 Brevo 联系人报告插入 NocoDB
将 Brevo 联系人报告插入 NocoDB
If
Set
Code
+8
26 节点Nima Salimi
内容创作
营销自动化系统 (eCRM) - NocoDB 与 Brevo
使用 NocoDB 和 Brevo 实现邮件营销活动自动化
If
Set
Wait
+6
30 节点Nima Salimi
社交媒体
每日从NocoDB导入新联系人到Brevo
每日从NocoDB导入已验证联系人到Brevo
If
Noco Db
Send In Blue
+3
16 节点Nima Salimi
社交媒体
使用 Google Sheets 查询每日监控排名
使用 DataForSEO 和 Google Sheets 跟踪每日 SEO 排名
Set
Code
Split Out
+4
12 节点Nima Salimi
市场调研
自动邮件退订处理：Outlook与BigQuery集成
自动邮件退订处理：Outlook与BigQuery集成
Set
Code
Merge
+7
15 节点Robert Breen
社交媒体
公司邮箱查找器新版本
使用 Serper.dev 和 AnyMailFinder 查找 B2B 决策者邮箱并构建潜在客户数据库
If
Set
Code
+11
33 节点Alexandra Spalato
AI 摘要总结
工作流信息
难度等级
中级
节点数量14
分类-
节点类型7
作者
Nima Salimi
@salimi- Marketing Automation Specialist - Marketing Workflow Architect - Optimizing Marketing Processes
外部链接
在 n8n.io 查看 →
分享此工作流