Manage Razorpay Payments Instantly in Google Sheets

Learn how to manage Razorpay payments in Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To start managing Razorpay payments in Google Sheets, you first need to access Pabbly Connect. If you’re a new user, visit Pabbly.com/connect and sign up for free. This will give you access to 100 tasks free every month, allowing you to explore the platform.

Once you’ve signed up, log into your account and navigate to the workflow builder. This is where you will set up the integration between Razorpay and Google Sheets using Pabbly Connect. The workflow builder is the core interface where you will define triggers and actions for your automation.

2. Setting Up the Trigger with Razorpay

In the workflow builder of Pabbly Connect, the first step is to set up a trigger. Click on the ‘Add Trigger’ button and search for Razorpay. Select Razorpay as the trigger application and choose the event as ‘Payment Captured’. This event will initiate the workflow whenever a payment is successfully received.

• Search for Razorpay in the trigger application section.
• Select ‘Payment Captured’ as the event.
• Click on ‘Connect’ to generate a webhook URL.

Once you have copied the webhook URL, head over to your Razorpay dashboard. Navigate to the ‘Settings’ section, then to ‘Webhooks’, and click on ‘Add New Webhook’. Paste the webhook URL you copied earlier and create the webhook. This establishes a connection between Razorpay and Pabbly Connect.

3. Testing the Webhook Response

To ensure that the integration works correctly, you need to test the webhook response. After creating the webhook in Razorpay, Pabbly Connect will show a message indicating it is waiting for a webhook response. To trigger this, perform a test transaction.

Purchase a product using your Razorpay payment link. Enter your payment details and complete the transaction. After the transaction is successful, Pabbly Connect will capture the payment details, including the name, email, and phone number associated with the transaction.

4. Adding Google Sheets as an Action Step

Now that you have successfully set up the trigger, the next step is to add Google Sheets as an action in your workflow. Click on ‘Add New Action Step’ and search for Google Sheets. Select it and choose the event as ‘Add New Row’. This step will allow you to add payment details directly into your Google Sheets.

• Select ‘Add New Row’ as the action event.
• Connect your Google account to Pabbly Connect.
• Choose the spreadsheet and the specific sheet to add data.

After connecting, map the payment details captured from Razorpay into the corresponding fields in your Google Sheet. This mapping ensures that every new payment entry updates dynamically in your spreadsheet.

5. Finalizing the Integration

Once you’ve mapped the necessary fields, click on ‘Save and Send Test Request’ to finalize the integration. Pabbly Connect will send the captured payment details to your Google Sheets. You should see the new payment entry appear in your selected spreadsheet.

This integration will now run in the background. Whenever a new payment is received through Razorpay, the details will be automatically added to your Google Sheets without any manual input. You can now efficiently manage your Razorpay payments using Pabbly Connect.

Conclusion

In this tutorial, we explored how to manage Razorpay payments instantly in Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the process of tracking payments, saving time and effort. Start your free trial of Pabbly Connect today and streamline your payment management!