Want to remove cancelled transaction from Google Sheet

[ankitbat]

Hello Team,

I have created one workflow where I am inserting the all payments related detailed captured in Razorpay in our designated Google sheet, which is working properly but that is capturing Captured and Cancelled both details. I want to remove the cancelled payment details or dont want to capture Cancelled order details either by user or by admin cancelled it.

Kindly help to write the or redesign the workflow.

My workflow url is : https://connect.pabbly.com/workflow...dBmNfS1JWAVcHdFRZCCRUV1UvVBkIO1ceCjkKVFhwVTQ#

I have created another workflow for updating the sheet which is not working here is the link of that too:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

I request you to please provide the proper workflow at the earliest to close this task.

--Abhishek
Tech Team Lead

 

[Subin]

Hey @ankitbat !

For your Razorpay concern, you can simply apply a Filter module after your trigger step with the conditions as follows-

Here is a video tutorial for your reference-

Further, can you let us know what issue you are facing with the workflow "Woocommerce Order Updated "?

As we can see that the workflow is setup correctly and you just need to Enable the workflow to check on the workflow is working correctly in automation or not-

Do check and let us know about it.

 

[ankitbat]

When I am enabling this workflow and test it is deleting all the below entries after that ID encountered.

Please help me to create and show a demo workflow with this flow.

 

[Subin]

Hey @ankitbat !

Sure, when a new response is captured in the trigger response, you would be required to click on SAVE once in other applications, so it doesn't slip on the mapped data.