How to Add Razorpay Payment Details in MySQL Using Pabbly Connect

Learn how to automate the addition of Razorpay payment details to MySQL using Pabbly Connect. Follow this detailed tutorial for seamless integration. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Razorpay and MySQL Integration

To start integrating Razorpay payment details into MySQL, you need to access Pabbly Connect. This platform allows you to automate workflows without coding. First, open a new tab and search for Pabbly Connect.

Once on the Pabbly Connect landing page, you will see options to sign in or sign up for free. If you are new, click on the ‘Sign up for free’ button. After signing up, you will have access to 100 tasks free every month. If you already have an account, simply sign in to proceed.

2. Creating a New Workflow in Pabbly Connect

After signing in, you will be directed to the Pabbly Connect dashboard. Here, click on the ‘Create Workflow’ button to start a new project. You will need to name your workflow; for this tutorial, name it ‘Add Razorpay Payment Details in MySQL’. using Pabbly Connect

• Select the folder where you want to save your workflow.
• Click on ‘Create’ to set up your workflow.

Once created, you will see two boxes labeled Trigger and Action. The trigger indicates when the automation will start, and the action is what will happen as a result. Select Razorpay as your trigger application and set the trigger event to ‘Payment Captured’.

3. Connecting Razorpay to Pabbly Connect

To connect Razorpay with Pabbly Connect, you will need a webhook URL. This URL acts as a bridge between Razorpay and Pabbly Connect. Click on the ‘Webhook URL’ to copy it.

Next, log in to your Razorpay account and navigate to the ‘Account and Settings’ section. Here, find the option for webhooks and click on ‘Add Webhook’. Paste the copied webhook URL into the designated field and set the active event to ‘Payment Captured’. After filling in these details, click on ‘Create Webhook’ to finalize the connection.

4. Testing the Integration with a Sample Payment

After setting up the webhook, return to Pabbly Connect. The system will show that it is waiting for a webhook response. To test this, create a sample payment in Razorpay. Use the payment page for your product, fill in the required customer details, and click ‘Pay’.

• Enter customer details such as first name, last name, email, and mobile number.
• Provide a test card number and other payment details.
• Submit the payment and ensure it is successful.

Once the payment is successful, go back to Pabbly Connect. You should now see the payment details captured in the response section, including customer name, email, payment ID, and amount.

5. Adding Razorpay Payment Details to MySQL

To store the captured payment details in MySQL, you need to set up the action step in Pabbly Connect. Choose MySQL as your action application and select the action event ‘Insert Row’. Connect your MySQL database to Pabbly Connect by entering your database details.

Once connected, select the table where you want to store the payment details. Map the necessary fields such as first name, last name, payment ID, phone number, amount, email, and product from the Razorpay response. After mapping all required fields, click on ‘Save and Send Test Request’. If successful, you will see a confirmation that the details have been added to your MySQL database.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the addition of Razorpay payment details into MySQL. By following these steps, you can efficiently manage your payment records without manual entry. This integration allows for seamless automation and ensures that your database is always up-to-date with the latest payment information.