How to Log Razorpay Payment Details in Google Sheets Using Pabbly Connect

Learn how to log Razorpay payment details into Google Sheets for e-commerce tracking using Pabbly Connect. Follow this detailed tutorial for seamless integration. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Start Integrating Razorpay and Google Sheets

To log Razorpay payment details into Google Sheets, the first step is to access Pabbly Connect. You can do this by navigating to the Pabbly Connect landing page at Pabbly.com/connect. This platform allows you to create seamless integrations without any coding knowledge.

Once on the landing page, users have the option to either sign in or sign up for a free account. For new users, the sign-up process is straightforward, providing access to numerous free tasks each month. Existing users can simply click on the sign-in button to access their dashboard.

2. Create a Workflow in Pabbly Connect

After signing in to Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create a Workflow’ button, and you will be prompted to select a workflow builder. Choose the ‘New Workflow’ option for a modern interface.

Next, name your workflow, such as ‘Log Razorpay Payment Details in Google Sheets for E-commerce Tracking’. You can also select a folder to save your workflow. Once you have entered the details, click on the ‘Create’ button to proceed to the workflow window.

• Select the workflow builder type.
• Enter a descriptive workflow name.
• Choose a folder for organization.

Now you will see the main workflow window, which includes options for triggers and actions. This is where you will set up the connection between Razorpay and Google Sheets using Pabbly Connect.

3. Set Up Trigger for Razorpay Payment Captured

In the workflow window, click on the ‘Add Trigger’ button. Search for Razorpay as your trigger application and select it. For the trigger event, choose ‘Payment Captured’ and click on the connect button.

This action generates a webhook URL that you need to copy. Navigate to your Razorpay account and go to the Developers section, then to Webhooks. Here, you will add a new webhook and paste the copied URL into the designated field.

• Select Razorpay as the trigger application.
• Choose ‘Payment Captured’ as the trigger event.
• Paste the webhook URL in the Razorpay Webhooks section.

After successfully adding the webhook, you will return to Pabbly Connect and see that it is waiting for a webhook response. This means your integration is now set up to capture payment details.

4. Test the Integration with a Sample Payment

To test the integration, you need to create a test payment. Open your Razorpay payment page and complete a purchase using the details provided in the video. Ensure that you select a payment method and complete the transaction.

Once the payment is successful, return to Pabbly Connect. You should see that the webhook response has been captured, displaying all the payment details entered during the test submission.

Navigate to the Razorpay payment page. Complete a sample payment transaction. Check Pabbly Connect for captured payment details.

This confirms that Pabbly Connect has successfully captured the payment details from Razorpay, setting the stage for the next step of logging these details into Google Sheets.

5. Add Google Sheets Action to Log Payment Details

Now that you have captured the payment details, the next step is to log these into Google Sheets. Click on ‘Add New Action Step’ and select Google Sheets as the action application. Choose the action event as ‘Add New Row’ and click on connect.

You will need to sign in to your Google account to allow Pabbly Connect to access your Google Sheets. After signing in, select the spreadsheet where you want to log the payment details, which in this case is titled ‘Razor Pay Payments’.

Select Google Sheets as the action application. Choose ‘Add New Row’ as the action event. Map the payment details into the respective columns.

After mapping all relevant fields, click on ‘Save and Send Test Request’. This action will log the payment details into your Google Sheets, confirming that the integration is functioning as expected.

Conclusion

In this tutorial, we explored how to log Razorpay payment details into Google Sheets using Pabbly Connect. By following these steps, you can automate the tracking of e-commerce transactions efficiently. This integration not only saves time but also ensures accurate record-keeping of your payment details.