8
n8n 中文网amn8n.com

SSL到期通知器

中级

这是一个DevOps领域的自动化工作流，包含 13 个节点。主要使用 If, EmailSend, HttpRequest, GoogleSheets, ScheduleTrigger 等节点。 SSL证书到期通知器（无需付费API）

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (13)

If
EmailSend
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger

分类

开发运维
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "NTSkPEG2pcvG3qoH",
  "meta": {
    "instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
    "templateCredsSetupCompleted": true
  },
  "name": "SSL 到期通知器",
  "tags": [
    {
      "id": "b2GfRjIENZV9WKpD",
      "name": "IT Ops",
      "createdAt": "2025-05-29T08:33:47.664Z",
      "updatedAt": "2025-05-29T08:33:47.664Z"
    },
    {
      "id": "sfoRiNMRAXjQ31IO",
      "name": "DevOps",
      "createdAt": "2025-05-29T08:33:47.654Z",
      "updatedAt": "2025-05-29T08:33:47.654Z"
    }
  ],
  "nodes": [
    {
      "id": "b8c160c6-29a3-4b7d-ab78-e126206627b1",
      "name": "要监控的 URL",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        60,
        140
      ],
      "parameters": {
        "columns": {
          "value": {
            "URL": "={{ $json.result.host }}",
            "Days Left": "={{ $json.result.days_left }}",
            "Valid From": "={{ $json.result.valid_from }}",
            "Valid Till": "={{ $json.result.valid_till }}"
          },
          "schema": [
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Valid From",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Valid From",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Valid Till",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Valid Till",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Days Left",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Days Left",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "URL"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "https://docs.google.com/spreadsheets/d/1TakDfkHpgB8qQcvy98mgUfEsEZGnIVNlkwqnsWhGDwI/edit?gid=0#gid=0",
          "__regex": "https:\\/\\/docs\\.google\\.com\\/spreadsheets\\/d\\/[0-9a-zA-Z\\-_]+.*\\#gid=([0-9]+)"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "https://docs.google.com/spreadsheets/d/1TakDfkHpgB8qQcvy98mgUfEsEZGnIVNlkwqnsWhGDwI/edit?gid=0#gid=0"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "kXiWCpzbScflZGmW",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "21c4d282-5bb4-4d34-8cad-28e4e91843be",
      "name": "获取 URL",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -640,
        400
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "https://docs.google.com/spreadsheets/d/1TakDfkHpgB8qQcvy98mgUfEsEZGnIVNlkwqnsWhGDwI/edit?gid=0#gid=0"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "https://docs.google.com/spreadsheets/d/1TakDfkHpgB8qQcvy98mgUfEsEZGnIVNlkwqnsWhGDwI/edit?gid=0#gid=0"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "kXiWCpzbScflZGmW",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "3d6ebf5c-a89d-4890-ab64-01c6db1d8486",
      "name": "检查 SSL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -380,
        400
      ],
      "parameters": {
        "url": "=https://ssl-checker.io/api/v1/check/{{ $json[\"URL\"].replace(/^https?:\\/\\//, \"\").replace(/\\/$/, \"\") }}",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "1b7427f1-41aa-4aea-8a98-dccb44e958e0",
      "name": "到期警报",
      "type": "n8n-nodes-base.if",
      "position": [
        60,
        620
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "ee6e2ce8-569a-4f1f-91b5-2c55f605a16b",
              "operator": {
                "type": "number",
                "operation": "lte"
              },
              "leftValue": "={{ $json.result.days_left }}",
              "rightValue": 7
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "8efd16a5-ff9e-4138-aa70-ebd087fb27ef",
      "name": "发送邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        360,
        400
      ],
      "webhookId": "64bfb82b-e70f-4831-87b9-599d9187ec4a",
      "parameters": {
        "html": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <style>\n        body {\n            font-family: Arial, sans-serif;\n            background-color: #f4f4f9;\n            color: #333;\n            margin: 0;\n            padding: 0;\n        }\n        .container {\n            width: 100%;\n            max-width: 600px;\n            margin: 20px auto;\n            padding: 20px;\n            background-color: #ffffff;\n            border-radius: 8px;\n            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);\n        }\n        .header {\n            text-align: center;\n            color: #4CAF50;\n        }\n        .header h1 {\n            font-size: 24px;\n            margin: 0;\n        }\n        .message {\n            font-size: 16px;\n            margin: 20px 0;\n            padding: 10px;\n            background-color: #e3f2fd;\n            border-left: 5px solid #2196F3;\n        }\n        .highlight {\n            color: #d32f2f;\n            font-weight: bold;\n        }\n        .footer {\n            text-align: center;\n            font-size: 14px;\n            color: #888;\n            margin-top: 30px;\n        }\n        .footer a {\n            color: #2196F3;\n            text-decoration: none;\n        }\n    </style>\n</head>\n<body>\n    <div class=\"container\">\n        <div class=\"header\">\n            <h1>SSL Certificate Expiry Notice</h1>\n        </div>\n        <div class=\"message\">\n            <p>Dear Team,</p>\n            <p>The SSL certificate for the website <strong>{{ $json.result.host }}</strong> is set to expire in <span class=\"highlight\">{{ $json.result.days_left }}</span> days.</p>\n            <p>Please take the necessary actions to renew the certificate and ensure uninterrupted service.</p>\n        </div>\n        <div class=\"footer\">\n            <p>Best regards,<br>The IT Operations Team</p>\n        </div>\n    </div>\n</body>\n</html>\n",
        "options": {},
        "subject": "=SSL Expiry - {{ $json.result.days_left }} Days Left - {{ $json.result.host }}",
        "toEmail": "=team1@gmail.com,team2@gmail.com",
        "fromEmail": "admin@gmail.com"
      },
      "credentials": {
        "smtp": {
          "id": "H0f4Gja9ECFRA34L",
          "name": "SMTP account 2"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "7ce561b1-1102-4fc1-972b-7dca1793e023",
      "name": "每日触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -900,
        400
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 8
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "12d2c49f-9d56-4ace-bc06-82ea850df133",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1620,
        -380
      ],
      "parameters": {
        "width": 500,
        "height": 1240,
        "content": "## 🔐 SSL 到期通知器（无需付费 API）"
      },
      "typeVersion": 1
    },
    {
      "id": "68db9999-8a66-479f-8708-c2b9b6556a76",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1000,
        220
      ],
      "parameters": {
        "height": 320,
        "content": "### 🕒 每日触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "b39cd547-196f-48ea-b7b5-8b09561032ce",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -700,
        220
      ],
      "parameters": {
        "height": 320,
        "content": "### 📄 获取 URL"
      },
      "typeVersion": 1
    },
    {
      "id": "455e64c4-38da-4965-bfd6-b11a699243b1",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -420,
        220
      ],
      "parameters": {
        "height": 320,
        "content": "### 🔍 检查 SSL"
      },
      "typeVersion": 1
    },
    {
      "id": "51b3423d-ea6e-4878-9d2e-177e04222100",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        460
      ],
      "parameters": {
        "height": 300,
        "content": "### ⚠️ 到期警报"
      },
      "typeVersion": 1
    },
    {
      "id": "17cfd4d8-cbfe-46f0-bdf1-3a89f557200b",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        300,
        220
      ],
      "parameters": {
        "height": 320,
        "content": "### 📧 发送邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "64c0883c-223f-4276-886b-d9996aa099dd",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -60
      ],
      "parameters": {
        "height": 400,
        "content": "### 🔄 更新表格"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "f02670ca-1476-4eb6-acac-205630fa2b1c",
  "connections": {
    "Check SSL": {
      "main": [
        [
          {
            "node": "URLs to Monitor",
            "type": "main",
            "index": 0
          },
          {
            "node": "Expiry Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch URLs": {
      "main": [
        [
          {
            "node": "Check SSL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email": {
      "main": [
        []
      ]
    },
    "Expiry Alert": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Trigger": {
      "main": [
        [
          {
            "node": "Fetch URLs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 开发运维

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

使用 Job Search Global API 和 Google Sheets 自动化职位搜索
使用 Job Search Global API 和 Google Sheets 自动化职位搜索
If
Set
Code
+5
15 节点Evoort Solutions
内容创作
使用Google Sheets和邮件通知优化标题清晰度
使用Google Sheets和邮件通知优化标题清晰度
If
Code
Email Send
+4
14 节点Evoort Solutions
内容创作
AWS EC2 健康检查与自愈工作流
监控 AWS EC2 实例健康状态并实现多通道告警自愈
If
Code
Email Send
+6
14 节点Oneclick AI Squad
开发运维
自动化API正常运行时间监控与即时停机警报
API正常运行时间监控，含WhatsApp警报和Google表格管理
If
Code
Wait
+6
17 节点Oneclick AI Squad
开发运维
使用邮件审批和 SSH 自动化基于 Docker 的 n8n 更新
使用邮件审批和 SSH 自动化基于 Docker 的 n8n 更新
If
Set
Ssh
+5
27 节点Muhammad Anas Farooq
开发运维
TikTok转录文本
使用RapidAPI和Google Sheets自动化TikTok视频转录
If
Code
Wait
+5
21 节点Evoort Solutions
内容创作
工作流信息
难度等级
中级
节点数量13
分类1
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Evoort Solutions

Evoort Solutions

@evoortsolutions
外部链接
在 n8n.io 查看 →

分享此工作流