Checks the certificate on every domain in your sheet each morning and emails the ones running out of time to renew.
Uses
Gmail
Google Sheets
Warn before SSL certificates expire
Run every day at 08:00.Run every day at 08:00.
Set domainSheetUrl to blank.Set domainSheetUrl to blank.Set domainSheetTab to blank.Set domainSheetTab to blank.Set certificateApiUrl to blank.Set certificateApiUrl to blank.Set alertEmail to blank.Set alertEmail to blank.Set warnWithinDays to 30.Set warnWithinDays to 30.Google SheetsRead the rows of domainSheetUrl. Save it as domainSheet.Read the rows of domainSheetUrl. Save it as domainSheet.Set sites to domainSheet.rows.Set sites to domainSheet.rows.Set expiringSoon to an empty list.Set expiringSoon to an empty list.Set couldNotCheck to an empty list.Set couldNotCheck to an empty list.
For each site in sites:For each site in sites:Set domain to blank.Set domain to blank.
If a step below fails, save the error as missingDomainIf a step below fails, save the error as missingDomainTry
Trim site.Domain and save it as domain.Trim site.Domain and save it as domain.On error
Change domain to blank.Change domain to blank.
If domain is emptyIf domain is emptyYes
Skip to the next item.Skip to the next item.No
No steps
Set daysLeft to 0.Set daysLeft to 0.Set expiresOn to blank.Set expiresOn to blank.Set wasChecked to false.Set wasChecked to false.If a step below fails, save the error as checkFailedIf a step below fails, save the error as checkFailedTry
Fetch certificateApiUrl plus domain and save it as certificate.Fetch certificateApiUrl plus domain and save it as certificate.Trim certificate.body.result.valid_till and save it as expiryDate.Trim certificate.body.result.valid_till and save it as expiryDate.
Count the days from today's date to expiryDate and save it as daysLeft.Count the days from today's date to expiryDate and save it as daysLeft.Change expiresOn to expiryDate.Change expiresOn to expiryDate.Change wasChecked to true.Change wasChecked to true.On error
Add domain - checkFailed.message with certificateApiUrl replaced by the endpoint address to the end of couldNotCheck and save it as couldNotCheck.Add domain - checkFailed.message with certificateApiUrl replaced by the endpoint address to the end of couldNotCheck and save it as couldNotCheck.If wasChecked is yes and daysLeft is less than or equal to warnWithinDaysIf wasChecked is yes and daysLeft is less than or equal to warnWithinDaysYes
If daysLeft is less than 0If daysLeft is less than 0Yes
Add domain - EXPIRED on expiresOn to the end of expiringSoon and save it as expiringSoon.Add domain - EXPIRED on expiresOn to the end of expiringSoon and save it as expiringSoon.No
Add domain - expires on expiresOn (daysLeft days left) to the end of expiringSoon and save it as expiringSoon.Add domain - expires on expiresOn (daysLeft days left) to the end of expiringSoon and save it as expiringSoon.No
No steps
Set report to blank.Set report to blank.If expiringSoon isn't emptyIf expiringSoon isn't emptyYes
Change report to Certificates expiring within warnWithinDays days:Change report to Certificates expiring within warnWithinDays days:
expiringSoon joined by a new line
.No
No steps
If couldNotCheck isn't emptyIf couldNotCheck isn't emptyYes
Change report to reportChange report to report
These sites could not be checked:
couldNotCheck joined by a new line
.No
No steps
If report is emptyIf report is emptyYes
Finish the run: Every certificate checked is valid for more than warnWithinDays more days.Finish the run: Every certificate checked is valid for more than warnWithinDays more days.No
No steps
GmailSend an email to alertEmail.Send an email to alertEmail.
Subject: SSL certificate check: the length of expiringSoon expiring within warnWithinDays daysreport