Monitor SSL certificate expiry with Google Sheets and SMTP email alerts
Schedule Trigger (Every 3 Days at 10AM)
Read Domain List from Google Sheets
googleSheets
Prepare Domain List and Set Threshold
Split Into Individual Domains
Check SSL Certificate via OpenSSL
shell
Parse SSL Results and Identify Expiring Certs
Split Results for Sheet Update
Update Google Sheet with Results
googleSheets
Has Expiring Certificates
Build HTML Email Alert
Send Alert Email via SMTP
smtp
No Alerts Needed (All Certs OK)
noOp
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.