SSL Expiry Alert
This workflow implements automatic monitoring of SSL certificate validity for multiple websites. It regularly retrieves URLs to be checked from Google Sheets and uses the SSL-Checker.io API to check the certificate status in real-time. If a certificate is set to expire within 7 days, the system automatically sends an email reminder to enhance the automation and timeliness of certificate management, effectively preventing security risks and service interruptions caused by expired certificates, and ensuring the safe and stable operation of the websites.
Tags
Workflow Name
SSL Expiry Alert
Key Features and Highlights
This workflow automates the monitoring of SSL certificate validity across multiple websites by leveraging the SSL-Checker.io API for real-time certificate status checks. It periodically updates certificate details in Google Sheets and automatically sends email alerts when certificates are approaching expiration (within 7 days), significantly enhancing the automation and timeliness of SSL certificate management.
Core Problem Addressed
Expired SSL certificates can lead to website security vulnerabilities and service interruptions. Traditional manual monitoring methods are prone to errors and inefficiencies. This workflow resolves the issue of untimely certificate expiry notifications through automation, helping to prevent security incidents and business disruptions.
Use Cases
- IT operations teams conducting regular checks and maintenance of SSL certificates for company or client websites
- DevOps teams automating the lifecycle management of security certificates across multiple sites
- Enterprises and organizations that need to ensure website security and avoid access issues caused by expired certificates
Main Process Steps
- Scheduled Trigger (Weekly Trigger): Automatically initiates the workflow every Monday at 8:00 AM.
- Fetch URLs to Monitor: Retrieves the list of URLs to be checked from a designated Google Sheets document.
- Check SSL Certificate Status: Calls the SSL-Checker.io API to obtain certificate expiry dates and remaining validity days for each URL.
- Update Certificate Information: Writes the latest certificate expiry data back to the corresponding Google Sheets table.
- Expiry Evaluation: Determines whether any certificates are due to expire within 7 days.
- Send Alert Email: Automatically sends reminder emails to specified recipients if any certificates are nearing expiration, including details of the host and remaining days.
Systems and Services Involved
- Google Sheets: Stores and updates the list of URLs and their certificate information
- SSL-Checker.io API: Provides real-time SSL certificate status checks
- Gmail: Sends expiry alert emails
Target Users and Value
- IT Operations and DevOps Engineers: Simplify SSL certificate management workflows and avoid security risks and service downtime caused by expired certificates
- Website Administrators and Security Teams: Ensure website security compliance and respond promptly to certificate renewal needs
- Small to Medium Enterprises and Multi-site Managers: Reduce manual monitoring costs through automation and improve operational efficiency
By seamlessly integrating Google Sheets with SSL monitoring services, this workflow achieves fully automated certificate tracking, enabling users to proactively mitigate risks and ensure secure, stable website operations.
TheHive
This workflow integrates the security incident response platform TheHive, enabling the automatic creation and reading of security alerts, as well as the sending and resolution of alert notifications through the SIGNL4 service. Its highlights include the use of Webhooks for real-time triggering and conditional judgment, automating the management of security incidents to enhance response efficiency and accuracy. It is suitable for information security teams and Security Operations Centers (SOC), helping enterprises quickly monitor and address security threats, ensuring smooth and efficient information security operations.
Manually Trigger Rundeck Job Execution Workflow
This workflow allows for the quick invocation of specified automated tasks through manual triggering, enabling the execution of preset tasks without the need to log into the console. It is simple to operate and responds quickly, making it suitable for operations, development, and business teams that need to trigger processes instantly, significantly enhancing the convenience and efficiency of task execution. Its design aims to help users manage automated tasks flexibly and efficiently, optimizing workflows.
Click to Execute Trigger for SIGNL4 Alert Sending
This workflow is manually triggered to quickly send customized alerts to SIGNL4, enabling instant notifications. It is easy to operate; simply click the "Execute" button to send the alert, enhancing response efficiency. It addresses the issue of delayed notifications for urgent events, ensuring that critical alerts are rapidly communicated to the relevant personnel. It is suitable for scenarios such as operations monitoring, emergency response, and security alerts. This workflow is particularly well-suited for teams that need to swiftly handle unexpected incidents, simplifying the alert sending process and improving incident response speed and handling efficiency.
n8n Workflow Automated Backup to Google Drive
The main function of this workflow is to automate the backup of all workflow data, ensuring data security and recoverability. It is scheduled to run daily at 1:30 AM, checking whether a backup already exists in Google Drive, and performing the initial backup or updating existing files. The backup content is saved in JSON format for easy management, and status notifications are sent via email and Discord to ensure users are promptly informed of the backup results. The use of batch processing and an error retry mechanism enhances the stability and efficiency of the backup process, addressing the cumbersome issues associated with manual backups.
MCP_CALENDAR
The MCP_CALENDAR workflow integrates the Google Calendar API to provide comprehensive scheduling management features, including viewing, creating, updating, and deleting events, as well as querying available time slots on the calendar. It addresses the automation challenges of complex calendar management, eliminating the hassle of manual operations and improving the real-time accuracy of information. This workflow is suitable for business collaboration, appointment scheduling, and personal schedule management, significantly enhancing work efficiency and time management capabilities.
Send a Message on Twake
This workflow is primarily used for quickly sending messages to a specified channel in Twake, facilitating instant communication and information sharing within the team. By manually triggering the workflow, users can easily configure the message content, eliminating the hassle of manual sending and improving communication efficiency. It is suitable for scenarios such as project update notifications and urgent reminders, helping team managers and professionals effectively convey important information and enhance the immediacy and transparency of collaboration.
Parse DMARC Reports
This workflow automatically monitors and parses DMARC email reports by decompressing email attachments, extracting XML data, and converting it into structured JSON format, which is then stored in a MySQL database. It supports batch parsing of multiple records and can detect anomalies in DKIM or SPF validation in real-time, automatically sending Slack messages and email notifications to enhance email security and response efficiency. This process helps businesses quickly identify and address email fraud and security issues, streamlining compliance audits and data organization tasks.
Auth0 User Login
This workflow implements user login authentication based on Auth0, automating identity verification through the OAuth 2.0 authorization code flow. It securely handles login requests, token exchanges, and user information retrieval, simplifying complex authentication steps and ensuring that only verified users can log in securely. It supports multiple social account logins, enhancing user experience, and provides developers and businesses with a quick integration solution suitable for online services that require centralized management of user identities and permissions.