Flag possible duplicate supplier invoices in Google Sheets before payment with Slack alerts

Go to Workflow
0 views
Built by Jessy Mariau Jessy Mariau
Created on October 18, 2026

Description

Quick overview
Each weekday before the payment run, I flag invoice pairs in your sheet that look like one bill: same number and amount, same number with a different amount, or the same amount under a new number within 45 days. New pairs go to a review tab and Slack.

How it works
A schedule runs at 08:00 on weekdays.
I read your invoice tab once.
I tidy supplier names (Ltd, Limited and punctuation stop mattering) and invoice numbers (INV-000123 matches 123), then compare every pair from the same supplier. Credit notes are left out of the same-amount check.
I drop any pair already in your Possible duplicates tab, so a pair you have looked at is not raised again tomorrow.
I write each new pair to that tab and send Slack one message listing them.

Setup
Connect Google Sheets and Slack.
In the same spreadsheet, add a Possible duplicates tab with the 11 headers listed in the main sticky.
In Settings, paste the sheet URL and set the four column names to match your invoice tab. The defaults match the sheet my free invoice extractor fills.
Run it once by hand and read the tab. If it flags too much, lower dateWindowDays.

Requirements
A Google Sheet of supplier invoices and a Slack workspace.

Customization
Read from your accounting system's bills export instead of a sheet, keeping the four column names. Post to email instead of Slack if the person who pays is not in Slack.

Additional info
Built by Fractional HQ. If your invoices arrive as PDFs in Gmail, my free template reads them into this sheet first: https://n8n.io/workflows/18603. If you want the whole accounts payable flow built, send me a brief at https://fractionalhq.uk/brief

If the figures you check arrive as PDF reports with tables, my paid template pulls those tables into Google Sheets and checks the totals in code first: https://n8n.io/workflows/19346

If you would rather not set it up yourself, I can set it up for you on your own n8n account for £49. Tell me what you use at https://fractionalhq.uk/brief and I will reply with what I need from you before any work starts.

This workflow was created by Jessy Mariau and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.

Nodes Used (3)

Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
Slack
n8n-nodes-base.slack