Flag duplicate and risky AP invoices with Gmail, OpenAI and Supabase — n8n Workflow

Gemiddeld complexiteit⚡ Trigger15 knooppunten🏷️ Invoice Processingdoor Kumar SmartFlow Craft

Overzicht

🚀 How it works

Monitors your AP inbox for incoming invoices, extracts structured data with AI, runs duplicate and vendor history checks against Supabase, then scores each invoice for fraud risk — routing suspicious ones to Slack and your AP team before any payment is processed.

📬 Gmail Trigger monitors your accounts payable inbox in real time 🤖 AI Agent extracts invoice number, vendor, amount, currency, dates and line items into structured JSON — no manual data entry 🔍 Checks

Gebruikte knooppunten

SlackGmailSupabaseCodeAI AgentOpenAI Chat ModelStructured Output Parser

Workflow-voorvertoning

AP Invoice Fraud Detection

Version 1.0.0 — Finance

Processes incoming invoices from Gmail, extracts struct

Prerequisites

- Gmail account receiving invoices (Gmail OAuth2 creden

- OpenAI API key (GPT-4o)

- Supabase project with two tables:

- invoices: invoice_number, vendor_name, amount, stat

Setup Required

1. Gmail Trigger — connect Gmail OAuth2 credential

2. Extract Invoice Data — connect OpenAI credential

3. Check Duplicates + Check Vendor History — connect Su

How It Works

1. Gmail Trigger detects new invoice emails (attach PDF

2. AI Agent extracts: invoice number, vendor, amount, i

AI extracts structured invoice data from emai

Queries invoices table for existing records w

Consolidates duplicate rows into a single ite

Queries vendor history to detect unusual amou

Merges invoice data, duplicate count, and ven

AI Agent scores fraud risk using duplicate co

Routes to Slack alert path if risk requires h

Posts fraud alert to #invoice-alerts Slack ch

Logs every processed invoice to Supabase for

⚡

Gmail — Invoice Inbox

Extract Invoice Data

OpenAI — Extract

Invoice Data Schema

Check Duplicates

Count Duplicates

Check Vendor History

Merge All Context

Assess Fraud Risk

OpenAI — Risk

Fraud Risk Schema

High Risk?

Alert Slack

Send Hold Notice

Log Invoice to Supabase

15 nodes15 edges

Hoe het werkt

1
Trigger
De workflow start met een trigger-trigger.
2
Verwerking
Gegevens stromen door 15 knooppunten, connecting agent, code, gmail.
3
Uitvoer
De workflow voltooit zijn automatisering en levert het resultaat aan de geconfigureerde bestemming.

Knooppuntdetails (15)

Slack

slack

Gmail

gmail

Supabase

supabase

Code

code

AI Agent

n8n-nodes-langchain.agent

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

Structured Output Parser

n8n-nodes-langchain.outputParserStructured

Hoe deze workflow te importeren

1Klik op de knop JSON downloaden rechts om het workflowbestand op te slaan.
2Open uw n8n-instantie. Ga naar Workflows → Nieuw → Importeren uit bestand.
3Selecteer het gedownloade bestand flag-duplicate-and-risky-ap-invoices-with-gmail-openai-and-supabase en klik op Importeren.
4Stel inloggegevens in voor elk serviceknooppunt (API-sleutels, OAuth, enz.).
5Klik op Workflow testen om te controleren of alles werkt, activeer het vervolgens.

Of plak rechtstreeks in n8n → Importeren uit JSON:

{ "name": "Flag duplicate and risky AP invoices with Gmail, OpenAI and Supabase", "nodes": [...], ...}

Integraties

agentcodegmailgmailtriggeriflmchatopenaioutputparserstructuredslacksupabase

Haal deze workflow op

Download en importeer met één klik

JSON downloaden Bekijken op n8n.io

Knooppunten15

Complexiteitmedium

Triggertrigger

CategorieInvoice Processing

Gemaakt door

Kumar SmartFlow Craft

@smartflowautomate

Nieuw bij n8n?

n8n is een gratis open-source workflow-automatiseringstool. Host het zelf of gebruik de cloudversie.

n8n gratis ophalen →

Related Invoice Processing Workflows

COCOEMEX+5

medium

Automate Custom QuickBooks Invoice PDFs & Email with n8n

Standard accounting templates often fail to reflect a premium brand identity. This sophisticated n8n workflow bridges the gap between financial record-keeping and professional client presentation. By moving beyond the native limitations of QuickBooks Online, this automation enables businesses to generate high-end, multi-page PDF invoices that align perfectly with their corporate styling. The process begins the moment a new invoice is generated in QuickBooks, triggering a webhook that captures real-time billing data. The workflow then utilizes advanced HTML-to-File conversion and custom Code nodes to structure data into a polished, branded layout. It handles complex logic such as line-item merging and multi-page formatting automatically. Once the document is rendered, the system bypasses generic 'no-reply' senders by routing the finalized PDF through your preferred email provider. This ensures a seamless, white-labeled experience for your clients while eliminating the manual overhead of exporting, styling, and attaching files. Ideal for agencies and service providers, this flow guarantees that your most frequent touchpoint—the bill—is as professional as your work. **Common Use Cases:** - High-end creative agencies requiring bespoke, white-labeled billing documents for premium clients. - Automated recurring subscription billing where custom tax disclosures or localized branding are required. - Service-based businesses needing to attach dynamic project reports or terms of service directly to QuickBooks invoices.

🔗 Webhook·12 nodes