Google Search Console和Analytics分析与AI优化
高级
这是一个AI领域的自动化工作流，包含 29 个节点。主要使用 Set, Xml, Html, Sort, Wait 等节点，结合人工智能技术实现智能自动化。 Google Search Console和Analytics数据分析与AI优化
前置要求
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
使用的节点 (29)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "Q0fs6FhvxUSO5kL4",
"meta": {
"instanceId": "bdce9ec27bbe2b742054f01d034b8b468d2e7758edd716403ad5bd4583a8f649",
"templateCredsSetupCompleted": true
},
"name": "Google Search Console 和 Analytics 分析与 AI 优化",
"tags": [],
"nodes": [
{
"id": "4a4b478e-b5f8-4ddc-a6cc-48f1274cb5d6",
"name": "点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-300,
-300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b52900dd-a2bd-42bb-8e1d-ce3cff259ec7",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
40,
580
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "1ebe691b-6b76-4956-b181-c2be251d48be",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
480
],
"parameters": {
"width": 1620,
"height": 640,
"content": "## 获取 Google 数据并通过 AI 处理"
},
"typeVersion": 1
},
{
"id": "7194a576-50ab-4df0-b6db-d6a74bcbb927",
"name": "强制执行顺序 - 最后处理位置",
"type": "n8n-nodes-base.merge",
"position": [
280,
260
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "be892b2b-6141-415c-a503-d4f7d467cc6a",
"name": "移除重复项",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
940,
-60
],
"parameters": {
"compare": "selectedFields",
"options": {},
"fieldsToCompare": "loc"
},
"typeVersion": 2
},
{
"id": "ebb767ad-a8db-449a-8d52-56731248e9e5",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-140
],
"parameters": {
"width": 880,
"height": 320,
"content": "## 从站点地图获取所有页面"
},
"typeVersion": 1
},
{
"id": "d421db5a-c224-44ef-a471-d64ca8ddaa69",
"name": "获取站点地图 XML",
"type": "n8n-nodes-base.httpRequest",
"position": [
280,
-60
],
"parameters": {
"url": "={{ $('Globals - CHANGE ME!').item.json.sitemap_url }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "6bf0e08e-1cfa-4484-b953-cd215447d053",
"name": "转换为 JSON",
"type": "n8n-nodes-base.xml",
"position": [
500,
-60
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "b5ab24fc-8c0f-4158-9452-35fc682246ff",
"name": "拆分到表格",
"type": "n8n-nodes-base.splitOut",
"position": [
720,
-60
],
"parameters": {
"options": {},
"fieldToSplitOut": "urlset.url"
},
"typeVersion": 1
},
{
"id": "81c644b2-1de8-4f51-be73-ac2246fb3c5f",
"name": "用于测试的限制",
"type": "n8n-nodes-base.limit",
"position": [
1400,
-60
],
"parameters": {
"maxItems": 5
},
"typeVersion": 1
},
{
"id": "77c271b5-99b9-4adf-8b7f-7dc0846325bd",
"name": "等待以遵守 API 限制",
"type": "n8n-nodes-base.wait",
"position": [
900,
500
],
"webhookId": "51b5aeba-6be7-45d4-97fd-4e5cb5a8401b",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "00b83323-17ef-44a1-82b1-eb867e532556",
"name": "全局变量 - 请修改我！",
"type": "n8n-nodes-base.set",
"position": [
40,
-60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "be81885f-3f27-4edd-985d-8dd98908a197",
"name": "sitemap_url",
"type": "string",
"value": "https://sailingbyte.com/sitemap.xml"
},
{
"id": "c1f4c9ba-9222-4757-a89e-0d67af1d3944",
"name": "search_console_selector",
"type": "string",
"value": "sc-domain:example.com"
},
{
"id": "9c57f9cc-1e94-4174-b622-7533c7776bee",
"name": "analysis_start_date",
"type": "string",
"value": "={{ $now.minus(30,'days').format('yyyy-MM-dd') }}"
},
{
"id": "51dd8171-2300-4574-9c71-56793127bf4a",
"name": "analysis_end_date",
"type": "string",
"value": "={{ $now.format('yyyy-MM-dd') }}"
},
{
"id": "5e09cf25-80d9-44fe-9cf3-e2517bcfc6e6",
"name": "analytics_selector_id",
"type": "number",
"value": 0
},
{
"id": "5befd844-afe6-44c9-8ecd-c2741d838b19",
"name": "report_receiver",
"type": "string",
"value": "email@eamil.com"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "cde1f4e7-f45d-4c64-906e-3b191550fc9a",
"name": "获取页面 GSC 状态",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
280,
560
],
"parameters": {
"url": "https://searchconsole.googleapis.com/v1/urlInspection/index:inspect",
"method": "POST",
"options": {},
"sendQuery": true,
"authentication": "predefinedCredentialType",
"queryParameters": {
"parameters": [
{
"name": "inspectionUrl",
"value": "={{ $json.loc }}"
},
{
"name": "siteUrl",
"value": "={{ $('Globals - CHANGE ME!').first().json.search_console_selector }}"
}
]
},
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"googleOAuth2Api": {
"id": "wWLEdLgRqrkoJMke",
"name": "Google account"
}
},
"retryOnFail": true,
"typeVersion": 4.2,
"waitBetweenTries": 5000
},
{
"id": "c4856013-3111-4c04-b4d2-f92ad8f1cd88",
"name": "获取页面 GSC 统计信息",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
280,
740
],
"parameters": {
"url": "=https://www.googleapis.com/webmasters/v3/sites/{{ $('Globals - CHANGE ME!').first().json.search_console_selector }}/searchAnalytics/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"startDate\": \"{{ $('Globals - CHANGE ME!').first().json.analysis_start_date }}\",\n \"endDate\": \"{{ $('Globals - CHANGE ME!').first().json.analysis_end_date }}\",\n \"type\": \"web\",\n \"dimensionFilterGroups\": [\n {\n \"groupType\": \"AND\",\n \"filters\": [\n {\n \"dimension\": \"page\",\n \"operator\": \"contains\",\n \"expression\": \"{{ $json.loc }}\"\n }\n ]\n }\n ]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "googleOAuth2Api"
},
"credentials": {
"googleOAuth2Api": {
"id": "wWLEdLgRqrkoJMke",
"name": "Google account"
}
},
"retryOnFail": true,
"typeVersion": 4.2,
"waitBetweenTries": 5000
},
{
"id": "b5e8f02d-320c-4fab-9e38-2a6dbb97e7b1",
"name": "合并状态和统计信息",
"type": "n8n-nodes-base.merge",
"position": [
540,
680
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition",
"numberInputs": 3
},
"typeVersion": 3.2
},
{
"id": "c7ff4009-65be-4d4a-b3dd-f711e7cefebb",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
660,
880
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "o4-mini",
"cachedResultName": "o4-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "zjIZQuuuZMJpiUny",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "133cbc78-a835-4d6c-a366-187d3f2ca4b1",
"name": "获取 Google Analytics 数据",
"type": "n8n-nodes-base.googleAnalytics",
"position": [
280,
920
],
"parameters": {
"endDate": "={{ $('Globals - CHANGE ME!').first().json.analysis_end_date }}",
"dateRange": "custom",
"returnAll": true,
"startDate": "={{ $('Globals - CHANGE ME!').first().json.analysis_start_date }}",
"metricsGA4": {
"metricValues": [
{},
{
"listName": "screenPageViews"
},
{
"listName": "userEngagementDuration"
}
]
},
"propertyId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Globals - CHANGE ME!').first().json.analytics_selector_id }}"
},
"dimensionsGA4": {
"dimensionValues": [
{
"listName": "pageLocation"
}
]
},
"additionalFields": {
"dimensionFiltersUI": {
"filterExpressions": {
"expression": {
"stringFilter": [
{
"value": "={{ $json.loc }}",
"listName": "pageLocation",
"caseSensitive": false
}
]
}
}
}
}
},
"credentials": {
"googleAnalyticsOAuth2": {
"id": "4JVj7vMgAo09ILvS",
"name": "Google Analytics account"
}
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "fc55254f-012b-4387-af4c-54211b386182",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
940,
880
],
"parameters": {
"url": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('URL', ``, 'string') }}",
"options": {},
"toolDescription": "Make HTTP request to get page data so you can further analyze page for SEO optimizations"
},
"typeVersion": 4.2
},
{
"id": "3658c627-a22b-4f4c-b2ee-33e9a361bb1e",
"name": "将 AI 输出与 AI 输入合并",
"type": "n8n-nodes-base.merge",
"position": [
1400,
900
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "b92d08c4-13a3-4c92-b37f-da3a7a5ee7dc",
"name": "Markdown 转 HTML",
"type": "n8n-nodes-base.markdown",
"position": [
1120,
900
],
"parameters": {
"mode": "markdownToHtml",
"options": {},
"markdown": "={{ $json.output }}",
"destinationKey": "output"
},
"typeVersion": 1
},
{
"id": "a77ef66d-1313-43ee-b23f-c23a24529026",
"name": "仅保留有价值的列",
"type": "n8n-nodes-base.set",
"position": [
500,
260
],
"parameters": {
"options": {
"dotNotation": false,
"ignoreConversionErrors": true
},
"assignments": {
"assignments": [
{
"id": "6a86e547-b789-4319-886f-b06120967d64",
"name": "loc",
"type": "string",
"value": "={{ $json.loc }}"
},
{
"id": "8ba00cd3-e45a-439f-b703-8a42dd0628fa",
"name": "inspectionResult.indexStatusResult.coverageState",
"type": "string",
"value": "={{ $json.inspectionResult.indexStatusResult.coverageState }}"
},
{
"id": "b83dc435-cbb1-4dc3-8c7e-3af41201dbfe",
"name": "output",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "fad58242-29c7-4c48-ae3f-667559cfd644",
"name": "更改为 HTML 表格以便发送",
"type": "n8n-nodes-base.html",
"position": [
720,
260
],
"parameters": {
"options": {},
"operation": "convertToHtmlTable"
},
"typeVersion": 1.2
},
{
"id": "3d737f97-9d5c-4f0c-8a2a-cbe98e0879d2",
"name": "发送包含完整报告的电子邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
940,
260
],
"webhookId": "843191c3-c853-43c1-9523-4661654fb58e",
"parameters": {
"html": "=<h2>Analysis is complete</h2>\n{{ $json.table }}\n\n",
"options": {},
"subject": "Your Analysis Is Complete",
"toEmail": "={{ $('Globals - CHANGE ME!').first().json['report_receiver'] }}",
"fromEmail": "={{ $('Globals - CHANGE ME!').first().json['report_receiver'] }}"
},
"credentials": {
"smtp": {
"id": "tkdzDgcUAt04af3B",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "8888143f-73ed-4ac7-84ee-b5b4bcf64c6e",
"name": "为测试目的排序",
"type": "n8n-nodes-base.sort",
"position": [
1180,
-60
],
"parameters": {
"type": "random"
},
"typeVersion": 1
},
{
"id": "fd4431b6-8a0a-4a2b-a70b-17d3fc2f34b5",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1140,
-140
],
"parameters": {
"color": 6,
"width": 440,
"height": 320,
"content": "## 用于测试的限制"
},
"typeVersion": 1
},
{
"id": "b821114e-234c-4183-a957-d5048f366ecd",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
-140
],
"parameters": {
"color": 4,
"height": 320,
"content": "## 首先设置我"
},
"typeVersion": 1
},
{
"id": "2e0a5df7-7dd1-4ca7-b9e7-763928b32913",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
200
],
"parameters": {
"color": 3,
"width": 1340,
"height": 260,
"content": "## 获取电子邮件报告"
},
"typeVersion": 1
},
{
"id": "a16024d1-28a1-4b73-85b7-fc15e9620184",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
-140
],
"parameters": {
"color": 4,
"width": 380,
"height": 320,
"content": "- sitemap_url - 不言自明"
},
"typeVersion": 1
},
{
"id": "cd5d0d57-f04a-4094-8f26-855dd1051589",
"name": "SEO 分析师",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
780,
680
],
"parameters": {
"text": "=You are professional SEO analyst and improver. You will receive in input data from Google Analytics and Google Search Console. Delivered data will be for single page.\n\nBased on this data, your task is to propose improvements, that are very specific to this page, and which will impact this web page positively. \n\nGeneral Data Evaluation:\n- How to get more users on this specific page\n- How to engage users more on this specific page\n- Analyze page itself for improvements\n- Look for potential issues in Google Analytics and Google Search Console data\n- Look for potential issues on website itself\n\nTechnical Evaluation:\n- Critical Fixes – Issues requiring immediate attention and resolution.\n- High-Impact Solutions – Simple adjustments that deliver significant results.\n- Enhancement Possibilities – Initiatives demanding greater investment but providing valuable long-term gains.\n\nContent Evaluation:\n- Keyword Strategy Assessment – Determine core and supporting search terms, evaluate keyword concentration levels, and examine strategic keyword positioning throughout the content.\n- Content Quality Review – Analyze the material's comprehensiveness, precision, and alignment with intended audience needs and expectations.\n- Accessibility and Clarity Analysis – Measure content comprehension difficulty through established readability frameworks including Flesch-Kincaid educational level, Flesch Reading Ease score, and Gunning-Fog complexity index.\n\nYou can add other improvement ideas, but they must be very specific to given page, no generalizations.\n\nWebsite is: {{ $json.pageLocation }}\n\nGoogle Analytics data is:\n- total users: {{ $json.totalUsers ?? 0}}\n- screen page views: {{ $json.screenPageViews ?? 0 }}\n- user engagement duration: {{ $json.userEngagementDuration ?? 0 }}\n\nGoogle Search Console data is:\n{{ $json.rows[0].toJsonString() }}\n\nIndexing status is as follows:\n{{ $json.inspectionResult.toJsonString() }}",
"options": {},
"promptType": "define"
},
"typeVersion": 2
}
],
"active": false,
"pinData": {},
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "5",
"executionOrder": "v1",
"saveManualExecutions": true,
"saveDataSuccessExecution": "all"
},
"versionId": "dc23ed85-f60d-4a41-b7c1-19cd5ac272b4",
"connections": {
"cd5d0d57-f04a-4094-8f26-855dd1051589": {
"main": [
[
{
"node": "b92d08c4-13a3-4c92-b37f-da3a7a5ee7dc",
"type": "main",
"index": 0
}
]
]
},
"fc55254f-012b-4387-af4c-54211b386182": {
"ai_tool": [
[
{
"node": "cd5d0d57-f04a-4094-8f26-855dd1051589",
"type": "ai_tool",
"index": 0
}
]
]
},
"6bf0e08e-1cfa-4484-b953-cd215447d053": {
"main": [
[
{
"node": "b5ab24fc-8c0f-4158-9452-35fc682246ff",
"type": "main",
"index": 0
}
]
]
},
"d421db5a-c224-44ef-a471-d64ca8ddaa69": {
"main": [
[
{
"node": "6bf0e08e-1cfa-4484-b953-cd215447d053",
"type": "main",
"index": 0
}
]
]
},
"b52900dd-a2bd-42bb-8e1d-ce3cff259ec7": {
"main": [
[
{
"node": "7194a576-50ab-4df0-b6db-d6a74bcbb927",
"type": "main",
"index": 1
}
],
[
{
"node": "cde1f4e7-f45d-4c64-906e-3b191550fc9a",
"type": "main",
"index": 0
},
{
"node": "c4856013-3111-4c04-b4d2-f92ad8f1cd88",
"type": "main",
"index": 0
},
{
"node": "133cbc78-a835-4d6c-a366-187d3f2ca4b1",
"type": "main",
"index": 0
}
]
]
},
"b92d08c4-13a3-4c92-b37f-da3a7a5ee7dc": {
"main": [
[
{
"node": "3658c627-a22b-4f4c-b2ee-33e9a361bb1e",
"type": "main",
"index": 1
}
]
]
},
"c7ff4009-65be-4d4a-b3dd-f711e7cefebb": {
"ai_languageModel": [
[
{
"node": "cd5d0d57-f04a-4094-8f26-855dd1051589",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"be892b2b-6141-415c-a503-d4f7d467cc6a": {
"main": [
[
{
"node": "8888143f-73ed-4ac7-84ee-b5b4bcf64c6e",
"type": "main",
"index": 0
}
]
]
},
"c4856013-3111-4c04-b4d2-f92ad8f1cd88": {
"main": [
[
{
"node": "b5e8f02d-320c-4fab-9e38-2a6dbb97e7b1",
"type": "main",
"index": 1
}
]
]
},
"b5ab24fc-8c0f-4158-9452-35fc682246ff": {
"main": [
[
{
"node": "be892b2b-6141-415c-a503-d4f7d467cc6a",
"type": "main",
"index": 0
}
]
]
},
"cde1f4e7-f45d-4c64-906e-3b191550fc9a": {
"main": [
[
{
"node": "b5e8f02d-320c-4fab-9e38-2a6dbb97e7b1",
"type": "main",
"index": 0
}
]
]
},
"00b83323-17ef-44a1-82b1-eb867e532556": {
"main": [
[
{
"node": "d421db5a-c224-44ef-a471-d64ca8ddaa69",
"type": "main",
"index": 0
}
]
]
},
"b5e8f02d-320c-4fab-9e38-2a6dbb97e7b1": {
"main": [
[
{
"node": "cd5d0d57-f04a-4094-8f26-855dd1051589",
"type": "main",
"index": 0
},
{
"node": "77c271b5-99b9-4adf-8b7f-7dc0846325bd",
"type": "main",
"index": 0
}
]
]
},
"133cbc78-a835-4d6c-a366-187d3f2ca4b1": {
"main": [
[
{
"node": "b5e8f02d-320c-4fab-9e38-2a6dbb97e7b1",
"type": "main",
"index": 2
}
]
]
},
"8888143f-73ed-4ac7-84ee-b5b4bcf64c6e": {
"main": [
[
{
"node": "81c644b2-1de8-4f51-be73-ac2246fb3c5f",
"type": "main",
"index": 0
}
]
]
},
"a77ef66d-1313-43ee-b23f-c23a24529026": {
"main": [
[
{
"node": "fad58242-29c7-4c48-ae3f-667559cfd644",
"type": "main",
"index": 0
}
]
]
},
"81c644b2-1de8-4f51-be73-ac2246fb3c5f": {
"main": [
[
{
"node": "7194a576-50ab-4df0-b6db-d6a74bcbb927",
"type": "main",
"index": 0
},
{
"node": "b52900dd-a2bd-42bb-8e1d-ce3cff259ec7",
"type": "main",
"index": 0
}
]
]
},
"3658c627-a22b-4f4c-b2ee-33e9a361bb1e": {
"main": [
[
{
"node": "b52900dd-a2bd-42bb-8e1d-ce3cff259ec7",
"type": "main",
"index": 0
}
]
]
},
"7194a576-50ab-4df0-b6db-d6a74bcbb927": {
"main": [
[
{
"node": "a77ef66d-1313-43ee-b23f-c23a24529026",
"type": "main",
"index": 0
}
]
]
},
"77c271b5-99b9-4adf-8b7f-7dc0846325bd": {
"main": [
[
{
"node": "3658c627-a22b-4f4c-b2ee-33e9a361bb1e",
"type": "main",
"index": 0
}
]
]
},
"fad58242-29c7-4c48-ae3f-667559cfd644": {
"main": [
[
{
"node": "3d737f97-9d5c-4f0c-8a2a-cbe98e0879d2",
"type": "main",
"index": 0
}
]
]
},
"4a4b478e-b5f8-4ddc-a6cc-48f1274cb5d6": {
"main": [
[
{
"node": "00b83323-17ef-44a1-82b1-eb867e532556",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+
If
Ftp
Set
113 节点I versus AI
其他
使用GPT-4.1、Outlook和Mem.ai自动化Microsoft
使用GPT-4.1、Outlook和Mem.ai自动化Microsoft Teams会议分析
If
Set
Code
+
If
Set
Code
61 节点Wayne Simpson
人力资源
使用 GPT-4o 和 GoHighLevel SMS 创建自动化客户支持助手
使用 GPT-4o 和 GoHighLevel SMS 创建自动化客户支持助手
If
Set
Xml
+
If
Set
Xml
43 节点Cyril Nicko Gaspar
客户支持
使用正则表达式和 AI 发现隐藏的网站 API 端点
使用正则表达式和人工智能发现隐藏的网站API端点
If
Set
Html
+
If
Set
Html
58 节点Yulia
工程
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+
If
Set
Xml
125 节点Daniel Ng
内容创作
使用AI分析检测病毒式YouTube视频并发送邮件报告
使用AI分析检测病毒式YouTube视频并发送邮件报告
Set
Code
Sort
+
Set
Code
Sort
26 节点gclbck
杂项
