Warn before SSL certificates expire
Checks the certificate on every domain in your sheet each morning and emails the ones running out of time to renew.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsRead rows
- 2GmailSend
How it works
Everything the template sets up, and what to fill in before the first run.
Every morning this workflow reads the list of domains in your spreadsheet, looks up the SSL certificate for each one, and works out how many days are left before it expires. Anything inside your warning window is collected into a single email, so a renewal is booked while there is still time rather than after the site has gone down.
The warning window is the decision worth making: 30 days is the default and suits a certificate somebody has to renew by hand, while a shorter window suits one that renews automatically and only needs a nudge when the renewal has not happened. Change it in the warnWithinDays step.
Set it up by filling in four steps: the spreadsheet and the tab that list your domains under a column headed Domain, the address of the certificate-checking API to call, and the address the warnings go to. The API is a step you own rather than a service baked into the workflow - each domain is added to the end of the address you give, and the expiry date is read from the response at result.valid_till. If your endpoint names that field differently, change that one step.
A domain that cannot be reached, or whose answer carries no expiry date, is listed in the same email under 'could not be checked' and never stops the remaining domains being checked. A row with no domain in it is skipped.
You May Also Be Interested In
Log what your mail's headers record about where it came fromReads the headers of the inbound mail you name and logs the SPF, DKIM and DMARC results and where each relay address resolves.
See what your incoming mail links toLists the hosts new mail links to, leaves out the ones you expect, adds what the public registry holds on each, and posts it to Slack.
Turn reported suspicious mail into Jira ticketsOpens a Jira ticket for each message your people report, and adds later reports of the same sender to the ticket already open.
Weekly security header review of your own sitesRequests each site you list once a week, reports the security headers a visitor's browser is not getting, and emails what to fix.
Start from a workflow that already works.
Add "Warn before SSL certificates expire" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required