How it works

1. A schedule starts the workflow every day. 2. Google Sheets - Get Rows reads the list of site addresses (a column named URL). 3. For each site, an HTTP request asks a public SSL checker for the certificate details. 4. Parse JSON turns the answer into fields. 5. If the days left are 7 or fewer, Gmail sends a warning email naming the site and the days remaining.