← All N8N workflows
Data & databasesNtfyGmailGoogle SheetsHTTP RequestSchedule Trigger

Template - SSL Expiry Alert System

Configured with Ntfy, Gmail, Google Sheets, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
Data storeURLs to MonitorGoogle SheetsTriggerWeekly TriggerSchedule TriggerData storeFetch URLsGoogle SheetsWeb / APICheck SSLHTTP RequestRoutingSwitchSwitchMessagingSend Alert Email2GmailMessagingSend Alert Email4GmailMessagingSend Alert Email6GmailMessagingNtfy4NtfyMessagingSend Alert Email1GmailMessagingTelegramTelegram

Node categories in this workflow

  • Data store
  • Trigger
  • Web / API
  • Routing
  • Messaging

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
URLs to MonitorData storeGoogle SheetsappendOrUpdate
Weekly TriggerTriggerSchedule TriggerSee node parameters
Fetch URLsData storeGoogle SheetsSee node parameters
Check SSLWeb / APIHTTP RequestSee node parameters
SwitchRoutingSwitchSee node parameters
Send Alert Email2MessagingGmailSee node parameters
Send Alert Email4MessagingGmailSee node parameters
Send Alert Email6MessagingGmailSee node parameters
Ntfy4MessagingNtfySee node parameters
Send Alert Email1MessagingGmailSee node parameters
TelegramMessagingTelegramSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • gmailOAuth2
  • googleSheetsOAuth2Api
  • telegramApi

Workflow notes

Sticky Note2

Uses SSL-Checker.io to verify the SSL certificate of each URL. Fetches details like the host, validity period, and days remaining until expiry.

Sticky Note3

Updates the Google Sheet with SSL details, including the expiry date and certificate status.

Sticky Note4

Checks certificates and groups into:

  • invalid (certificate invalid)
  • warning (expires in <30 days)
  • notice (expires in <60 days)
  • info (everything else)
Sticky Note5

Invalid

Sticky Note10

Pulls the list of URLs to monitor from the Google Sheet. Ensure you clone the Google Sheet worksheet and update this node with its URL.

This is the Sheet Layout: A B C 1 URL 2 n8n.io 3 amazon.com 4 google.com 5 chat.openai.com

Sticky Note11

Triggers the workflow once a week.

Sticky Note8

Notice

Sticky Note

Warning

Sticky Note7

Info

SSL Expiry Alert System

SSL Expiry Alert System

Who is this for?

This workflow is ideal for administrators or IT professionals responsible for monitoring SSL certificates of multiple websites to ensure they do not expire unexpectedly.

Problem

SSL certificates play a crucial role in ensuring secure communication over the internet. However, if not monitored closely, they can expire, leading to potential security risks and service disruption. This workflow helps in proactively monitoring SSL certificate expiry dates.

Functionality

  1. Pulls URLs to monitor from a Google Sheet.
  2. Checks SSL certificates using SSL-Checker.io.
  3. Updates Google Sheet with SSL details such as expiry date and certificate status.
  4. Sends email alerts for SSL certificates nearing expiry (<30 days) or invalid certificates.

Setup

  1. Clone the provided Google Sheet and update the Google Sheet URL in the "URLs to Monitor" node.
  2. Set up Google Sheets and Gmail credentials in n8n.
  3. Configure the Discourse Trigger for weekly monitoring.
  4. Customize email alert settings as needed.

Customization

  • Modify the frequency of monitoring by adjusting the trigger interval in the "Weekly Trigger" node.
  • Customize email content and recipients in the "Send Alert Email" node.
  • Extend functionality by adding additional checks or actions based on SSL certificate status.

Note

Ensure proper authentication and authorization for accessing Google Sheets, SSL-Checker.io, and Gmail accounts within the workflow.

Template - SSL Expiry Alert System

Template - SSL Expiry Alert System

Purpose and structure

This folder contains the Template - SSL Expiry Alert System workflow. Its executable nodes use Ntfy, gmail, googleSheets, httpRequest, scheduleTrigger, switch, telegram. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Weekly Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Telegram/1522_Telegram_Schedule_Send_Webhook.json MIT; preserve source notices.

More in Data & databases