SSL certificate expiry monitoring with a dashboard and email

On schedule the scenario checks the SSL certificates of every domain in a sheet, keeps a clear dashboard and sends an email if any certificate is nearing expiry.

  • A warning before expiry, not after
  • All domains in one dashboard
  • Email arrives only when there's a risk
  • You keep the domain list in a plain sheet
Google Sheets
Set it up for yourselfScriptera

How it works

To move data from Mandrill to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Schedule Trigger (Every 3 Days at 10AM)
  2. Then: Read Domain List from Google Sheets
  3. Then: Prepare Domain List and Set Threshold
  4. Then: Split Into Individual Domains
  5. Then: Check SSL Certificate via OpenSSL
  6. Then: Parse SSL Results and Identify Expiring Certs
  7. Check: Has Expiring Certificates
  8. If yes: Build HTML Email Alert
  9. Then: Send Alert Email via SMTP
  10. Then: Split Results for Sheet Update
  11. Then: Update Google Sheet with Results

You can launch this Mandrill + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios