Connect Juspay and Google Sheets

Juspay routes your payments across gateways, and the reconciliation work usually ends up in a spreadsheet. FlowMattic writes Juspay order, refund, chargeback and mandate events into Google Sheets from your WordPress site, so finance and support can see what was paid, what came back and what still needs a decision.

Try FlowMattic free See example workflows

39 triggers 19 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Juspay33 triggers

Do this in Google Sheets19 actions

1. TriggerOrder Succeeded

2. ActionAdd New Row

When Juspay fires Order Succeeded, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Juspay and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log every successful Juspay order

Each paid order becomes a row with its order ID, amount and customer, which gives finance a daily list to match against settlement reports.

Order SucceededAdd New Row

View the template

Mark the original order when it is refunded

Look up the order ID and write the refund into that row, so the sheet shows the net position of each order rather than two unrelated lines.

Order RefundedLookup Row DataUpdate Row

Open a chargeback register

Every chargeback received is added to a Disputes tab with its order and amount, giving whoever handles disputes one place to track evidence and deadlines.

Chargeback ReceivedAdd New Row

Close a dispute row when the chargeback is canceled

When a chargeback is canceled, find its row and set the outcome, so the open disputes list only holds cases that still need work.

Chargeback CanceledLookup Row DataUpdate Cell Data

Queue refunds that need manual review

Refunds Juspay holds for review are written to a queue tab, then an email goes to the finance inbox so someone looks at them the same day.

Refund Manual Review NeededAdd New RowEmail (SMTP)

Track failed orders to spot gateway problems

Writing each failed order with its gateway and error to a sheet shows patterns early, for example one payment method failing more than the rest.

Order FailedAdd New Row

Keep a list of mandates and when they expire

Recurring payment mandates get a row when created. A second workflow on Mandate Expired finds the row and marks it, so renewals can be chased.

Mandate ExpiredLookup Row DataUpdate Row

Set up: each paid order as a row

At the end, every Juspay order that succeeds is written to your Google Sheet as one row.

Prepare the sheet
Add a header row such as Order ID, Date, Customer email, Amount, Currency, Payment method and Status.
Connect Google Sheets
In Connects, add a Google Sheets connection with an account that can edit the reconciliation sheet.
Start with Order Succeeded
Create a workflow with the Juspay Order Succeeded trigger and add the webhook it shows in your Juspay dashboard, then capture a test order.
Add New Row
Add Google Sheets Add New Row, map the order fields to the columns, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Juspay	To Google Sheets
Order ID	Order ID
Date created	Date
Customer email	Customer email
Amount	Amount
Currency	Currency
Payment method	Payment method
Status	Status

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

Each Juspay event is its own trigger, so refunds, chargebacks and mandates each need their own workflow. Build the order log first, then add the others.
Store the Juspay order ID in every row. Refund and chargeback workflows use it with Lookup Row Data to find the order they belong to.
Refund Initiated and Order Refunded can both fire for the same refund. Pick one of them for the refund column so amounts are not counted twice.

Juspay

Integration page

Triggers (33)

Order SucceededTriggers when an order is succeeded.
Order FailedTriggers when an order fails.
Order AuthorizedTriggers when an order is authorized.
Order Partial ChargedTriggers when an order is partially charged.
Order RefundedTriggers when an order is refunded.
Order Refund FailedTriggers when an order refund is failed.
Order VoidedTriggers when an order is void.
Order Void FailedTriggers when the order void fails.
Order Capture FailedTriggers when an order capture fails.
Order CreatedTriggers when an order is created.
Order UpdatedTriggers when an order is updated.
Chargeback CanceledTriggers when a chargeback is canceled.
Chargeback ExpiredTriggers when a chargeback is canceled.
Chargeback ReceivedTriggers when a chargeback is received.
Collect Request ReceivedTriggers when a collect request is canceled.
Collect Request SentTriggers when a collect request is sent.
Complaint RaisedTriggers when a complaint is raised.
Complaint ReceivedTriggers when a complaint is received.
Received MoneyTriggers when the money is received.
Refund Arn CapturedFollow the below steps to set the webhooks:Log in to your Juspay account.On your dashboard, under the "Payment" section, click on the "Setings", and switch to the "Webhook" tab.Copy the above webhook URL and paste it into the "WebHook URL" field, and select "Refund Arn Captured" as an event.Click on the "Update Webhook Settings" button.Click on the "Capture Webhook Response" button below and perform a test recording to capture the webhook response here. Learn more
Refund InitiatedTriggers when the refund is initiated.
Txn ChargedTriggers when the transaction is charged.
Txn CreatedTriggers when the transaction is created.
Txn FailedTriggers when the transaction is failed.
Notification SucceededTriggers when the notification is succeeded.
Notification FailedTriggers when the notification is failed.
Mandate CreatedTriggers when the mandate is created.
Mandate ExpiredTriggers when the mandate is expired.
Token Status UpdatedFollow the below steps to set the webhooks:Log in to your Juspay account.On your dashboard, under the "Payment" section, click on the "Setings", and switch to the "Webhook" tab.Copy the above webhook URL and paste it into the "WebHook URL" field, and select "Token Status Updated" as an event.Click on the "Update Webhook Settings" button.Click on the "Capture Webhook Response" button below and perform a test recording to capture the webhook response here. Learn more
Auto Refund InitiatedTriggers when the auto refund is initiated.
Auto Refund SucceededTriggers when the auto refund is succeeded.
Auto Refund FailedTriggers when the auto refund is failed.
Refund Manual Review NeededTriggers when the refund manual review is needed.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Juspay and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Payment events stay on your server

Order and customer details pass from Juspay through your own WordPress site to the sheet, with no outside automation account in between.

High order volume, same price

Runs are unlimited, so logging every order, refund and transaction event costs the same on a sale day as on a quiet Sunday.

One sheet for finance and support

Refunds, disputes and failures sit next to the orders they belong to, so both teams answer customer questions from the same record.

Common questions

Which Juspay events can I send to Google Sheets?

Any trigger on this page, including Order Succeeded, Order Failed, Order Refunded, Chargeback Received, Mandate Created and Refund Manual Review Needed. Each one starts its own workflow.

Can a refund update the original order row?

Yes. Start with Order Refunded, use Lookup Row Data to search the Order ID column, then Update Row to write the refund amount and date into that row.

Can I separate disputes from normal orders?

Yes. Write Chargeback Received to its own tab, and use Chargeback Canceled or Chargeback Expired to update the outcome of each dispute row.

How do I keep the sheet from getting too large?

Log only the events you act on. You can also run Export Sheet to Excel or Export sheet to CSV in a workflow to keep an archive copy in the WordPress Media Library.

Is a free Google account enough?

Yes. Any Google account with edit access to the spreadsheet works, though many finance teams use a Google Workspace account so access can be managed centrally.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Juspay and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Juspay integration 1.0.0, Google Sheets integration 2.2.4.