Monitor website HTTPS and certificate health from Google Sheets with Slack and Gmail alerts
Ready for 3.0What this workflow does
This workflow has 23 nodes and runs on a schedule (every week at 07:00) (plus 2 other triggers). Along the way it connects Google Sheets, Slack and Gmail. It also calls weio.ai over HTTP.
How it runs
Trigger: On a schedule (every week at 07:00) (plus 2 other triggers).
- Settings (Edit Fields (Set)): sets 11 fields: sheet_url, sites_tab, history_tab…
- Slack: uses Slack
- Read client sites (Google Sheets): read
- Clean and dedupe sites (Code): runs custom JavaScript code
- Cap sites per run (Limit): keeps the first few items
- Loop over sites (Loop Over Items (Split in Batches)): loops over the items in batches
- New or worse critical (Filter): keeps only the items that match a condition
- Group issues by client (Code): runs custom JavaScript code
- Build team digest (Code): runs custom JavaScript code
- Check HTTPS (HTTP Request): calls weio.ai
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: weio.ai
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (15)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Limit
n8n-nodes-base.limit - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Stop and Error
n8n-nodes-base.stopAndError - Wait
n8n-nodes-base.wait - Filter
n8n-nodes-base.filter - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow runs weekly (or manually) to read a list of client websites from Google Sheets, check each site’s HTTPS and certificate status via weio.ai, write results back to the sheet, and send Slack and Gmail alerts for new or ongoing…