Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

How to Log Razorpay Purchases Automatically in Google Sheets

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin integrating Razer Pay with Google Sheets, you first need to access Pabbly Connect. Open your browser and navigate to the Pabbly Connect landing page at pabbl.com/connect.

If you are a new user, click on the “Sign Up for Free” button in the top right corner. This allows you to explore 100 tasks free every month, enabling you to create and test your automation.

2. Creating a Workflow in Pabbly Connect

Once logged in to Pabbly Connect, you will be directed to the workflow builder. This is where you will set up your automation. Click on the “Add Trigger” button to start.

Select Razer Pay as the trigger application.
Choose “Payment Captured” as the event.
Click on “Connect” to proceed.

After setting up the trigger, copy the webhook URL provided by Pabbly Connect. You will need this for the next step.

3. Setting Up Webhook in Razer Pay

Now, navigate to your Razer Pay dashboard. Go to “Account and Settings” on the left side menu, then select “Webhooks.” This is where you will add the webhook URL you copied from Pabbly Connect.

Click on “Add New Webhook”.
Paste the URL into the provided field.
Set the active event to “Payment Captured” and click “Create Webhook”.

After successfully adding the webhook, return to Pabbly Connect and proceed to the next step.

4. Capturing Webhook Response

To capture the webhook response, you need to make a test purchase. Enter your details to buy a product, such as a dress, and complete the payment process.

Once the payment is successful, Pabbly Connect will capture the webhook response, allowing you to see the details of the transaction. This includes the order ID, name, email, phone number, and payment method.

5. Adding Data to Google Sheets

Next, you need to add the captured data to Google Sheets. In your Pabbly Connect workflow, click on “Add New Action Step” and select Google Sheets as the action application.

Choose “Add New Row” as the event.
Connect your Google account.
Select the appropriate spreadsheet and sheet where you want the data to be added.

Map the data from the previous step to the respective fields in Google Sheets. Finally, click on “Save and Send Test Request” to confirm that the data is added successfully.

Conclusion

In this tutorial, we explored how to integrate Razer Pay with Google Sheets using Pabbly Connect. This automation allows you to capture payment details instantly and manage them efficiently in Google Sheets. By following these steps, you can enhance your workflow and save time on data entry.