{"product_id":"reconcile-razorpay-upi-with-google-sheets-via-n8n-gpt-4o-slack","title":"Reconcile Razorpay UPI with Google Sheets via n8n + GPT-4o + Slack","description":"\u003ch3\u003eReconcile Razorpay UPI settlements with Google Sheets—automatically—using n8n + GPT-4o + Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reconciles Razorpay UPI payments and settlements against your invoice and bank-credit records in Google Sheets every day, flags exceptions, sends receipts and recovery emails, and posts a Slack digest for operational visibility.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule:\u003c\/strong\u003e Executes daily at \u003cstrong\u003e7:30 AM\u003c\/strong\u003e to keep your books up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads reconciliation data from Google Sheets:\u003c\/strong\u003e Pulls invoices, bank credits, the payments ledger, and existing exceptions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls Razorpay data via API:\u003c\/strong\u003e Fetches recent Razorpay payments, the settlement reconciliation report, and settlement records using pagination.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches payments to invoices:\u003c\/strong\u003e Uses stored manual overrides, invoice references, or Razorpay order IDs to link captured payments to invoices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates settlement + bank-credit status:\u003c\/strong\u003e Checks settlement and bank-credit state, calculates fees, and writes updates back to Google Sheets across the ledger, settlement, invoices, and exception records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles unmatched payments with OpenAI:\u003c\/strong\u003e For payments that don’t match, it sends plausible invoice candidates to \u003cstrong\u003eGPT-4o\u003c\/strong\u003e to generate a suggested match, then logs the suggestion as an exception (without auto-applying it).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends receipts + manages payment links:\u003c\/strong\u003e Emails payment receipts via \u003cstrong\u003eGmail\u003c\/strong\u003e for newly paid invoices and cancels any existing Razorpay payment links for paid or replaced invoices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecovers failed payments:\u003c\/strong\u003e For eligible failed cases, creates a new Razorpay payment link, uses \u003cstrong\u003eGPT-4o\u003c\/strong\u003e to draft a recovery email, sends it via Gmail, updates chase fields in Google Sheets, and escalates high-value\/final-attempt scenarios to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily reconciliation of Razorpay UPI payments to Google Sheets invoices with fee-aware ledger updates.\u003c\/li\u003e\n  \u003cli\u003eException logging for unmatched payments with GPT-4o suggested invoice matches for human review.\u003c\/li\u003e\n  \u003cli\u003eAutomated receipt delivery and payment-link recovery for failed payments, with Slack escalation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow schedule:\u003c\/strong\u003e Daily at 7:30 AM\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eRazorpay API\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (GPT-4o)\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes mentioned:\u003c\/strong\u003e set, code, gmail, slack, filter, switch\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123109515443,"sku":"N8N-20132","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/hymD2zLPnaxhrhOWOoojJ_FSjDBvDn.png?v=1790672617","url":"https:\/\/buyflowscripts.com\/products\/reconcile-razorpay-upi-with-google-sheets-via-n8n-gpt-4o-slack","provider":"N8N Commerce","version":"1.0","type":"link"}