{"product_id":"n8n-https-website-monitoring-google-sheets-to-slack-gmail-alerts","title":"n8n HTTPS Website Monitoring: Google Sheets to Slack \u0026 Gmail Alerts","description":"\u003ch3\u003eWeekly HTTPS \u0026amp; Certificate Monitoring with Google Sheets → Slack + Gmail Alerts\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e checks the HTTPS reachability and TLS certificate status of your client websites from a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e list—then automatically logs results back to the sheet and sends \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e alerts when problems appear or persist.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules or manual runs:\u003c\/strong\u003e executes every \u003cstrong\u003eMonday at 08:00\u003c\/strong\u003e (or when you trigger it manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads alert settings:\u003c\/strong\u003e reads thresholds and the digest email address from your configuration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads websites from Google Sheets:\u003c\/strong\u003e keeps only rows where \u003cstrong\u003ewebsite\u003c\/strong\u003e is non-empty and not marked inactive (e.g., \u003cem\u003eactive\u003c\/em\u003e set to “no”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks HTTPS + certificate health via weio.ai:\u003c\/strong\u003e calls the \u003cstrong\u003eweio.ai HTTPS check API\u003c\/strong\u003e for each website (batched one at a time with a delay) to evaluate reachability, HTTPS redirect behavior, and certificate validity\/expiry.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies severity:\u003c\/strong\u003e maps each result to \u003cstrong\u003eok\u003c\/strong\u003e, \u003cstrong\u003ewarning\u003c\/strong\u003e, or \u003cstrong\u003ecritical\u003c\/strong\u003e, compares against the previous status stored in the sheet, and timestamps the check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites back to Google Sheets:\u003c\/strong\u003e updates the matching rows with severity, HTTPS status, detailed info, certificate expiry, and \u003cstrong\u003echecked_at\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts on changes:\u003c\/strong\u003e sends an \u003cstrong\u003eurgent Slack message\u003c\/strong\u003e for any \u003cstrong\u003ecritical\u003c\/strong\u003e issue that is new or changed since the last run; sends a \u003cstrong\u003esingle Gmail digest\u003c\/strong\u003e listing all non-ok sites.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e if execution fails, posts an error notification to Slack using an \u003cstrong\u003eError Trigger\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators monitoring customer sites for \u003cstrong\u003eHTTPS downtime\u003c\/strong\u003e, \u003cstrong\u003eredirect issues\u003c\/strong\u003e, or \u003cstrong\u003ecertificate expiry\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers centralizing website security checks into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with \u003cstrong\u003eSlack\u003c\/strong\u003e\/\u003cstrong\u003eGmail\u003c\/strong\u003e notifications.\u003c\/li\u003e\n  \u003cli\u003eWeekly reporting workflows for managed services teams.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, and \u003cstrong\u003eweio.ai\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146435678387,"sku":"N8N-20218","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/uzNwazivxZJY9rffi1np0_dwyqxdpE.png?v=1790846847","url":"https:\/\/buyflowscripts.com\/products\/n8n-https-website-monitoring-google-sheets-to-slack-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}