Templates / Track vendor insurance COIs and renewals with Gmail, DeepSeek, Sheets, Discord, and Telegram

Track vendor insurance COIs and renewals with Gmail, DeepSeek, Sheets, Discord, and Telegram

Ready for 3.0

by Khaisa Studio ✓ · 15 views · created 2026-08-21 · Document Extraction, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 39 nodes and runs on Gmail events (plus 2 other triggers). Along the way it connects Gmail, OpenAI Chat Model, Google Sheets and Discord and 1 more.

How it runs

Trigger: On Gmail events (plus 2 other triggers).

  1. Normalize COI Email (Code): runs custom JavaScript code
  2. Read COI Registry (Google Sheets): uses Google Sheets
  3. Read Registry for Digest (Google Sheets): uses Google Sheets
  4. If: checks a condition and branches into true / false
  5. Compute Renewal Needs (Code): runs custom JavaScript code
  6. Compute Digest Stats (Code): runs custom JavaScript code
  7. AI COI Compliance Agent (AI Agent): runs an AI agent, with model: DeepSeek COI Model
  8. Alert Invalid COI Email on Discord (Discord): work with message
  9. If: checks a condition and branches into true / false
  10. AI Digest Writer (AI Agent): runs an AI agent, with model: DeepSeek Digest Model

…plus 24 more steps. See the full node list below.

Services it uses

GmailOpenAI Chat ModelGoogle SheetsDiscordTelegram

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 (11)

From the author

Quick Overview This workflow monitors a Gmail inbox for vendor certificate of insurance (COI) emails, uses the DeepSeek (OpenAI-compatible) model to extract policy details, logs results to Google Sheets, and sends compliance confirmations or renewal/gap…

Excerpt from Khaisa Studio's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.