Monitor SSL certificate expiries with Google Sheets, Slack and Linear

How it works

8AM daily trigger - Read domains from Google Sheet - Check each domain's SSL certificate - Filter: only domains expiring within 30 days or already expired - Classify severity (expired / critical / warning / notice) - Send one digest message to Slack - Create a Linear issue[or Jira ticket] per critical or expired domain - Append all flagged domains to the logs sheet

Set up steps

Setup takes about 8–12 minutes.

1. Google Sheets

Create a spreadsheet with two sheets or [download this](https://docs.google.com/spreadsheets/d/1aVLaF711Un6KVPbRfiyJqZxa1m-VsNvovuz2cP0or8/edit?usp=sharing):

Sheet 1 is called domains and sheet 2 logs

2. Import the workflow