基于Notion和Telegram的自动化SSL证书监控与续期
高级
这是一个SecOps领域的自动化工作流，包含 21 个节点。主要使用 If, Set, Ssh, Code, Wait 等节点。 使用Notion和Telegram实现SSL证书的自动化监控与续期
前置要求
- •Notion API Key
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
使用的节点 (21)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "0b5a6312708ae192922c99c43dfe92176cea5b0f71962c24e17df7b02bbd37c2",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "469d3992-ba1a-47c2-8400-73224b70425c",
"name": "检查 SSL",
"type": "n8n-nodes-base.httpRequest",
"position": [
1620,
600
],
"parameters": {
"url": "=https://ssl-checker.io/api/v1/check/{{ $json.name }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "c84b355a-0f3a-4256-b835-28f1a2c08fbb",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
2040,
600
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e4af952e-e497-4d8e-a0fe-6d05c385bdd6",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $('Refresh SSL Status').item.json.result.days_left }}",
"rightValue": 14
}
]
}
},
"typeVersion": 2.2
},
{
"id": "da422db5-a9cf-4977-b508-ec4d17f34c56",
"name": "获取 SSL 信息",
"type": "n8n-nodes-base.notion",
"position": [
1420,
600
],
"parameters": {
"options": {},
"resource": "databasePage",
"operation": "getAll",
"returnAll": true
},
"credentials": {
"notionApi": {
"id": "jNo8UqufbOaVdEoY",
"name": "Notion account"
}
},
"typeVersion": 2.2
},
{
"id": "806efbf8-9783-439e-8068-b59b86f41be8",
"name": "刷新 SSL 状态",
"type": "n8n-nodes-base.code",
"position": [
1840,
600
],
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n if (item.json.result.days_left < 14) {\n item.json.ssl_status = \"It's about to expire.\";\n } else if (item.json.result.days_left >= 14) {\n item.json.ssl_status = \"Normal\";\n } else {\n item.json.ssl_status = \"Unavailable\";\n }\n}\n\nreturn $input.all();"
},
"typeVersion": 2
},
{
"id": "b82487c2-9070-4741-b8a3-d91595b52272",
"name": "更新 SSL 信息",
"type": "n8n-nodes-base.notion",
"position": [
2420,
740
],
"parameters": {
"pageId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Get SSL Info').item.json.url }}"
},
"options": {},
"resource": "databasePage",
"operation": "update",
"propertiesUi": {
"propertyValues": [
{
"key": "Creation Date|date",
"date": "={{ $json.result.valid_from }}",
"timezone": "Asia/Taipei",
"includeTime": false
},
{
"key": "Expiration Date|date",
"date": "={{ $json.result.valid_till }}",
"timezone": "Asia/Taipei",
"includeTime": false
},
{
"key": "SSL 狀態|select",
"selectValue": "={{ $json.ssl_status }}"
},
{
"key": "Last Check At|date",
"date": "={{ $now.toString() }}"
}
]
}
},
"credentials": {
"notionApi": {
"id": "jNo8UqufbOaVdEoY",
"name": "Notion account"
}
},
"typeVersion": 2.2
},
{
"id": "8e721b47-ea70-462f-9bcd-7c7d82197c6e",
"name": "合并内容",
"type": "n8n-nodes-base.code",
"position": [
2620,
480
],
"parameters": {
"jsCode": "var result = \"The certificates for the following domains are about to expire. Please confirm that they have been updated to avoid unexpected service downtime.：\\n\";\nvar index = 1;\n\nfor (const item of $('Refresh SSL Status').all()) {\n if (item.json.result.days_left < 14) {\n result += `${index}. ${item.json.host}：${item.json.result.days_left} days remaining.\\n`;\n \n index++;\n }\n}\n\nresult += \"\\nThe instruction to update the credentials has been automatically triggered and the system will check again.\";\n\nreturn {output: result};"
},
"typeVersion": 2
},
{
"id": "dbac84ed-cde7-4ec0-83ad-9f66b8c313d5",
"name": "每周触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
740,
600
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b6e10348-6364-4ba1-8770-d4451e88bc3a",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
740,
420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "883b7a42-f6d8-43f2-b06b-9f7ced94a53c",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
3300,
480
],
"webhookId": "566cb4a9-c513-442f-97bc-ffb5ff01c904",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "c4a69edf-680a-461e-ad07-b59b478a511d",
"name": "条件3",
"type": "n8n-nodes-base.if",
"position": [
2240,
720
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "273ad0c0-dc65-4e22-8248-2394cf9540b8",
"operator": {
"type": "array",
"operation": "lengthNotEquals",
"rightType": "number"
},
"leftValue": "={{ $('If').all() }}",
"rightValue": "={{ $('Get SSL Info').all().length }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "43d2b787-83cf-46c0-9a7f-d96d9790c118",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
2420,
480
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3.1
},
{
"id": "69cdc9ee-aff1-4487-92ff-f025210a2c68",
"name": "如果1",
"type": "n8n-nodes-base.if",
"position": [
2620,
740
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b519c2ca-048a-4a53-97f3-d2c6fec2987e",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Select Who Triggered').first().json.triggerBy }}",
"rightValue": "anotherWorkflow"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3084cc79-82ed-470b-bf13-bad763f1eb4f",
"name": "执行工作流",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
3520,
480
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "WO0anosBgPhhJ0Qi",
"cachedResultName": "SSL Check Service"
},
"workflowInputs": {
"value": {
"has_expired_cert": true
},
"schema": [
{
"id": "has_expired_cert",
"type": "boolean",
"display": true,
"removed": false,
"required": false,
"displayName": "has_expired_cert",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"has_expired_cert"
],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "323cf648-0ed5-4b0c-801f-ea088a8c969f",
"name": "当由另一个工作流执行时",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
740,
780
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "has_expired_cert",
"type": "boolean"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "950d0d4f-7ec7-4fdf-a871-fdc2f6a695d6",
"name": "设置点击触发",
"type": "n8n-nodes-base.set",
"position": [
960,
420
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7ae06a67-600e-4efa-9eb1-da1bf83dc983",
"name": "triggerBy",
"type": "string",
"value": "click"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ffe248fd-0a2e-4635-a749-8f982a5a5412",
"name": "设置每周触发",
"type": "n8n-nodes-base.set",
"position": [
960,
600
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7ae06a67-600e-4efa-9eb1-da1bf83dc983",
"name": "triggerBy",
"type": "string",
"value": "weekly"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "a1f5e319-1cff-4bb7-8911-d067095d1c6c",
"name": "设置其他工作流触发",
"type": "n8n-nodes-base.set",
"position": [
960,
780
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "7ae06a67-600e-4efa-9eb1-da1bf83dc983",
"name": "triggerBy",
"type": "string",
"value": "anotherWorkflow"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "758c172a-d289-4a1c-8e3d-1c4aaf643ff6",
"name": "选择触发者",
"type": "n8n-nodes-base.merge",
"position": [
1220,
600
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3.1
},
{
"id": "6b7db2a1-677a-4e24-93b7-baff9a2b60c2",
"name": "续订服务器证书",
"type": "n8n-nodes-base.ssh",
"position": [
3080,
480
],
"parameters": {
"cwd": "/your/work//directory",
"command": "sudo certbot renew",
"authentication": "privateKey"
},
"credentials": {
"sshPrivateKey": {
"id": "A1cgCKhrMGdu22tY",
"name": "SSH Password account"
}
},
"typeVersion": 1
},
{
"id": "caa30dca-a69e-499c-802b-e025ea8f4c10",
"name": "Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
2860,
480
],
"webhookId": "82b65c71-8e83-427f-a18c-bf2a18f65385",
"parameters": {
"text": "=\\[Notify] `{{ $workflow.name }}`\n{{ $json.output }}",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "DGiiOp2EYP2DkQ4z",
"name": "Telegram account_n8n_assistant"
}
},
"typeVersion": 1.2
},
{
"id": "1853becf-ec46-47e2-b51e-c03f616e16ee",
"name": "Telegram1",
"type": "n8n-nodes-base.telegram",
"position": [
2860,
720
],
"webhookId": "82b65c71-8e83-427f-a18c-bf2a18f65385",
"parameters": {
"text": "=\\[Notify] `{{ $workflow.name }}`\nThe SSL certificate has been updated and all certificates are normal.",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "DGiiOp2EYP2DkQ4z",
"name": "Telegram account_n8n_assistant"
}
},
"typeVersion": 1.2
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
],
[
{
"node": "If3",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Telegram1",
"type": "main",
"index": 0
}
]
]
},
"If3": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
],
[
{
"node": "Update SSL Info",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Execute Workflow",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Merge Content",
"type": "main",
"index": 0
}
]
]
},
"Telegram": {
"main": [
[
{
"node": "Renew Server Cert",
"type": "main",
"index": 0
}
]
]
},
"Check SSL": {
"main": [
[
{
"node": "Refresh SSL Status",
"type": "main",
"index": 0
}
]
]
},
"Get SSL Info": {
"main": [
[
{
"node": "Check SSL",
"type": "main",
"index": 0
}
]
]
},
"Merge Content": {
"main": [
[
{
"node": "Telegram",
"type": "main",
"index": 0
}
]
]
},
"Weekly Trigger": {
"main": [
[
{
"node": "Set Weekly Triggered",
"type": "main",
"index": 0
}
]
]
},
"Update SSL Info": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Renew Server Cert": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Refresh SSL Status": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Set Click Triggered": {
"main": [
[
{
"node": "Select Who Triggered",
"type": "main",
"index": 0
}
]
]
},
"Select Who Triggered": {
"main": [
[
{
"node": "Get SSL Info",
"type": "main",
"index": 0
}
]
]
},
"Set Weekly Triggered": {
"main": [
[
{
"node": "Select Who Triggered",
"type": "main",
"index": 1
}
]
]
},
"Set anotherWorkflow Triggered": {
"main": [
[
{
"node": "Select Who Triggered",
"type": "main",
"index": 2
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Set anotherWorkflow Triggered",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Set Click Triggered",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 安全运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
Twitter线程（刷屏）翻译器和发布器
使用OpenAI翻译并以多种语言重新发布Twitter线程
If
Set
Code
+15
62 节点enes cingoz
人工智能
↔️ Airtable批量处理
Airtable批量更新/插入行（发送更快+节省API调用请求）
If
Set
Code
+12
35 节点Simon Mayerhofer
IT 运维
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
