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 certified 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:

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

🛠️ How It Works

1. Scheduled Trigger

   • Executes weekly (Monday 7:00 AM).

2. Fetch Website List

   • Reads all website entries from the Google Sheet.

3. Check SSL Certificates

   • Uses ssl-checker.io API to retrieve certificate details for each website.

4. Update Spreadsheet

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

5. Evaluate SSL Expiry

   • Filters for certificates expiring within 14 days.

6. Check Condition

   • Determines whether to send alerts based on filtered results.

7. 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.