Log Payments from Razorpay to Google Sheets Using Pabbly Connect

Learn how to log payments from Razorpay to Google Sheets using Pabbly Connect with this step-by-step tutorial. Automate your payment logging effortlessly! Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To log payments from Razorpay to Google Sheets, start by accessing Pabbly Connect. Open a new tab in your browser and go to Pabbly.com/connect. This platform allows you to integrate various applications without any coding skills.

Once on the Pabbly Connect page, you can either sign up or log in if you already have an account. Click on the ‘Sign Up’ button for new users to get 100 free tasks, or ‘Sign In’ if you are an existing user. After logging in, navigate to the Pabbly Connect dashboard to begin creating your workflow.

2. Creating Your Workflow in Pabbly Connect

After logging in to Pabbly Connect, select the option to create a new workflow. Name your workflow something like ‘Log Payments from Razorpay to Google Sheets’ and choose a folder for organization. Click the ‘Create’ button to proceed.

• Choose Razorpay as your trigger application.
• Select the event as ‘Payment Captured’.
• Click on the ‘Connect’ button to generate a webhook URL.

Copy the generated webhook URL from Pabbly Connect and head to your Razorpay account. This is where you will set up the webhook to capture payment details automatically.

3. Setting Up Webhook in Razorpay

In your Razorpay dashboard, navigate to the account settings and find the webhooks section. Click on the ‘Add New Webhook’ button. Paste the webhook URL you copied from Pabbly Connect into the appropriate field.

• Set the action event as ‘Payment Captured’.
• Click on the ‘Create Webhook’ button to save your settings.

Once the webhook is saved, Razorpay will start sending payment data to Pabbly Connect whenever a payment is captured, allowing you to automate the logging process.

4. Mapping Data to Google Sheets

Now that Razorpay is set up to send data to Pabbly Connect, the next step is to map this data to Google Sheets. Add a new action step in your workflow and select Google Sheets as the action application.

Choose ‘Add New Row’ as the action event. Connect your Google account to Pabbly Connect. Select the Google Sheet you want to log payments into.

Map the fields from Razorpay to the corresponding columns in your Google Sheet, ensuring that all necessary information like first name, last name, email, and amount are correctly aligned. After mapping, click on the ‘Save and Send Test Request’ button to verify that data is being logged correctly.

5. Completing the Automation Setup

After testing the integration, ensure that the send on event option is activated in Pabbly Connect. This ensures that every successful payment captured by Razorpay will automatically create a new entry in your Google Sheet.

Your automation is now complete! With Pabbly Connect, you can effortlessly log payments from Razorpay to Google Sheets, allowing for seamless data management and tracking.

Conclusion

In this tutorial, we explored how to log payments from Razorpay to Google Sheets using Pabbly Connect. This integration automates the logging process, making it easier to manage your payment data efficiently. By following these steps, you can streamline your payment tracking effortlessly.