Track Event Ticket Sales from Razorpay in Sheets

Learn how to track event ticket sales from Razorpay in Google Sheets using Pabbly Connect. Follow this detailed tutorial for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Event Ticket Tracking

To track event ticket sales from Razorpay in Google Sheets, the first step is accessing Pabbly Connect. Open a new tab and go to pabbl.com/connect. If you’re a new user, click on the ‘Sign up for free’ option in the top right corner. This allows you to explore Pabbly Connect with 100 tasks free every month.

Once signed up, you can start creating your automation. This free plan enables you to add up to 100 ticket sales automatically into Google Sheets. After experiencing the benefits, you can consider upgrading to a subscription plan using the discount coupon code provided in the description.

2. Setting Up the Trigger in Pabbly Connect

Next, you’ll set up the trigger in Pabbly Connect to capture ticket sales from Razorpay. Click on the ‘Add Trigger’ button and search for Razorpay. Select it and choose ‘Payment Captured’ as the event. Connect this trigger to receive a webhook URL.

• Search for Razorpay in Pabbly Connect.
• Select ‘Payment Captured’ as the event.
• Copy the webhook URL provided.

After copying the URL, go to your Razorpay dashboard. Navigate to the ‘Developers’ section and select ‘Webhooks’. Here, add a new webhook by pasting the URL you copied. Set the event to ‘Payment Captured’ and leave the other fields blank before clicking ‘Create Webhook’.

3. Testing the Webhook Response

Once the webhook is created, you need to test it to ensure it captures the payment details correctly. Go back to your Pabbly Connect workflow, which will display a message stating it’s waiting for a webhook response. To generate this response, purchase a ticket through Razorpay.

Fill in the necessary details and proceed to payment. Select UPI as your payment method and enter your UPI ID. After completing the payment, return to Pabbly Connect to see if the response has been captured successfully. This verifies that your webhook is functioning correctly.

4. Adding Data to Google Sheets

Now that the webhook response is captured, the next step is to add this data into Google Sheets using Pabbly Connect. Click on ‘Add New Action Step’ and search for Google Sheets. Select it and choose ‘Add New Row’ as the action event.

• Select Google Sheets from the action step options.
• Choose ‘Add New Row’ as the action event.
• Connect your Google account to Pabbly Connect.

After connecting, select the spreadsheet named ‘Ticket Sales from Razorpay’ and the specific sheet where you want the data. You will then map the fields from Razorpay to the corresponding columns in Google Sheets. This mapping makes your data dynamic and automatically updates with each new ticket sale.

5. Conclusion: Automate Your Ticket Sales Tracking

By following these steps, you can efficiently track event ticket sales from Razorpay into Google Sheets using Pabbly Connect. This automation not only saves time but also ensures that your sales data is updated in real-time without manual intervention.

Utilizing Pabbly Connect for this integration provides a seamless experience, allowing you to focus on your event while the system handles the data collection. Start implementing this automation today to enhance your business operations!