Use Cases
- 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.
How It Works
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.
Setup Steps
- 1Import the workflow template into n8n.
- 2Connect your Google Sheets account for both fetching and updating data.
- 3Set up the email service for sending alerts.
- 4Update the Google Sheets document URLs in the workflow parameters.
- 5Activate the workflow to start monitoring.
Apps Used
Google Sheets
HTTP Request Service
Categories
Target Roles
Industries
Tags
#notifications
#email automation
#process automation