Pull the daily Razorpay settlement report into Google Sheets
Fetches yesterday's Razorpay settlements over the REST API each morning, converts paise and timestamps, computes the net-of-fees figure, de-duplicates by settlement id and appends each one to a Google.
A daily schedule calls Razorpay's settlements endpoint with HTTP Basic auth — there is no Razorpay node — passing the previous day as Unix-second timestamps, which is what the API expects. The request runs with neverError and the full response so an auth failure or rate limit arrives as a status code the workflow branches on explicitly. Split Out turns the items array into one item per settlement, and a Set node converts paise to rupees, Unix seconds to a date, and computes net credited — gross minus fee minus tax — which is the figure finance matches to the bank line. Remove Duplicates on the settlement id makes re-runs and overlapping windows safe, then each settlement is appended to a Google Sheet and the net posted to Slack. Failures route to an error rail that names the missing day.
Key benefits
- ✓Yesterday's settlements are in the sheet before finance starts, without a CSV download
- ✓Net of fees and tax is computed for you — the number that actually reconciles to the bank
- ✓De-duplication by settlement id means a re-run cannot inflate the month's total
- ✓An auth failure or rate limit becomes an explicit branch, not a silent empty day
- ✓A missing day is alerted the same morning rather than discovered at month end
Use cases
- →Indian businesses reconciling Razorpay against their bank statement by hand
- →Finance teams that need a daily settlement history Razorpay's dashboard does not keep conveniently
- →Accountants preparing GST or monthly closes from gateway data
- →Anyone who has found a missing settlement day three weeks later
Integrations
Workflow preview (10 nodes)
The template's actual node layout and connections. Node parameters and credential slots unlock with the download.
What's inside (10 nodes)
A look at the node types this workflow uses. No purchase required — full parameters and credentials are yours after you buy.
From download to running in 3 steps
- 1Import. In n8n, open Workflows → menu → “Import from File” and pick the downloaded JSON.
- 2Connect. Add your own credentials on the app nodes - n8n highlights exactly which ones need them.
- 3Activate. Run it once to test, then toggle Active. The automation is live.
What you'll learn
Production levelProduction-grade: idempotency, dead-letter handling, and reconciliation included.
- •Moving data between Google Sheets, Slack and Discord in a single run
- •Adding retries and an explicit error path to external calls
- •Testing against pinned sample data before connecting anything real
Every node carries its own documentation on the canvas, plus notes explaining why the architecture was built this way, a credential setup guide, troubleshooting, and three practice exercises. Sample data comes pinned to the trigger, so you can hit Execute and watch data flow before connecting a single account.
Common questions
What exactly do I get?
The complete, ready-to-import n8n workflow as a JSON file, delivered instantly after payment. Import it into your own n8n (cloud or self-hosted), add your credentials, and it runs.
How do I import it into n8n?
In n8n, open Workflows, click the three-dot menu, choose “Import from File”, and select the downloaded JSON. Then connect your own app credentials on the highlighted nodes.
Do I need anything else for it to work?
You need your own n8n instance and accounts/credentials for the apps this workflow connects to (HTTP / REST API, Google Sheets, Slack, Discord). No coding is required.
What if it doesn't work for me?
If the file is faulty, won't import, or isn't as described, contact us within 7 days and we'll fix it or refund you - see our refund policy.
Can I modify or resell it?
You can freely adapt and use it in your own or your clients' projects. Reselling or redistributing the template file itself is not permitted.
Related templates
Build a daily digest for dashboards
Dashboards on n8n: runs on a schedule across Google Sheets, Slack, Notion and Discord, starting at "Read Recent from Notion". Summarises long text with an AI chain. 33 documented nodes.
Compile a daily digest with Google Sheets
Dashboards on n8n: runs on a schedule across Google Sheets, Discord and Slack, starting at "Read Source Feed". Runs the text through an AI chain. 24 documented nodes.
Alert on a key metric for dashboards
Dashboards on n8n: runs on a schedule across Google Sheets, Discord and Slack, starting at "Fetch Target Page". Diffs the two sides and writes only the gaps. 24 documented nodes.
Alert on stock levels: Google Sheets, scheduled
Exports on n8n: runs on a schedule across Google Sheets, Discord and Slack, starting at "Fetch Target Page". Diffs the two sides and writes only the gaps. 14 documented nodes.