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

Auto-Update Google Sheets When You Receive a Payment

Watch Step By Step Video Tutorial Below

1. Setup Pabbly Connect for Google Sheets Integration

To auto-update Google Sheets when you receive a payment, start by accessing Pabbly Connect. This platform allows you to create automated workflows easily. First, sign up for a free account on Pabbly Connect if you haven’t already.

Once logged in, navigate to the dashboard and select the “Create Workflow” button. This is where you will set up the integration between your payment gateway and Google Sheets. Ensure you name your workflow appropriately for easy identification.

2. Configure Your Payment Gateway with Pabbly Connect

The next step involves connecting your payment gateway to Pabbly Connect. In this tutorial, we will use Razorpay as an example. Go to the Razorpay dashboard and locate the “Webhooks” section under settings.

Add a new webhook.
Paste the webhook URL provided by Pabbly Connect.
Select the event “Payment Captured” to trigger the workflow.

After saving the webhook, you can proceed to test the integration. This ensures that every time a payment is captured, the information is sent to Pabbly Connect for further processing.

3. Test Payment Receipt to Capture Data

Now, place a test order through Razorpay to see if the data is captured correctly in Pabbly Connect. Enter your payment details and complete the transaction. Once the payment is successful, return to Pabbly Connect to check the captured response.

You should see all relevant payment information, such as customer name, email, and amount. However, note that Razorpay may return the amount with two extra zeros. To fix this, you will need to perform a mathematical operation to divide the amount by 100.

4. Map Data to Google Sheets Using Pabbly Connect

With the payment data captured, the next step is to map this data to Google Sheets. In Pabbly Connect, add a new action step and select Google Sheets as the application. Choose the “Add New Row” action event.

Connect your Google account and grant the necessary permissions. Select the spreadsheet where you want the payment details to be recorded. Map the fields from the Razorpay response to corresponding columns in Google Sheets, such as:

Payment ID
Customer Name
Email Address
Amount (corrected)

After mapping, save your workflow and test it again. This will ensure that every new payment updates Google Sheets automatically.

Conclusion: Auto-Update Google Sheets When You Receive a Payment

By following these steps, you can successfully auto-update Google Sheets when you receive a payment using Pabbly Connect. This integration eliminates manual data entry, saving you time and reducing errors. Now, every payment will automatically reflect in your Google Sheets, keeping your records organized and accurate.