Automate SSL Expiry Alerts with Google Sheets & Slack

Automate SSL Expiry Alerts with Google Sheets & Slack

Enhance your domain management with our n8n workflow that automatically checks SSL certificate expirations for you. Integrating seamlessly with Google Sheets and Slack, this powerful tool ensures your SSL certificates are always up-to-date by alerting you to any approaching expiries and potential risks. Avoid website downtime and ensure peace of mind with reliable alerts and comprehensive tracking.

What this workflow does

Our SSL expiry alert automation runs every day at 08:00 to ensure your domains remain protected. Here's how it works:

• Initiates at a scheduled time, reading a list of domains from a dedicated Google Sheets "Domains" sheet.
• Uses the ssl-checker.io API to fetch live SSL certificate details for each domain.
• Evaluates the number of days remaining before certificate expiry and assigns a status: Expired, Critical, Warning, Healthy, or Unknown.
• For certificates that require immediate attention, it creates a Jira task and sends detailed alerts via Slack and Gmail.
• Logs results for healthy certificates in a Google Sheets "Log" sheet for easy tracking and future reference.
• Sends a concise summary digest of the day's SSL certificate check results to a designated Slack channel.

Use cases

• IT Managers: Automate monitoring of multiple domains for SSL certificate renewals, reducing manual checks and enhancing operational efficiency.
• SaaS Operators: Ensure service continuity by preventing SSL-related outages with timely alerts.
• Security Teams: Proactively manage certificate hygiene and avoid security vulnerabilities caused by expired SSL certificates.

Technical details

• Integrations: Google Sheets, Jira, Slack, Gmail
• Nodes used: Schedule Trigger, HTTP Request for ssl-checker.io, Google Sheets, Slack, Gmail, Jira, Code for processing logic, and IF nodes for decision-making.

Embrace automation and keep your organization secure with this robust SSL expiry alert workflow, specially designed for n8n power users looking to streamline their operations through precise SSL management and timely notifications.