Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Finance, Invoices & Accounting

Finance, Invoices & Accounting

Detect duplicate payment charges in Gmail with Gemini, Google Sheets and Slack

Reads payment emails from Gmail with Gemini, compares them with recent transactions in Google Sheets and posts a Slack alert when a possible double charge is found.

What it does

## Duplicate/Double-Charge Detector Across Payment Emails This workflow automatically monitors Gmail for payment emails, uses Gemini AI to extract transaction details, checks recent transactions stored in Google Sheets for possible duplicate charges, and sends a Slack alert when a potential double charge is detected. ## Setup Steps 1. Connect your Gmail account and configure the payment-email trigger. 2. Connect Gemini AI and select the required model. 3. Create a Google Sheet for storing transaction history and connect it to n8n. 4. Connect Slack and select the channel for duplicate alerts. 5. Configure the duplicate detection window (48 hours by default). 6. Test with normal payments and duplicate payments to confirm the workflow is working correctly.

The steps

  1. Update row in sheet
  2. Get Recent Transactions
  3. Payment Emails
  4. Get Payment Email
  5. Prepare Email
  6. Extract Transaction
  7. Parse Gemini Transaction
  8. Transaction Valid?
  9. Normalize Transaction
  10. Generate Transaction ID
  11. Detect Duplicate
  12. Potential Duplicate?
  13. Duplicate Charge Alert
  14. Mark Processed

18 steps in total.

Similar automations