Integrate Instamojo Payments with Google Sheets Using Pabbly Connect

Learn how to integrate Instamojo payment failures into Google Sheets using Pabbly Connect. This step-by-step tutorial covers everything you need to know. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Instamojo payment failures with Google Sheets, first access Pabbly Connect. If you’re a new user, sign up for free to get started, which includes 100 free tasks.

Once logged in, navigate to the Pabbly Connect dashboard by clicking on ‘Access Now’. From here, you can create a new workflow by clicking the ‘Create Workflow’ button. Name your workflow as ‘Add Failed Instamojo Payment Details in Google Sheets’ and click ‘Create’.

2. Setting Up the Trigger for Instamojo Payments

In this section, you will set up the trigger application in Pabbly Connect. Select Instamojo as your trigger application and choose the trigger event as ‘New Sale’. This event will capture both successful and failed payments.

• Select Instamojo as the trigger application.
• Choose ‘New Sale’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Next, you will use this webhook URL to connect your Instamojo account. Go to your Instamojo account, create a new payment link, and paste the webhook URL into the smart actions section under ‘Add Webhook’. This enables Pabbly Connect to capture payment details from Instamojo.

3. Testing Failed Payment Transactions

Now that the trigger is set up, it’s time to test a failed payment transaction. Fill in the payment details on your Instamojo payment page with dummy information, ensuring that the transaction fails due to insufficient funds.

• Enter dummy user details (e.g., name, email, phone number).
• Attempt a payment that will fail.
• Check Pabbly Connect for captured responses.

Once the payment fails, return to Pabbly Connect to view the captured response. You should see the status as ‘Failed’, along with details like payment ID and amount. This confirms that Pabbly Connect is successfully capturing failed payment details.

4. Filtering Only Failed Payments with Pabbly Connect

To ensure that only failed payments trigger the next action, set up a filter in Pabbly Connect. Use the ‘Filter by Pabbly’ action and set the condition to check if the payment status is ‘Failed’. This step is crucial to ensure that only relevant data is processed.

Select ‘Filter by Pabbly’ as the action. Set the condition to check if status equals ‘Failed’. Save and test the filter to ensure it works correctly.

Once you save the filter, you will receive a success message indicating that the condition is true. This means your workflow is now configured to only proceed for failed transactions.

5. Adding Failed Payment Details to Google Sheets

In the final step, you will set up the action to add the captured details into Google Sheets using Pabbly Connect. Select Google Sheets as your action application and choose ‘Add New Row’ as the action event.

Connect your Google Sheets account to Pabbly Connect. Select the spreadsheet where you want to add the details. Map the fields for name, email, phone number, and payment ID.

After mapping the fields, click ‘Save and Send Test Request’ to confirm that the details are added correctly to your Google Sheets. You should see the newly added row with the payment details, confirming that your integration is successful. Now, whenever a payment fails in Instamojo, the details will automatically be logged in Google Sheets through Pabbly Connect.

Conclusion

In this tutorial, we successfully integrated Instamojo payment failures into Google Sheets using Pabbly Connect. By following these steps, you can automate the logging of failed payment details efficiently.