{"product_id":"gmail-coi-tracking-automation-deepseek-sheets-alerts","title":"Gmail COI Tracking Automation: DeepSeek + Sheets + Alerts","description":"\u003ch3\u003eAutomate COI Tracking from Gmail—Extract, Log, and Alert Instantly\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically monitors your \u003cstrong\u003eGmail\u003c\/strong\u003e for vendor Certificate of Insurance (COI) emails, uses \u003cstrong\u003eDeepSeek (OpenAI-compatible)\u003c\/strong\u003e to extract policy details, records everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends compliance confirmations or renewal\/gap alerts via \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eDiscord\u003c\/strong\u003e, and critical \u003cstrong\u003eTelegram\u003c\/strong\u003e escalations.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every minute\u003c\/strong\u003e to check for new \u003cem\u003eunread\u003c\/em\u003e COI-related emails in your Gmail inbox.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes sender, subject, and plain-text body\u003c\/strong\u003e for consistent processing.\u003c\/li\u003e\n  \u003cli\u003eIf the email contains enough information, \u003cstrong\u003eDeepSeek extracts COI fields\u003c\/strong\u003e into structured JSON, including vendor, carrier, policy, limits, additional insured, and effective\/expiration dates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and parses\u003c\/strong\u003e the AI output. If parsing fails, it alerts a \u003cstrong\u003eDiscord\u003c\/strong\u003e channel and emails an internal address for review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes compliance status\u003c\/strong\u003e by checking required coverage rules: GL and auto at \u003cstrong\u003e1M\u003c\/strong\u003e, workers’ comp, additional insured, and \u003cstrong\u003edays until expiration\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf compliant: \u003cstrong\u003eemails the vendor\u003c\/strong\u003e a confirmation, \u003cstrong\u003eappends the record\u003c\/strong\u003e to the “COI Registry” \u003cstrong\u003eGoogle Sheet\u003c\/strong\u003e, and posts a compliant update to \u003cstrong\u003eDiscord\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf expired, expiring soon, or missing required coverage: logs to the registry, \u003cstrong\u003eemails a tailored reminder\u003c\/strong\u003e to the vendor, posts an attention alert to \u003cstrong\u003eDiscord\u003c\/strong\u003e, and sends a \u003cstrong\u003ecritical Telegram alert\u003c\/strong\u003e for expired\/critical cases.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily scheduled sweep\u003c\/strong\u003e reads the “COI Registry” and emails reminders for certificates expiring within \u003cstrong\u003e45 days\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce manual COI review by turning vendor emails into structured compliance records automatically.\u003c\/li\u003e\n  \u003cli\u003eCentralize your “COI Registry” in Google Sheets with clear compliance outcomes and dates.\u003c\/li\u003e\n  \u003cli\u003eEnsure renewals never slip through by triggering Gmail vendor reminders and team alerts in Discord\/Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e Gmail, DeepSeek (OpenAI-compatible), Google Sheets, Discord, Telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e if, code, gmail, discord, split out\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45877626405043,"sku":"N8N-18553","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vvQclTLOhlatelIx3l6j_sldjSpW8.png?v=1787337361","url":"https:\/\/buyflowscripts.com\/products\/gmail-coi-tracking-automation-deepseek-sheets-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}