# Weekly SSL certificate monitoring with email alerts and Google Sheets updates
This automation helps system administrators and DevOps engineers proactively track SSL certificate expiration dates across domains, preventing outages and security risks. It runs on a weekly schedule, pulls URLs from Google Sheets, checks certificate status via API, and sends email alerts when renewal is critical.
## Who it´s for
- System administrators managing website infrastructure
- DevOps engineers overseeing service security
- IT specialists in small and mid-sized businesses without dedicated SSL monitoring
## What the automation does
- Triggered weekly via cron schedule
- Reads a list of URLs from Google Sheets
- Checks SSL certificate expiry using ssl-checker.io API
- Sends a Gmail alert if 7 or fewer days remain
- Updates the original sheet with current status and check date
- Maintains a centralized, team-accessible certificate registry
## What´s included
- Ready-to-use n8n workflow
- Pre-configured trigger and conditional logic
- Integrations with Google Sheets, Gmail, and ssl-checker.io
- Basic setup and adaptation guide
## Requirements for setup
- n8n account (cloud or self-hosted)
- Access to a Google Sheet containing target URLs
- Gmail account for sending alerts
- API key for ssl-checker.io (if required by usage limits)
## Benefits and outcomes
- Prevents website downtime due to expired SSL certificates
- Centralized tracking of certificate statuses
- Timely email alerts one week before expiry
- Reduces manual checks and human error
- Easy to deploy for small teams and freelancers
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet