自动将Google Search Console数据导出到Airtable
高级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 21 个节点。主要使用 Set, Airtable, SplitOut, HttpRequest, ScheduleTrigger 等节点。 自动将Google Search Console数据导出到Airtable
前置要求
- •Airtable API Key
- •可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "AJCFkuIkFN45QXA4",
"meta": {
"instanceId": "18b0d04ad5030054be4ab49562e84ea4a079ab4cb036003697394140227c7e76",
"templateId": "2613",
"templateCredsSetupCompleted": true
},
"name": "自动将 Google Search Console 数据导出到 Airtable",
"tags": [],
"nodes": [
{
"id": "8e3f167d-cbeb-4f7f-a867-c356d2dca9d0",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
1968,
416
],
"parameters": {
"options": {},
"fieldToSplitOut": "rows"
},
"typeVersion": 1
},
{
"id": "19370d12-f6de-44a1-91a6-da097abdf7de",
"name": "获取简报",
"type": "n8n-nodes-base.set",
"position": [
2192,
416
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7343c80f-37f3-4bb5-84d8-9f21f8a350cd",
"name": "Keyword",
"type": "string",
"value": "={{ $json.keys[0] }}"
},
{
"id": "436e7c8b-2df2-40a9-97af-597dc00cf143",
"name": "clicks",
"type": "number",
"value": "={{ $json.clicks }}"
},
{
"id": "5b4aaffe-391a-4c9d-8249-f447397a3f5d",
"name": "impressions",
"type": "number",
"value": "={{ $json.impressions }}"
},
{
"id": "33677237-57fe-48f4-aff8-72ae81b5f5a2",
"name": "ctr",
"type": "number",
"value": "={{ $json.ctr }}"
},
{
"id": "f961deee-d222-4df7-a7ff-b7286405e4a7",
"name": "position",
"type": "number",
"value": "={{ $json.position }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9eae4908-5266-439c-a66b-5679036234de",
"name": "拆分输出1",
"type": "n8n-nodes-base.splitOut",
"position": [
1968,
544
],
"parameters": {
"options": {},
"fieldToSplitOut": "rows"
},
"typeVersion": 1
},
{
"id": "b05926b1-507f-4531-a05c-a15e835ee82e",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
2192,
544
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7343c80f-37f3-4bb5-84d8-9f21f8a350cd",
"name": "page",
"type": "string",
"value": "={{ $json.keys[0] }}"
},
{
"id": "436e7c8b-2df2-40a9-97af-597dc00cf143",
"name": "clicks",
"type": "number",
"value": "={{ $json.clicks }}"
},
{
"id": "5b4aaffe-391a-4c9d-8249-f447397a3f5d",
"name": "impressions",
"type": "number",
"value": "={{ $json.impressions }}"
},
{
"id": "33677237-57fe-48f4-aff8-72ae81b5f5a2",
"name": "ctr",
"type": "number",
"value": "={{ $json.ctr }}"
},
{
"id": "f961deee-d222-4df7-a7ff-b7286405e4a7",
"name": "position",
"type": "number",
"value": "={{ $json.position }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "42321587-2565-4a0a-9d9d-25cbfdeb9f49",
"name": "分割输出2",
"type": "n8n-nodes-base.splitOut",
"position": [
1968,
672
],
"parameters": {
"options": {},
"fieldToSplitOut": "rows"
},
"typeVersion": 1
},
{
"id": "9e25eef9-daa4-47dd-b2cf-03cfebadb5c6",
"name": "编辑字段2",
"type": "n8n-nodes-base.set",
"position": [
2192,
672
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7343c80f-37f3-4bb5-84d8-9f21f8a350cd",
"name": "date",
"type": "string",
"value": "={{ $json.keys[0] }}"
},
{
"id": "436e7c8b-2df2-40a9-97af-597dc00cf143",
"name": "clicks",
"type": "number",
"value": "={{ $json.clicks }}"
},
{
"id": "5b4aaffe-391a-4c9d-8249-f447397a3f5d",
"name": "impressions",
"type": "number",
"value": "={{ $json.impressions }}"
},
{
"id": "33677237-57fe-48f4-aff8-72ae81b5f5a2",
"name": "ctr",
"type": "number",
"value": "={{ $json.ctr }}"
},
{
"id": "f961deee-d222-4df7-a7ff-b7286405e4a7",
"name": "position",
"type": "number",
"value": "={{ $json.position }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e8f1ab65-9594-45e7-ba9e-7873bd53a107",
"name": "日期",
"type": "n8n-nodes-base.httpRequest",
"position": [
1744,
672
],
"parameters": {
"url": "=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"startDate\": \"{{ $now.format('yyyy-MM-dd') }}\",\n \"endDate\": \"{{ $now.minus($json.days, 'days').format('yyyy-MM-dd') }}\",\n \"dimensions\": [\"date\"]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"googleOAuth2Api": {
"id": "rgqJrGcq1fg3mqLm",
"name": "Google account"
}
},
"typeVersion": 4.2
},
{
"id": "d3bbf719-9524-4269-8c26-0eb7599add55",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1072,
608
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "092645b2-9e75-4ff0-8d33-4a3acadac789",
"name": "设置您的域名",
"type": "n8n-nodes-base.set",
"position": [
1360,
608
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "6f74dee0-3789-433e-b60e-ed2a05202675",
"name": "domain",
"type": "string",
"value": "funautomations.io"
},
{
"id": "8c73135e-9d39-4f66-821d-7decb3c64085",
"name": "days",
"type": "number",
"value": 30
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0b04b552-e484-417b-9a7e-a90d477dd45a",
"name": "获取查询报告",
"type": "n8n-nodes-base.httpRequest",
"position": [
1744,
416
],
"parameters": {
"url": "=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"startDate\": \"{{ $now.format('yyyy-MM-dd') }}\",\n \"endDate\": \"{{ $now.minus($json.days, 'days').format('yyyy-MM-dd') }}\",\n \"dimensions\": [\"query\"]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"googleOAuth2Api": {
"id": "rgqJrGcq1fg3mqLm",
"name": "Google account"
}
},
"typeVersion": 4.2
},
{
"id": "9f9f2be7-1301-4c91-8da1-86eab5725683",
"name": "获取页面报告",
"type": "n8n-nodes-base.httpRequest",
"position": [
1744,
544
],
"parameters": {
"url": "=https://www.googleapis.com/webmasters/v3/sites/sc-domain:{{$json.domain}}/searchAnalytics/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"startDate\": \"{{ $now.format('yyyy-MM-dd') }}\",\n \"endDate\": \"{{ $now.minus($json.days, 'days').format('yyyy-MM-dd') }}\",\n \"dimensions\": [\"page\"]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"googleOAuth2Api": {
"id": "rgqJrGcq1fg3mqLm",
"name": "Google account"
}
},
"typeVersion": 4.2
},
{
"id": "d2b91103-2fb1-429c-9d90-50f92f3d6a42",
"name": "创建记录",
"type": "n8n-nodes-base.airtable",
"position": [
2512,
416
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appzCPTyUrpA1fXpf",
"cachedResultUrl": "https://airtable.com/appzCPTyUrpA1fXpf",
"cachedResultName": "Search Console Reports"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblK0ZkihGpOc7ADu",
"cachedResultUrl": "https://airtable.com/appzCPTyUrpA1fXpf/tblK0ZkihGpOc7ADu",
"cachedResultName": "Queries"
},
"columns": {
"value": {
"ctr": "={{ $json.ctr }}",
"clicks": "={{ $json.clicks }}",
"Keyword": "={{ $json.Keyword }}",
"position": "={{ $json.position }}",
"impressions": "={{ $json.impressions }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "clicks",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "impressions",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "impressions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ctr",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ctr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "vKZ5Wl43rmNFe0My",
"name": "Airtable Personal Access Token account 3"
}
},
"typeVersion": 2.1
},
{
"id": "7ea7d226-ba6c-4f08-b6f6-fda31185cbbb",
"name": "创建记录1",
"type": "n8n-nodes-base.airtable",
"position": [
2512,
544
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appzCPTyUrpA1fXpf",
"cachedResultUrl": "https://airtable.com/appzCPTyUrpA1fXpf",
"cachedResultName": "Search Console Reports"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblA6tGocjen8W0iN",
"cachedResultUrl": "https://airtable.com/appzCPTyUrpA1fXpf/tblA6tGocjen8W0iN",
"cachedResultName": "Pages"
},
"columns": {
"value": {
"ctr": "={{ $json.ctr }}",
"page": "={{ $json.keys[0] }}",
"clicks": "={{ $json.clicks }}",
"position": "={{ $json.position }}",
"impressions": "={{ $json.impressions }}"
},
"schema": [
{
"id": "page",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "page",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "clicks",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "impressions",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "impressions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ctr",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ctr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "vKZ5Wl43rmNFe0My",
"name": "Airtable Personal Access Token account 3"
}
},
"typeVersion": 2.1
},
{
"id": "fe31cb29-ae45-4fb0-a39e-c8fe337b4984",
"name": "创建记录2",
"type": "n8n-nodes-base.airtable",
"position": [
2512,
672
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appzCPTyUrpA1fXpf",
"cachedResultUrl": "https://airtable.com/appzCPTyUrpA1fXpf",
"cachedResultName": "Search Console Reports"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblSJx4WuIm3feGGw",
"cachedResultUrl": "https://airtable.com/appzCPTyUrpA1fXpf/tblSJx4WuIm3feGGw",
"cachedResultName": "Dates"
},
"columns": {
"value": {
"ctr": "={{ $json.ctr }}",
"date": "={{ $json.keys[0] }}",
"clicks": "={{ $json.clicks }}",
"position": "={{ $json.position }}",
"impressions": "={{ $json.impressions }}"
},
"schema": [
{
"id": "date",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "clicks",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "impressions",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "impressions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ctr",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ctr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "vKZ5Wl43rmNFe0My",
"name": "Airtable Personal Access Token account 3"
}
},
"typeVersion": 2.1
},
{
"id": "e86d0696-7d10-4a76-8ba7-953862d65b1d",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-432
],
"parameters": {
"width": 544,
"height": 1216,
"content": "# 自动将 Google Search Console 数据导出到 Airtable"
},
"typeVersion": 1
},
{
"id": "4eb3576c-7590-4d30-857b-da1632fcd074",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1024,
96
],
"parameters": {
"height": 688,
"content": "## 步骤 1：安排工作流计划"
},
"typeVersion": 1
},
{
"id": "38400f18-ed3e-4f39-8424-77a631437b89",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
96
],
"parameters": {
"height": 688,
"content": "## 步骤 2：设置您的域名和时间范围"
},
"typeVersion": 1
},
{
"id": "0f72bcf5-f4c3-4617-9835-07163ebc381b",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1504,
-272
],
"parameters": {
"width": 400,
"height": 1056,
"content": "## 步骤 3：从 Google Search Console 获取数据"
},
"typeVersion": 1
},
{
"id": "3b260edd-5a2f-4818-9ab9-40db86ad3e96",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1904,
-272
],
"parameters": {
"width": 208,
"height": 1056,
"content": "## 步骤 4：拆分数据"
},
"typeVersion": 1
},
{
"id": "f4834663-b817-41b0-82fe-9a1624908979",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2112,
-272
],
"parameters": {
"width": 208,
"height": 1056,
"content": "## 步骤 5：清理和重命名字段"
},
"typeVersion": 1
},
{
"id": "1c81b533-fecf-485f-9269-73fe2975f25d",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2320,
-704
],
"parameters": {
"width": 464,
"height": 1488,
"content": "## 步骤 6：将所有内容保存到 Airtable"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {},
"versionId": "3f8ec591-388b-45a3-afab-829b086b8fe2",
"connections": {
"date": {
"main": [
[
{
"node": "Split Out2",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Split Out1": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Split Out2": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Create a record",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Create a record1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Create a record2",
"type": "main",
"index": 0
}
]
]
},
"Get Page Report": {
"main": [
[
{
"node": "Split Out1",
"type": "main",
"index": 0
}
]
]
},
"Set your domain": {
"main": [
[
{
"node": "Get query Report",
"type": "main",
"index": 0
},
{
"node": "Get Page Report",
"type": "main",
"index": 0
},
{
"node": "date",
"type": "main",
"index": 0
}
]
]
},
"Get query Report": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set your domain",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动化每日股市报告
使用 Bright Data、GPT-4.1、Airtable 和 Gmail 的自动化每日股市报告
Set
Wait
Switch
+10
27 节点Baptiste Fort
内容创作
MetaAds创意洞察研究员v1.4
使用Google Vision和Video Intelligence API分析Meta广告创意
If
Set
Code
+9
32 节点Kirill Khatkevich
市场调研
使用OpenAI、Ahrefs和多平台集成的自动化内容营销智能
使用OpenAI、Ahrefs和多平台集成的自动化内容营销智能
If
Set
Code
+8
21 节点Nikan Noorafkan
市场调研
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
Set
Code
Limit
+9
18 节点Cong Nguyen
市场调研
Google Maps 潜在客户：姓名、邮箱、电话，使用 Apify + Airtable + 个性化邮件
使用 Apify 和 Airtable 抓取 Google Maps 企业潜在客户并发送个性化邮件
Set
Wait
Gmail
+4
13 节点Baptiste Fort
潜在客户开发
基于AI的新闻监控（Linkup、Airtable和Slack通知）
基于AI的新闻监控（Linkup、Airtable和Slack通知）
Set
Wait
Slack
+7
16 节点Guillaume Duvernay
市场调研
