Monitor SSL certificate expiry with Google Sheets and SMTP email alerts

by M Ayoub ✓ · 180 views · created 2026-01-09 · SecOps

What this workflow does

This workflow has 12 nodes and runs on a schedule (every 3 days at 10:00). Along the way it connects Google Sheets.

How it runs

Trigger: On a schedule (every 3 days at 10:00).

1. Read Domain List from Google Sheets (Google Sheets): uses Google Sheets
2. Prepare Domain List and Set Threshold (Code): runs custom JavaScript code
3. Split Into Individual Domains (Code): runs custom JavaScript code
4. Check SSL Certificate via OpenSSL (Execute Command): runs a shell command on the n8n host
5. Parse SSL Results and Identify Expiring Certs (Code): runs custom JavaScript code
6. Has Expiring Certificates (If): checks a condition and branches into true / false
7. Split Results for Sheet Update (Code): runs custom JavaScript code
8. Build HTML Email Alert (Code): runs custom JavaScript code
9. Update Google Sheet with Results (Google Sheets): append or update
10. Send Alert Email via SMTP (Send Email): sends an email over SMTP

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (7)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Execute Commandn8n-nodes-base.executeCommand
• Ifn8n-nodes-base.if
• Send Emailn8n-nodes-base.emailSend
• No Operation, do nothingn8n-nodes-base.noOp

From the author

Who is this for? DevOps engineers, sysadmins, and website owners who manage multiple domains and need proactive SSL certificate expiration monitoring without manual checks. What it does Automatically monitors SSL certificates across multiple domains, tracks…

View the original on n8n.io → Check your own copy