AutomationFlowsSlack & Telegram › Monitor Ssl Certificate Expiry Dates with Google Sheets & Slack Alerts

Monitor Ssl Certificate Expiry Dates with Google Sheets & Slack Alerts

ByCustomJS @customjs on n8n.io

This n8n workflow illustrates how to monitor and track SSL certificate expiration dates for any domain using the SSL Checker node from customJS. It automatically updates a Google Sheet with the number of days left until expiry and sends a Slack notification when certificates are…

Cron / scheduled trigger★★★★☆ complexity6 nodesGoogle SheetsSlack@Custom Js/N8N Nodes Pdf Toolkit V2
Slack & Telegram Trigger: Cron / scheduled Nodes: 6 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #5172 — we link there as the canonical source.

This workflow follows the Google Sheets → Slack recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "nHaj5PMTnVMoiUXB",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Monitor SSL certificate expiry dates with Google Sheets & Slack alerts",
  "tags": [
    "SSL",
    "Monitoring",
    "Google Sheets",
    "Slack",
    "Alerts",
    "Security",
    "Automation"
  ],
  "nodes": [
    {
      "id": "a2e344e1-c22a-4044-885d-e7dbe2f2fb6d",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -288,
        16
      ],
      "parameters": {
        "columns": {
          "value": {
            "Website": "={{ $json.output.host }}",
            "Days Left": "={{ $json.output.daysLeft }}"
          },
          "schema": [
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Days Left",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Days Left",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Website"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1FmbkG1mX7jg6jnAXQRIT-xgNXQ76yYgc62WPIW7rejI/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1FmbkG1mX7jg6jnAXQRIT-xgNXQ76yYgc62WPIW7rejI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1FmbkG1mX7jg6jnAXQRIT-xgNXQ76yYgc62WPIW7rejI/edit?usp=drivesdk",
          "cachedResultName": "Domains"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "e3bd4ac4-c03d-47fe-9d5e-0eb1e3fa0748",
      "name": "Send a message",
      "type": "n8n-nodes-base.slack",
      "position": [
        208,
        0
      ],
      "parameters": {
        "text": "=\u23f0 Reminder: SSL certificate of {{ $('Update row in sheet').item.json.Website }} will expire in {{ $json[\"Days Left\"] }} days.",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": "U05EAUS4JCD",
          "cachedResultName": "hammadawan0007"
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "090961cf-0d4f-401f-9c27-5868bee1548e",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1088,
        16
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "1f09a04b-4346-43e5-a648-bf3bd551924b",
      "name": "Check Days Left Threshold",
      "type": "n8n-nodes-base.if",
      "position": [
        -48,
        16
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "3ce0ef67-751d-4a37-959a-08427894f449",
              "operator": {
                "type": "number",
                "operation": "lt"
              },
              "leftValue": "={{ $json['Days Left'] }}",
              "rightValue": 8
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "c9deae55-c428-419b-a345-34b9360d2773",
      "name": "Check SSL",
      "type": "@custom-js/n8n-nodes-pdf-toolkit-v2.pdfToolkit",
      "position": [
        -576,
        16
      ],
      "parameters": {
        "domain": "={{ $json.Website }}",
        "resource": "web",
        "operation": "sslCheck"
      },
      "credentials": {
        "customJsApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "22f6b6c2-f212-40c1-9c5c-0517e712376b",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -864,
        16
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1FmbkG1mX7jg6jnAXQRIT-xgNXQ76yYgc62WPIW7rejI/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1FmbkG1mX7jg6jnAXQRIT-xgNXQ76yYgc62WPIW7rejI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1FmbkG1mX7jg6jnAXQRIT-xgNXQ76yYgc62WPIW7rejI/edit?usp=drivesdk",
          "cachedResultName": "Domains"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.7,
      "alwaysOutputData": true
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "fce16f52-c041-4ad9-8621-7013ed85286f",
  "connections": {
    "Check SSL": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Check SSL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row in sheet": {
      "main": [
        [
          {
            "node": "Check Days Left Threshold",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Days Left Threshold": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This n8n workflow illustrates how to monitor and track SSL certificate expiration dates for any domain using the SSL Checker node from customJS. It automatically updates a Google Sheet with the number of days left until expiry and sends a Slack notification when certificates are…

Source: https://n8n.io/workflows/5172/ — original creator credit. Request a take-down →

More Slack & Telegram workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Slack & Telegram

This n8n workflow demonstrates how to monitor competitor websites for SEO changes by scraping content and updating a Google Sheet. It uses the Scraper node from customjs.space to extract HTML content

Google Sheets, Slack, @Custom Js/N8N Nodes Pdf Toolkit V2
Slack & Telegram

This workflow continuously monitors the Meta Ads Library for new creatives from a specific competitor pages, logs them into Google Sheets, and sends a concise Telegram notification with the number of

HTTP Request, Telegram, Google Sheets +1
Slack & Telegram

Enhance financial oversight with this automated n8n workflow. Triggered every 5 minutes, it fetches real-time bank transactions via an API, enriches and transforms the data, and applies smart logic to

HTTP Request, Email Send, Google Sheets +1
Slack & Telegram

This workflow automates competitive price intelligence using Bright Data's enterprise web scraping API. On a scheduled basis (default: daily at 9 AM), the system loops through configured competitor pr

HTTP Request, Google Sheets, Slack +1
Slack & Telegram

Ensure your customer SLAs never slip with this n8n automation template. The workflow runs on a schedule, fetching open tickets from Zendesk, calculating SLA time remaining, and sending proactive alert

Zendesk, Slack, Google Sheets