Track vendor insurance COIs and renewals with Gmail, DeepSeek, Sheets, Discord, and Telegram
Ready for 3.0What 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).
- Normalize COI Email (Code): runs custom JavaScript code
- Read COI Registry (Google Sheets): uses Google Sheets
- Read Registry for Digest (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Compute Renewal Needs (Code): runs custom JavaScript code
- Compute Digest Stats (Code): runs custom JavaScript code
- AI COI Compliance Agent (AI Agent): runs an AI agent, with model: DeepSeek COI Model
- Alert Invalid COI Email on Discord (Discord): work with message
- If: checks a condition and branches into true / false
- 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
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)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Discord
n8n-nodes-base.discord - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Split Out
n8n-nodes-base.splitOut
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…