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

Automatically Add Razorpay Payment Details to Google Sheets

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the process of automatically adding Razorpay payment details to Google Sheets, you need to access Pabbly Connect. Open your browser and navigate to pav.com/connect. This will take you to the Pabbly Connect homepage.

If you’re a new user, you can click on ‘Sign Up for Free’ to get started with 100 free tasks each month. Existing users should simply sign in. Once logged in, you will see all Pabbly apps, including Pabbly Connect, which you need to access for creating your automation.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, you will need to create a new workflow. Click on ‘Create from Scratch’ to start your automation. You will be prompted to describe your workflow. Enter “When a payment is received on Razorpay, add to Google Sheets”.

Select the trigger as ‘Payment Captured’ from Razorpay.
For the action, choose ‘Add a New Row’ in Google Sheets.

Once you confirm these settings, click on ‘Approve and Create’. This will generate a unique workflow link that you can use to connect Razorpay with Google Sheets through Pabbly Connect.

3. Setting Up Webhook in Razorpay

Now, you need to set up a webhook in Razorpay to connect it with Pabbly Connect. Copy the webhook URL provided in your workflow. Log in to your Razorpay account and navigate to ‘Account Settings’, then select ‘Webhooks’.

Click on ‘Add a New Webhook’.
Paste the copied URL and select ‘Payment Captured’ as the active event.

Click on ‘Create Webhook’ to finalize the setup. This establishes the connection between Razorpay and Pabbly Connect, allowing payment details to be sent automatically to Google Sheets.

4. Testing the Integration with a Payment

To test your integration, you need to make a test payment through your Razorpay payment page. Ensure it’s in test mode, fill in the necessary details, and complete a successful payment.

Once the payment is made, go back to Pabbly Connect to check if the payment details have been captured. You should see all relevant details such as name, email, contact, amount, order ID, and product purchased populated correctly.

5. Finalizing Data Entry in Google Sheets

After confirming that the payment details appear correctly in Pabbly Connect, you can now add them to Google Sheets. Start by connecting your Google account through Pabbly Connect and select the spreadsheet where you want to log the payment details.

Map the fields such as name, email, contact, and amount to the corresponding columns in your Google Sheets. Once all fields are mapped, click on ‘Save and Send Test Request’ to finalize the process.

Check your Google Sheets to ensure the new payment details have been added as expected. This completes the automation process using Pabbly Connect, allowing you to manage payments seamlessly.

Conclusion

In this tutorial, we explored how to automatically add Razorpay payment details to Google Sheets using Pabbly Connect. By following these steps, you can streamline your payment management and reduce manual data entry errors.