Integrating Instamojo Purchase Details into MySQL with Pabbly Connect

Learn how to seamlessly integrate Instamojo purchase details into MySQL using Pabbly Connect for efficient data management and backup. 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 Integration

To start integrating Instamojo purchase details into MySQL, you need to access Pabbly Connect. First, open a new tab and navigate to the Pabbly Connect website. If you don’t have an account, sign up for free, which takes just a couple of minutes.

Once logged in, you will be directed to the Pabbly Connect dashboard. Here, you can create workflows that facilitate automation between different applications. Click on the ‘Access Now’ button under Pabbly Connect to enter the workflow section, where you can manage your integrations.

2. Creating a New Workflow in Pabbly Connect

In this step, you will create a new workflow in Pabbly Connect to capture Instamojo purchase details. Click on the ‘Create Workflow’ button and name your workflow appropriately, such as ‘Add Instamojo Purchase Details in MySQL.’ Select the folder where you want to save this workflow and click on ‘Create’ to proceed.

• Name your workflow clearly for easy identification.
• Choose the folder to organize your workflows effectively.

Now, you will see two main sections: Trigger and Action. The Trigger is the event that starts the workflow, while the Action is what happens as a result. Set the Trigger application to Instamojo and choose the event ‘New Sale’ to begin capturing purchase details.

3. Connecting Instamojo to Pabbly Connect

To connect Instamojo to Pabbly Connect, you will need a webhook URL. This URL acts as a bridge between Instamojo and Pabbly Connect. Copy the webhook URL provided in the Pabbly Connect setup and navigate to your Instamojo account.

In your Instamojo dashboard, go to the Smart Pages section and select the page where you want to add the webhook. Scroll down to find the ‘Add Webhook’ option. Toggle the button to enable it and paste the copied webhook URL. Save your changes to establish the connection between Instamojo and Pabbly Connect.

4. Setting Up MySQL Action in Pabbly Connect

After successfully connecting Instamojo with Pabbly Connect, the next step is to set up the Action to insert data into MySQL. In the Action section, select MySQL as the application and choose the ‘Insert Row’ action event. This will allow you to add new purchase details into your MySQL database.

To connect MySQL with Pabbly Connect, click on ‘Connect’ and provide your database credentials, including username, password, host, database name, and port. Once connected, select the specific table in your MySQL database where you want to store the purchase details.

• Ensure you have the correct database credentials for a successful connection.
• Choose the correct table to store the data accurately.

Now you will map the fields from Instamojo to your MySQL table. This mapping will allow you to automatically insert the relevant data, such as customer name, email, phone number, and purchase amount, into the correct columns.

5. Testing the Integration

With everything set up, it’s time to test the integration between Instamojo and MySQL via Pabbly Connect. To do this, create a sample purchase on your Instamojo Smart Page. Fill in the required customer details and complete the payment process.

Once the purchase is made, return to Pabbly Connect. You should see a successful response indicating that the purchase details have been captured. Check your MySQL database to confirm that a new row has been added with the customer’s information and purchase details.

Verify that all mapped fields are accurately populated in MySQL. Ensure the integration works seamlessly for future purchases as well.

This successful integration ensures that every new purchase from Instamojo is automatically backed up in your MySQL database, streamlining your data management process.

Conclusion

In this tutorial, we’ve demonstrated how to use Pabbly Connect to integrate Instamojo purchase details into MySQL. By following these steps, you can automate the process of capturing sales data, ensuring efficient data management and backup.