SSL Expiry Alert

SSL Expiry Alert automates the monitoring of SSL certificates, checking weekly for any that are set to expire within 7 days. It fetches URLs from Google Sheets, verifies their SSL status, and sends email alerts for impending expirations. This ensures timely notifications, helping to maintain website security and prevent downtime.

7/8/2025
12 nodes
Medium
aqlzb2qfwiat4xr5zjazorwwcgptp35uschedulemediumgooglesheetsschedule triggergmailsticky noteautomationadvancedcronapiintegrationlogicconditional
Categories:
Communication & MessagingSchedule TriggeredData Processing & AnalysisMedium Workflow
Integrations:
GoogleSheetsSchedule TriggerGmailSticky Note

Target Audience

This workflow is ideal for:
- Website Administrators: Those responsible for managing multiple websites and ensuring their security through valid SSL certificates.
- IT Professionals: Individuals in charge of maintaining web infrastructure and compliance with security standards.
- Business Owners: Entrepreneurs who want to ensure their online presence is secure and trustworthy for customers.
- Developers: Tech-savvy individuals who require automated solutions for monitoring SSL certificates across various domains.

Problem Solved

This workflow addresses the issue of SSL certificate expiration, which can lead to:
- Website Downtime: Expired SSL certificates can cause websites to become inaccessible, leading to potential loss of traffic and revenue.
- Security Risks: Visitors may receive warnings about insecure connections, damaging the website's reputation.
- Manual Monitoring: Reduces the need for manual checks by automating the monitoring process and sending alerts when certificates are nearing expiration.

Workflow Steps

  • Weekly Trigger: The workflow is initiated once a week at 8 AM to check the SSL certificates of the specified URLs.
    2. Fetch URLs: It retrieves a list of URLs to monitor from a designated Google Sheet.
    3. Check SSL: For each URL, the workflow uses the SSL-Checker.io API to verify the SSL certificate status, retrieving details like the validity period and days remaining until expiry.
    4. Expiry Alert: The workflow checks if any SSL certificate is set to expire in 7 days or less.
    5. Send Alert Email: If any certificates are nearing expiry, an email alert is sent to the specified recipient, detailing the days left and the host of the affected URL.

    • Customization Guide

    To customize this workflow:
    - Modify the Trigger: Adjust the schedule settings in the Weekly Trigger node to change the frequency or timing of checks.
    - Update Google Sheet Links: Change the document ID and sheet name in the Fetch URLs and URLs to Monitor nodes to point to your specific Google Sheets.
    - Change Email Settings: Update the recipient's email address and message content in the Send Alert Email node to tailor alerts to your needs.
    - Add More URLs: Include additional URLs in the Google Sheet to monitor more domains by simply adding them to the sheet.

    SSL Expiry Alert - N8N Workflow Directory