{"product_id":"google-sheets-gmail-alerts-for-certification-expiry-n8n","title":"Google Sheets Gmail Alerts for Certification Expiry (n8n)","description":"\u003ch3\u003eNever miss an agent certification expiry—get automatic Google Sheets + Gmail alerts in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your Google Sheets roster every Monday at 08:00, calculates how many days remain until each agent’s certification expires, and sends a single consolidated HTML Gmail alert to your configured manager for upcoming expiries.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on schedule:\u003c\/b\u003e triggers every Monday at \u003cb\u003e08:00\u003c\/b\u003e using a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads your roster:\u003c\/b\u003e loads the configured \u003cb\u003eGoogle Sheets URL\u003c\/b\u003e and scans all rows in your agent roster.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates time to expiry:\u003c\/b\u003e computes the \u003cb\u003edays remaining\u003c\/b\u003e until each row’s \u003cb\u003eExpiry_Date\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilters expiring certifications:\u003c\/b\u003e keeps only agents whose certification expires in the range \u003cb\u003e0 to the configured threshold (days)\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBuilds an HTML summary:\u003c\/b\u003e generates an HTML table row per expiring agent and aggregates them into one list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends one email:\u003c\/b\u003e delivers a \u003cb\u003esingle consolidated HTML email\u003c\/b\u003e via \u003cb\u003eGmail\u003c\/b\u003e to the manager email you configure.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd \u003cb\u003eGoogle Sheets OAuth2\u003c\/b\u003e credentials and ensure access to your spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eAdd \u003cb\u003eGmail OAuth2\u003c\/b\u003e credentials for the account sending the alert.\u003c\/li\u003e\n  \u003cli\u003eUpdate: \u003cb\u003esheet URL\u003c\/b\u003e, \u003cb\u003emanager email\u003c\/b\u003e, and \u003cb\u003eexpiry threshold\u003c\/b\u003e (in days).\u003c\/li\u003e\n  \u003cli\u003eConfirm the sheet includes: \u003cb\u003eAgent_Name\u003c\/b\u003e, \u003cb\u003eCert_Type\u003c\/b\u003e, and \u003cb\u003eExpiry_Date\u003c\/b\u003e in \u003cb\u003edd\/MM\/yyyy\u003c\/b\u003e format.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCertification management teams who need \u003cb\u003eGoogle Sheets-driven compliance alerts\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking internal or client-facing certifications with a defined renewal window.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing \u003cb\u003eemail notifications for expiry dates\u003c\/b\u003e without manual checking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n nodes)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e (read roster)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilter\u003c\/b\u003e (keep items within the expiry threshold)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAggregate\u003c\/b\u003e (combine rows into one consolidated list)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e (send HTML email)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSet\u003c\/b\u003e (configuration\/data shaping)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSticky Note\u003c\/b\u003e (workflow guidance\/notes)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761014300851,"sku":"N8N-17807","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EqyKvDTa8ln5s3lahrBSt_V2STZU16.png?v=1785921534","url":"https:\/\/buyflowscripts.com\/products\/google-sheets-gmail-alerts-for-certification-expiry-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}