SSL Expiry Monitoring and Alerting in Google Sheets

• Monitor SSL certificate expiry dates for multiple websites.
• Receive automated email alerts for SSL certificates expiring soon.
• Maintain a centralized list of monitored URLs in Google Sheets.

Triggers weekly to fetch URLs from Google Sheets. Checks the SSL status of each URL using an external service. Evaluates if any SSL certificates are expiring within 7 days. Sends email alerts for certificates that are nearing expiry. Updates the Google Sheets with the latest SSL status information.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Sheets account for both fetching and updating data.
3. 3
   Set up the email service for sending alerts.
4. 4
   Update the Google Sheets document URLs in the workflow parameters.
5. 5
   Activate the workflow to start monitoring.