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 Paid Students to Google Sheets After Razorpay Payment

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating your course payments, first access Pabbly Connect. This platform allows you to integrate various applications seamlessly.

Once you visit the Pabbly website, create a free account. After registration, you will receive 100 free tasks each month for testing. This is an excellent way to explore the automation capabilities offered by Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, click on the “Create Workflow” button. This is where you will set up the automation for your course payments.

Select “Create from Scratch” to build your workflow.
Name your workflow, for example, “Automatically Add Paid Students to Google Sheets After Razorpay Payment.”
Choose the folder for your workflow and click on the “Create” button.

Your workflow is now successfully created. The next step is to set up a trigger, which is essential for automation.

3. Setting Up the Trigger with Razorpay

In this section, you will configure the trigger for your workflow using Pabbly Connect and Razorpay. Select Razorpay as your trigger application.

Choose the event as “Payment Captured” and click on the connect button. A webhook URL will be provided. Copy this URL to link Razorpay with Pabbly Connect.

Navigate to your Razorpay account and click on “Developers”.
Select “Webhooks” and click on “Add New Webhook”.
Paste the copied webhook URL, select “Payment Captured” as the event, and create the webhook.

Now, you can test the connection by making a payment through Razorpay, which will trigger the workflow in Pabbly Connect.

4. Formatting the Payment Amount

After setting up the trigger, the next step involves formatting the payment amount. Razorpay does not include decimals in the amount, which is why you will use the Number Formatter in Pabbly Connect.

Select “Number Formatter” as your next application and choose the “Perform Math Operation” event. Map the payment amount received from Razorpay to format it correctly.

Enter the amount received from Razorpay.
Divide this amount by 100 to get the actual value.

Click on “Save and Send Request” to confirm that the formatting is successful. This ensures that the correct amount is sent to Google Sheets later on.

5. Adding Payment Details to Google Sheets

Finally, you will use Pabbly Connect to add the payment details to Google Sheets. Select Google Sheets as your final application and choose “Add New Row” as the event.

Connect your Google Sheets account to Pabbly Connect by signing in and granting necessary permissions. Select the relevant spreadsheet where you want to store the payment details.

Map the fields like full name, course name, phone number, email, amount, and payment ID.
Click on “Save and Send Test Request” to check if a new row is added successfully.

Once confirmed, your workflow is complete, and you can enable the toggle to ensure it runs automatically. This integration effectively automates the process of adding paid students to Google Sheets using Pabbly Connect.

Conclusion

This tutorial demonstrated how to automate course payments and student records using Pabbly Connect and Razorpay. By following these steps, you can streamline your workflow and save time on manual data entry.