Monitor SSL certificate expiry with Google Sheets, Slack, Gmail and Jira
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets, Jira Software, Slack and Gmail.
How it runs
Trigger: On a schedule (every day at 08:00).
- Read Domain List (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Loop Over Domains (Loop Over Items (Split in Batches)): loops over the items in batches
- Aggregate Daily Summary (Code): runs custom JavaScript code
- Fetch SSL Details (HTTP Request): calls an HTTP API
- Slack: uses Slack
- Calculate Days Left (Code): runs custom JavaScript code
- Needs Alert (If): checks a condition and branches into true / false
- Create Jira Ticket (Jira Software): uses Jira Software
- Log Healthy Cert (Google Sheets): append or update
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Jira Software
n8n-nodes-base.jira - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs daily to check SSL certificate expiry for domains listed in Google Sheets, using ssl-checker.io to fetch certificate details, then creating Jira issues and sending Slack and Gmail alerts for risky certificates while logging…