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

Learn how to integrate Razorpay with Google Sheets using Pabbly Connect. This step-by-step tutorial guides you through setting up automated payment details tracking. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Introduction to Pabbly Connect for Google Sheets Integration

Pabbly Connect is a powerful tool that automates the integration between Razorpay and Google Sheets. This integration allows you to automatically capture payment details from Razorpay into your Google Sheets. using Pabbly Connect

To get started, you first need to log into your Pabbly Connect account. If you don’t have an account, you can sign up for free and explore the features offered. Once logged in, you can create a new workflow to set up the integration.

2. Setting Up Your Workflow in Pabbly Connect

To set up the workflow in Pabbly Connect, click on the ‘Create Workflow’ button located in the top right corner of the dashboard. You will then be prompted to name your workflow. using Pabbly Connect

• Give your workflow a name, such as ‘Razorpay Payment Details in Google Sheets’.
• Select a folder for your workflow, or create a new one if necessary.
• Click on the ‘Create’ button to proceed.

After creating your workflow, you will see the trigger and action setup. The trigger will be Razorpay, and the action will be Google Sheets. This setup allows Pabbly Connect to listen for new payments and then log them in your specified Google Sheet.

3. Configuring Razorpay as the Trigger Application

In this step, you will select Razorpay as the trigger application. Click on the ‘Select App’ option and choose Razorpay. Next, select the trigger event as ‘Payment Captured’. using Pabbly Connect

Once the trigger is set, Pabbly Connect will provide you with a webhook URL. This URL needs to be added to your Razorpay account under the webhooks section. This action enables Razorpay to send payment data to Pabbly Connect whenever a new payment is made.

• Log into your Razorpay account and navigate to ‘Account Settings’.
• Select ‘Webhooks’ and click on ‘Add New Webhook’.
• Paste the webhook URL from Pabbly Connect and select the event as ‘Payment Captured’.

After saving the webhook, you can test it by making a dummy payment to ensure everything is set up correctly. Pabbly Connect will capture this payment data for the next steps.

4. Setting Up Google Sheets as the Action Application

Now that Razorpay is configured as the trigger, it’s time to set Google Sheets as the action application. In Pabbly Connect, click on ‘Select App’ and choose Google Sheets. using Pabbly Connect

Next, select the action event as ‘Add Row’. This will allow you to add a new row in your Google Sheet each time a payment is captured. You will need to connect your Google account to Pabbly Connect and authorize access to your Google Sheets.

Choose the Google Sheet where you want to record the payment details. Select the specific sheet within that Google Sheet to which the data will be added. Map the fields from Razorpay to the corresponding columns in Google Sheets.

This mapping is crucial as it ensures that the correct payment details are logged in the right columns. Once the mapping is complete, you can save the action settings.

5. Testing and Finalizing the Integration

With both the trigger and action set up, it’s time to test the integration. Go back to your Razorpay account and make a test payment to see if the details are captured in Google Sheets.

Once the payment is made, return to Pabbly Connect and check the webhook response. If everything is configured correctly, you should see the payment details logged successfully in your Google Sheet.

Verify that the customer’s name, email, phone number, and payment amount are recorded accurately. If there are any discrepancies, revisit your mapping settings in Pabbly Connect. Once confirmed, your integration is complete and ready for use.

Now you can enjoy seamless tracking of Razorpay payments directly in Google Sheets, thanks to Pabbly Connect. This automation saves time and reduces manual entry errors.

Conclusion

In this tutorial, we explored how to integrate Razorpay with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of logging payment details, enhancing your workflow efficiency significantly.