Templates / Monitor SSL certificate expiry with Google Sheets, Slack, Gmail and Jira

Monitor SSL certificate expiry with Google Sheets, Slack, Gmail and Jira

Ready for 3.0

by Avkash Kakdiya ✓ · 8 views · created 2026-06-09 · SecOps

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Read Domain List (Google Sheets): uses Google Sheets
  2. Filter: keeps only the items that match a condition
  3. Loop Over Domains (Loop Over Items (Split in Batches)): loops over the items in batches
  4. Aggregate Daily Summary (Code): runs custom JavaScript code
  5. Fetch SSL Details (HTTP Request): calls an HTTP API
  6. Slack: uses Slack
  7. Calculate Days Left (Code): runs custom JavaScript code
  8. Needs Alert (If): checks a condition and branches into true / false
  9. Create Jira Ticket (Jira Software): uses Jira Software
  10. Log Healthy Cert (Google Sheets): append or update

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsJira SoftwareSlackGmail

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)

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…

Excerpt from Avkash Kakdiya's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.