Integrate Razorpay with ConvertKit and Google Sheets Using Pabbly Connect

Learn how to integrate Razorpay with ConvertKit and Google Sheets using Pabbly Connect in this step-by-step tutorial. No coding required! 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 Integration

To begin integrating Razorpay with ConvertKit and Google Sheets, you must first access Pabbly Connect. Go to the Pabbly website and sign in to your account. If you don’t have an account, create one for free in just a few minutes.

Once logged in, navigate to the dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. This will allow you to set up the connection between Razorpay, ConvertKit, and Google Sheets seamlessly, without any coding skills required.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow to connect Razorpay to ConvertKit and Google Sheets using Pabbly Connect. After clicking on the ‘Create Workflow’ button, name your workflow appropriately, such as ‘Razorpay to Google Sheets and ConvertKit’.

Next, you will see two windows: the Trigger window and the Action window. Select Razorpay as the app in the Trigger window and choose the event as ‘Order Paid’ to initiate the workflow when a new order is placed. This setup ensures that every successful transaction is captured.

• Select Razorpay as the app.
• Choose ‘Order Paid’ as the trigger event.
• Click on ‘Save’ to confirm your settings.

This configuration allows Pabbly Connect to listen for new orders from Razorpay, ensuring timely data transfer to your other applications.

3. Setting Up Webhooks in Razorpay

To ensure that Razorpay communicates effectively with Pabbly Connect, you need to set up webhooks in your Razorpay account. Navigate to the settings in Razorpay and locate the Webhooks section. Here, you will add a new webhook.

Copy the webhook URL provided by Pabbly Connect and paste it into the Razorpay webhook settings. Make sure to select ‘Order Paid’ as the active event. This step is crucial as it allows Razorpay to send payment data directly to Pabbly Connect, triggering the workflow you created earlier.

4. Routing Data for Different Payment Amounts

In this step, you will configure Pabbly Connect to handle different payment amounts. You will create two routes: one for payments of 150 rupees and another for 1300 rupees. This is done by adding routers in the workflow.

For each route, set a filter to check the payment amount. If the payment is 150 rupees, the corresponding action will be to send data to Google Sheets and ConvertKit. Similarly, for 1300 rupees, configure the actions accordingly. This allows you to manage multiple payment scenarios effectively.

• Create a router in Pabbly Connect.
• Set filters based on payment amounts.
• Configure actions for each route to send data to Google Sheets and ConvertKit.

This routing process is essential for ensuring that the correct data is sent to the appropriate applications based on the payment amount.

5. Sending Data to ConvertKit and Google Sheets

Now that you have set up the routes, it’s time to send the payment data to ConvertKit and Google Sheets using Pabbly Connect. For each route, you will add actions to tag subscribers in ConvertKit and add new rows in Google Sheets.

In the action settings for ConvertKit, choose to tag the subscriber and map the necessary fields such as email and first name. For Google Sheets, select the option to add a new row and map all relevant fields like name, email, payment amount, and transaction date.

Finally, test the workflow to ensure that data is flowing correctly from Razorpay to ConvertKit and Google Sheets. Once confirmed, you can start processing real transactions with confidence.

Conclusion

In this tutorial, we demonstrated how to integrate Razorpay with ConvertKit and Google Sheets using Pabbly Connect. By following the steps outlined, you can automate your payment processing effectively. This integration saves time and ensures accurate data management across platforms.