Automate SSL Certificate Monitoring And Updates
detail.loadingPreview
Proactively monitor your website's SSL certificates and receive timely alerts before they expire. This workflow automatically checks your SSL status and updates your records, ensuring uninterrupted service and enhanced security.
About This Workflow
This n8n workflow automates the critical task of SSL certificate monitoring. It's designed to periodically check the expiration dates of your website's SSL certificates, ensuring you are always aware of their status. The workflow connects to your Google Sheets to retrieve a list of websites, then queries an external API to gather SSL details. It intelligently identifies certificates that are nearing expiration and updates your Google Sheet with the latest information, including issue and expiry dates. This proactive approach helps prevent service disruptions and maintains user trust by ensuring your site is always secure and compliant.
Key Features
- Automated SSL Expiration Checks: Regularly monitors SSL certificates to prevent unexpected expirations.
- Google Sheets Integration: Seamlessly reads website lists and writes SSL status updates to your Google Sheet.
- Proactive Expiration Alerts: Identifies certificates expiring within a configurable timeframe (e.g., 14 days).
- Reliable HTTP Request Node: Utilizes an API to fetch accurate SSL certificate details.
- Scheduled Operation: Runs automatically every Monday, keeping your records up-to-date.
How To Use
- Schedule Trigger: Configure the 'Trigger Every Monday' node to set your desired monitoring frequency (e.g., weekly on Mondays at 7 AM).
- Get Website List: Connect your Google account to the 'Get Website List' node and specify the Google Sheet containing your website names and links.
- Loop Through Websites: The 'Loop' node (n8n's 'Split In Batches') will process each website from your list individually.
- Get SSL Details: In the 'Get SSL' node, ensure the URL dynamically fetches SSL information using the website link from the previous step. The provided URL structure
https://ssl-checker.io/api/v1/check/{{ $json.Link.replace(/^https?:\/\//, "").replace(/\/$/, "") }}is a good starting point. - Conditional Check: The 'SSL Not Good?' node uses a code snippet to determine if SSL certificates are expiring soon (within 14 days by default). It outputs 'All Good' if no immediate issues are found, or details if certificates are close to expiry.
- Update Google Sheet: The 'Update SSL in Spreadsheet' node (configured for Google Sheets) takes the website name, SSL Issued On, and SSL Expired On data and updates your designated Google Sheet. Ensure your Google Sheet has columns for 'Name', 'SSL Issued On', and 'SSL Expired On'.
Apps Used
Workflow JSON
{
"id": "c10c0bcb-7ac7-4a0d-bca7-edefecfba5e4",
"name": "Automate SSL Certificate Monitoring And Updates",
"nodes": 7,
"category": "DevOps",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: c10c0bcb-7ac7...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automate Qualys Report Generation and Retrieval
Streamline your Qualys security reporting by automating the generation and retrieval of reports. This workflow ensures timely access to crucial security data without manual intervention.
Automated PR Merged QA Notifications
Streamline your QA process with this automated workflow that notifies your team upon successful Pull Request merges. Leverage AI and vector stores to enrich notifications and ensure seamless integration into your development pipeline.
Visualize Your n8n Workflows: Interactive Dashboard with Mermaid.js
Gain unparalleled visibility into your n8n automation landscape. This workflow transforms your n8n instance into a dynamic, interactive dashboard, leveraging Mermaid.js to visualize all your workflows in one accessible place.