How to Add Razorpay Payment Details in MySQL Using Pabbly Connect

Learn how to automate adding Razorpay payment details to MySQL using Pabbly Connect with this step-by-step tutorial. Perfect for seamless integration! 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

Setting Up Pabbly Connect for Razorpay to MySQL Integration

To begin the integration process, you need to access Pabbly Connect. This platform allows you to automate tasks between Razorpay and MySQL seamlessly. First, open a new tab and search for the Pabbly Connect website. If you don’t have an account, click on ‘Sign up for free’ to create one. This process takes just a couple of minutes, and you’ll receive 100 free tasks every month.

Once logged in, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button. You will then name your workflow, such as ‘Add Razorpay Payment Details in MySQL.’ Choose a suitable folder for saving your workflow, then click ‘Create’ to proceed.

Configuring the Trigger with Razorpay

The next step is to configure the trigger in Pabbly Connect. For this, select Razorpay as your trigger application. This step is crucial as it sets the stage for when the workflow will initiate. You will need to choose a trigger event; in this case, select ‘Payment Captured’ from the dropdown menu.

After selecting the trigger event, you will connect Razorpay with Pabbly Connect using a webhook URL. This URL acts as a bridge between Razorpay and Pabbly Connect. Copy the webhook URL provided and navigate back to your Razorpay account. Under ‘Account and Settings’, find the ‘Webhooks’ section and click on ‘Add Webhook’. Paste the copied URL and select ‘Payment Captured’ as the active event before clicking ‘Create Webhook’.

Testing the Trigger in Pabbly Connect

Now that your trigger is set up, it’s time to test it. Go back to Pabbly Connect where you will see that it is waiting for a webhook response. To generate this response, create a sample payment in Razorpay. Use the payment page link to fill out the required customer details, such as first name, last name, email, and payment amount.

• First Name: Test
• Last Name: User
• Email: [email protected]
• Payment Amount: 999

After filling in the details, proceed to make the payment. Once the payment is successful, return to Pabbly Connect, and you should see the response from Razorpay, including all the payment details captured.

Setting Up Action to Insert Data into MySQL

With the trigger successfully configured, the next step in Pabbly Connect is to set up the action that will insert the payment details into your MySQL database. Select MySQL as the action application and choose the action event as ‘Insert Row’. This step is essential as it defines what happens when a payment is captured.

Connect MySQL to Pabbly Connect by clicking on ‘Add New Connection’. You will need to enter the necessary database connection details. Once connected, select the table where you want to insert the payment details. Map the fields from the Razorpay response to the corresponding columns in your MySQL table.

• First Name
• Last Name
• Payment ID
• Email
• Amount

Finally, click on ‘Save and Send Test Request’ to verify that the data is being inserted correctly into your MySQL database.

Verifying the Integration Success

To ensure that the integration works flawlessly, go back to your MySQL database and check if the new payment details have been added successfully. You should see a new row corresponding to the payment you created, with all the relevant details populated correctly.

For further testing, create another payment in Razorpay using the same steps as before. Once the payment is made, return to your MySQL database to confirm that the new payment details appear as expected. This automated process ensures that every payment captured by Razorpay is logged in your database without manual intervention, thanks to Pabbly Connect.

Conclusion

This tutorial demonstrated how to automate the addition of Razorpay payment details to MySQL using Pabbly Connect. By following the steps outlined, you can efficiently manage payment data without the need for manual entry, enhancing your workflow and ensuring data accuracy.