This n8n workflow automates the process of monitoring SSL certificate expirations for multiple websites. It runs weekly, fetching a list of URLs from Google Sheets, and checks each site’s SSL certificate status using SSL-Checker.io. If any SSL certificate is set to expire within 7 days, an automatic email alert is triggered to notify the administrator. Additionally, the workflow updates the Google Sheet with the latest SSL details for clear record-keeping.

**Workflow Steps:**

1. Triggered weekly on a specified day and time.

2. Retrieves the list of website URLs from a Google Sheet.

3. For each URL, makes an API call to SSL-Checker.io to verify the SSL certificate status and remaining validity period.

4. Checks if the SSL expiry date is within 7 days and, if so, sends an email alert with the details.

5. Updates the Google Sheet with recent SSL expiry dates and status.

**Use Cases:**

– Ensuring website SSL certificates are renewed before expiration.

– Automating security compliance checks.

– Centralized monitoring for multiple web assets to prevent outages caused by expired certificates.