Monitor SSL Certificate Expiry with Google Sheets and Email Alerts

🔒 SSL Certificate Monitoring & Expiry Alert with Spreadsheet [FREE APIs]

✅ What This Workflow Does

This n8n template automatically monitors SSL certificates of websites listed in a Google Sheet and sends email alerts if any are expiring within 14 days. It helps ensure you avoid downtime, security issues, and trust warnings due to expired certificates.

🧩 Key Features

📅 Weekly Automation: Runs every Monday at 7:00 AM (configurable). 📄 Google Sheets Integration: Fetches and updates data in a spreadsheet. 🔍 SSL Check via API: Uses ssl-checker.io to get certificate details. ⚠️ SSL Expiry Filter: Identifies certificates expiring within 14 days. 📧 Email Alerts: Sends notifications for certificates close to expiration.

📂 Input Spreadsheet Format

Your Google Sheet should have the following columns:

| No | Name | Link | SSL Issued On | SSL Expired On | SSL Status | |----|-----------------|-----------------------|-------------------|-------------------|------------| | 1 | Example Site | https://example.com | 2024-07-01 | 2025-07-01 | Valid | | 2 | My Blog | https://myblog.org | 2024-07-05 | 2024-07-20 | Expiring |

Each row should include a valid website URL in the Link column.

🛠️ How It Works

Scheduled Trigger Executes weekly (Monday 7:00 AM).

Fetch Website List Reads all website entries from the Google Sheet.

Check SSL Certificates Uses ssl-checker.io API to retrieve certificate details for each website.

Update Spreadsheet Writes "Issued On" and "Expired On" fields back to the spreadsheet.

Evaluate SSL Expiry Filters for certificates expiring within 14 days.

Check Condition Determines whether to send alerts based on filtered results.

Send Email Alert Notifies via email if any certificates are expiring soon.

📬 Example Email Output Subject: ⚠️ ALERT!! SSL EXPIRED

SSL certificates expiring soon: example.com (expires in 5 days) anotherdomain.net (expires in 3 days)

🧰 Setup Requirements

A Google Sheet with the correct columns and website links. SMTP credentials to send alert emails.