Detect duplicate invoice PDFs from Gmail with easybits and Google Sheets

How It Works This workflow automatically detects duplicate invoices from Gmail. Incoming PDF attachments are scanned by the easybits AI Extractor, then checked against the Master Finance File in Google Sheets. Duplicates trigger a Slack alert – new invoices get added to the sheet.

Flow overview: 1. Gmail picks up new emails labeled as invoices (polls every minute) 2. The PDF attachment is extracted and converted to base64 3. easybits Extractor reads the document and returns structured data 4. The invoice number is compared against all existing entries in Google Sheets 5. If duplicate → Slack DM alert to felix.sattler 6. If new → Invoice is appended to the Master Finance File

---

Step-by-Step Setup Guide

1. Set Up Your easybits Extractor Pipeline Before connecting this workflow, you need a configured extraction pipeline on easybits.

1. Go to [extractor.easybits.tech](https://extractor.easybits.tech) and click "Create a Pipeline". 2. Fill in the Pipeline Name and Description – describe the type of document you're processing (e.g. "Invoice / Receipt"). 3. Upload a sample receipt or invoice as your reference document. 4. Click "Map Fields" and define the following fields to extract: - invoicenumber (String) – Unique identifier of the invoice, e.g. IN-2026-0022514 - totalamount (Number) – Total amount due on the invoice, e.g. 149.99 5. Click "Save & Test Pipeline" in the Test tab to verify the extraction works correctly. 6. Go to Pipeline Details → View Pipeline and copy your Pipeline ID and API Key.

---

2. Connect the easybits Node in n8n 1. Open the HTTP Request node in the workflow. 2. Replace the Pipeline ID in the URL with your own. 3. Set up a Bearer Auth credential with your API Key.