# Reconcile Razorpay UPI payments with Google Sheets, GPT-4o, Gmail and Slack

> Quick overview This workflow runs daily to reconcile Razorpay payments and settlements against invoice and bank-credit records in Google Sheets, logs exceptions, sends receipt emails via Gmail, creates and cancels Razorpay payment links for failed-payment recovery, uses OpenAI for match suggestions and reminder drafts, and posts a Slack digest. How it works 1. Runs every day at 7:30 AM on a schedule. 2. Loads invoices, bank credits, the payments ledger, and existing exceptions from Google Sheets. 3. Fetches recent Razorpay payments, the settlement reconciliation report, and settlement records via the Razorpay API with pagination. 4. Matches captured payments to invoices (using stored manual overrides, invoice references, or Razorpay order IDs), checks settlement and bank-credit status, calculates fees, and writes updated ledger, settlement, invoice, and exception records back to Google Sheets. 5. Sends unmatched payments with plausible invoice candidates to OpenAI to generate a suggest

- **Domain**: `n8n-workflow-20132.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20132
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20132.n8n.io
- Documentation: https://n8n.io/workflows/20132