Templates / Monitor vendor compliance documents and expiries with Google Drive, OpenAI, Sheets, Gmail, and Slack

Monitor vendor compliance documents and expiries with Google Drive, OpenAI, Sheets, Gmail, and Slack

Ready for 3.0

by Javed Iqbal ✓ · 2 views · created 2026-10-02 · 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 26 nodes and runs on Google Drive events (file created) (plus 1 other trigger). Along the way it connects Google Drive, OpenAI Chat Model, Google Sheets and Slack and 1 more.

How it runs

Trigger: On Google Drive events (file created) (plus 1 other trigger).

  1. Check If PDF (If): checks a condition and branches into true / false
  2. Set Compliance Parameters (Edit Fields (Set)): sets 7 fields: companyName, complianceOwnerEmail, complianceInbox…
  3. Download Google Drive File (Google Drive): download
  4. Notify Slack: Unsupported File (Slack): uses Slack
  5. Set Tier Requirements (Code): runs custom JavaScript code
  6. Extract Text from PDF (Extract from File): extracts data from a file (pdf)
  7. Fetch Vendors from Sheets (Google Sheets): uses Google Sheets
  8. AI Document Data Extraction (Information Extractor): extracts structured fields from text with AI, with model: OpenAI GPT-4 Chat Model
  9. Fetch Documents from Sheets (Google Sheets): uses Google Sheets
  10. Build Document Records (Code): runs custom JavaScript code

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

Services it uses

Google DriveOpenAI Chat ModelGoogle SheetsSlackGmail

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

From the author

Quick overview This workflow monitors a Google Drive folder for new vendor compliance PDFs, uses OpenAI to classify and extract key fields, logs and tracks them in Google Sheets, flags uncertain items in Slack, and runs a daily compliance check that emails…

Excerpt from Javed Iqbal'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.