Automated SSL Expiry Alert System
detail.loadingPreview
Proactively monitor your SSL certificates and receive timely alerts before they expire. This workflow automatically checks SSL certificate validity, logs the details, and categorizes them based on expiry dates, ensuring uninterrupted online presence.
About This Workflow
Never let an expired SSL certificate disrupt your online services again. This n8n workflow automates the critical task of SSL certificate monitoring. It begins by fetching a list of URLs from a Google Sheet, then uses the SSL-Checker.io API to retrieve detailed SSL information, including host, validity period, and days remaining until expiry. The results are categorized into 'invalid', 'warning' (expires < 30 days), 'notice' (expires < 60 days), and 'info'. Finally, all collected SSL data is updated back into your Google Sheet, providing a clear, up-to-date overview of your certificate status. This proactive approach helps maintain website security and user trust.
Key Features
- Automated SSL Checks: Regularly verifies the validity and expiry of your SSL certificates.
- Google Sheets Integration: Reads URLs to monitor from and writes detailed SSL status back to Google Sheets.
- Proactive Alerting Categories: Classifies certificates into 'invalid', 'warning' (<30 days), 'notice' (<60 days), and 'info' for easy prioritization.
- Reliable API Integration: Leverages SSL-Checker.io for accurate and comprehensive SSL data.
- Scheduled Execution: Runs automatically on a weekly basis to ensure continuous monitoring.
How To Use
- Connect to Google Sheets: Authorize your Google Sheets account within n8n to allow access to your spreadsheets.
- Configure 'Fetch URLs' Node: Specify the Google Sheet Document ID and the Sheet Name (e.g., 'Sheet1' or a specific GID like 'gid=0') containing the list of URLs you want to monitor. Ensure the sheet has a 'URL' column.
- Configure 'Check SSL' Node: The 'URL' parameter in this node is pre-configured to dynamically use the 'URL' data from the previous Google Sheets node. Ensure the URL format is correct (e.g.,
https://example.com). - Configure 'URLs to Monitor' Node: This node is set up to update your Google Sheet. Ensure the 'Document ID' and 'Sheet Name' (e.g., 'certificate-data') are correctly set to your desired output sheet. The 'Matching Columns' are set to 'ID', which can be used to uniquely identify entries if you have an ID column.
- Set Trigger: Configure the 'Weekly Trigger' node to run your workflow at your desired frequency (e.g., every Monday at 8 AM).
- Review Sticky Notes: The included sticky notes provide further context on the workflow's logic and data processing steps.
Apps Used
Workflow JSON
{
"id": "06d92731-5922-4b36-a7c3-f579d0194334",
"name": "Automated SSL Expiry Alert System",
"nodes": 18,
"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: 06d92731-5922...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Effortless Bug Reporting: Slack Slash Command to Linear Issue
Streamline your bug reporting process by instantly creating Linear issues directly from Slack using a simple slash command. This workflow enhances team collaboration by providing immediate feedback and a structured approach to logging defects, saving valuable time for development and QA teams.
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.