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
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads the tab listing your domains, taking each value in the 'Domain' column and skipping any row without one.
- 2GmailSendSends one email listing the certificates expiring within your warning window and any domains that could not be checked.
How it works
What happens on each run, in plain English.
Every morning at 08:00, the domains listed in your spreadsheet are read, the certificate on each one is looked up through a certificate-checking service you point it at, and the days left before it expires are worked out. 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.
You get one email listing each domain that is expiring soon with its expiry date and the days remaining, and any certificate already expired is called out as such. A domain that cannot be reached, or whose answer carries no expiry date, is listed separately in the same email and never stops the rest being checked. A row with no domain is skipped. When every certificate is comfortably valid, nothing is sent.
Before the first run you need a spreadsheet tab listing your domains under a column headed 'Domain', a certificate-checking service that answers for one domain at a time, and an inbox for the warnings.
You may also be interested in
Watch your websites for downtimeChecks every site listed in a spreadsheet on a schedule and alerts you in Slack or by email when one goes down or recovers.
Record where incoming emails really came fromFor the emails your Gmail search picks out, logs whether each passed the sender checks and which servers it really came through.
Build yesterday's timesheet from what you actually didRebuilds yesterday from your calendar, sent mail and commits, and appends one evidence row to your timesheet.
Flag emails that link to unfamiliar websitesPosts to Slack when new mail links to a site outside your expected list, with how recently that site was registered and who runs it.Start from a workflow that already works.
Add "Warn before SSL certificates expire" to your workspace, connect its apps, and make it yours.
Free plan, no credit card