Automate Failed Payment Details from Instamojo to Google Sheets Using Pabbly Connect

Learn how to automate the process of adding failed payment details from Instamojo to Google Sheets using Pabbly Connect with this detailed step-by-step tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating the addition of failed payment details from Instamojo to Google Sheets, access Pabbly Connect by visiting Pabbly.com/connect. You can create a free account to get started with 100 tasks monthly.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you can create a new workflow to connect your applications. This will be the foundation for integrating Instamojo and Google Sheets seamlessly.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow that connects Instamojo as the trigger and Google Sheets as the action application. Click on the ‘Create Workflow’ button in Pabbly Connect and name your workflow accordingly.

• Select Instamojo as the trigger application.
• Choose ‘Payment Failed’ as the trigger event.
• Set up the webhook URL provided by Pabbly Connect.

After setting up the trigger, you will need to connect your Instamojo account by entering the webhook URL in the settings of your Instamojo payment page. This step is crucial as it allows Pabbly Connect to receive data from Instamojo whenever a payment fails.

3. Setting Up the Webhook in Instamojo

To connect Instamojo to Pabbly Connect, you need to set up a webhook. Log in to your Instamojo account and navigate to the smart page settings where you can edit your payment page.

• Select the product page you want to edit.
• In the settings, find the Webhook option and paste the URL from Pabbly Connect.
• Ensure to select ‘Failed Payment’ as the event to trigger the webhook.

After saving the settings in Instamojo, go back to Pabbly Connect and test the webhook to ensure it is receiving data correctly. This step confirms that the connection is established successfully.

4. Connecting Google Sheets to Pabbly Connect

Now that the webhook is set up, it’s time to connect Google Sheets as the action application in Pabbly Connect. Choose Google Sheets from the action applications list and select ‘Add New Row’ as the action event.

In this step, you will need to connect your Google account to Pabbly Connect. Click on ‘Connect’ and grant the necessary permissions for Pabbly Connect to access your Google Sheets. Select the specific spreadsheet where you want the failed payment details to be added.

Choose the spreadsheet titled ‘Failed Payments’. Map the fields from the Instamojo response to the corresponding columns in Google Sheets. Make sure to test the connection by sending a test row to Google Sheets.

Once the mapping is complete, you can save and send a test request. This will allow you to verify that all details from the failed payment are correctly added to your Google Sheets.

5. Testing and Verifying the Integration

With everything set up, it’s time to test the entire workflow. Go back to your Instamojo payment page and attempt a payment with invalid details to trigger a failure.

After the payment fails, check your Google Sheets to see if the details have been added correctly. You should see the name, email, phone number, product, and price filled in automatically from the failed payment data.

Confirm that all fields are populated correctly. If the data appears as expected, your automation is successful. Repeat the test to ensure consistency in the integration.

This testing phase is crucial to ensure that your workflow between Instamojo and Google Sheets via Pabbly Connect operates smoothly and accurately captures all failed payment details.

Conclusion

By following this guide, you have successfully automated the process of adding failed payment details from Instamojo to Google Sheets using Pabbly Connect. This integration not only saves time but also ensures that you have accurate records of payment failures for better customer service.

Utilizing Pabbly Connect allows for seamless integration between various applications, enhancing your workflow efficiency and productivity.