{"product_id":"n8n-workflow-google-sheets-certificate-expiry-email-alerts","title":"n8n Workflow: Google Sheets Certificate Expiry Email Alerts","description":"\u003ch3\u003eNever miss a certificate expiry again—automated Google Sheets alerts with escalating email reminders\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your Google Sheets compliance register every day at \u003cstrong\u003e7am\u003c\/strong\u003e, calculates certificate expiry dates, and automatically sends \u003cstrong\u003eurgent expiry and renewal reminder emails\u003c\/strong\u003e via SMTP—stopping silently when nothing is due.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a daily schedule\u003c\/strong\u003e (by default at 7am).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads expiry records\u003c\/strong\u003e from a Google Sheets compliance register containing expiry dates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates days remaining\u003c\/strong\u003e for each row and groups items into:\n    \u003cul\u003e\n      \u003cli\u003eAlready \u003cstrong\u003eexpired\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eWithin 7 days\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eWithin 30 days\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eWithin 90 days\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents unnecessary emails:\u003c\/strong\u003e if there are no items due or expired, it stops without sending anything.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates for urgency:\u003c\/strong\u003e if one or more items are already expired, it sends an urgent email (optionally including items expiring within 7 days).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks renewals:\u003c\/strong\u003e when no expired items exist, it sends a renewals summary email; the \u003cstrong\u003e90-day horizon list\u003c\/strong\u003e is included \u003cstrong\u003eonly on Mondays\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor certificate compliance (e.g., security or regulatory documents) stored in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSend escalating \u003cstrong\u003eexpiry alerts\u003c\/strong\u003e to owners and renewal contacts via \u003cstrong\u003eemail (SMTP)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReduce administrative overhead for SaaS operations teams and automation engineers using n8n.\u003c\/li\u003e\n  \u003cli\u003eMaintain consistent compliance checks with a schedule-triggered workflow rather than manual reviews.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e runs daily at \u003cstrong\u003e7am\u003c\/strong\u003e (cron adjustable).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e read step to load the compliance register.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e logic to calculate days remaining and group rows by expiry windows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e nodes to decide whether to stop or send emails based on due\/expired items and Monday logic.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail Send (SMTP)\u003c\/strong\u003e for alert delivery (replace the recipient like \u003cem\u003eowner@example.com\u003c\/em\u003e in both email steps).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e nodes for workflow guidance.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGoogle account access to the Sheets register.\u003c\/li\u003e\n  \u003cli\u003eSMTP (or Gmail-capable) credentials for email alerts.\u003c\/li\u003e\n  \u003cli\u003eAn n8n instance (cloud or self-hosted) capable of running the daily schedule.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916231499955,"sku":"N8N-18832","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZNwBJDuEiyCAqKpYUMo5h_wfEztUqR.png?v=1788012518","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-certificate-expiry-email-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}