Skip to content
FlowHub
FluxonLab
Google Sheets
Monitoring & Incident Responsefree

Monitor Ssl Certificate Expiry with Google Sheets and Email Alerts

by M AyoubUpdated Aug 2026
RequiresGoogle SheetsGoogle SheetsEmail (SMTP)Email (SMTP)
Share Post Share
ScSchedule Trigger (Every 3 Days at 10AM)Schedule Trigge…Read Domain List from Google SheetsRead Domain Lis…CoPrepare Domain List and Set ThresholdPrepare Domain …CoSplit Into Individual DomainsSplit Into Indi…ECCheck SSL Certificate via OpenSSLCheck SSL Certi…CoParse SSL Results and Identify Expiring CertsParse SSL Resul…CoSplit Results for Sheet UpdateSplit Results f…Update Google Sheet with ResultsUpdate Google S…IfHas Expiring CertificatesHas Expiring Ce…CoBuild HTML Email AlertBuild HTML Emai…ESSend Alert Email via SMTPSend Alert Emai…NONo Alerts Needed (All Certs OK)No Alerts Neede…1234567891011
1/5
STEPS · 11
Runs on a schedule

On a schedule, reads domains from Google Sheets, checks SSL certificate expiry via command, and emails alerts for expiring certificates.

Tags

croncomplexGoogle SheetsEmail (SMTP)SecOps
Connects
sheetsGoogle SheetsemailsmtpEmail (SMTP)
CategoryMonitoring & Incident Response
Triggercron
Complexitycomplex
Nodes12
AddedJun 14, 2026