Integrating Instamojo with Google Sheets Using Pabbly Connect: A Step-by-Step Guide

Learn how to integrate Instamojo smart pages payment details to Google Sheets and send email notifications for failed payments using Pabbly Connect. Follow our detailed tutorial!

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Instamojo Integration

To integrate Instamojo with Google Sheets, the first step is to access Pabbly Connect. This platform allows you to automate workflows efficiently. To start, sign up for a free account on the Pabbly Connect dashboard, which can be accessed through the link in the description.

Once you are logged into your Pabbly Connect account, click on the ‘Create Workflow’ button. You will need to name your workflow, for example, ‘Instamojo to Google Sheets and Gmail’. After naming your workflow, click on the ‘Create’ button to proceed.

2. Connecting Instamojo with Pabbly Connect

In this section, we will connect your Instamojo account with Pabbly Connect. Start by selecting the ‘Trigger’ window in your workflow. Search for ‘Instamojo’ and select it. In the trigger event dropdown, choose ‘New Sale’. This setup will allow Pabbly Connect to listen for new payment notifications from Instamojo.

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

Next, navigate to your Instamojo account and go to the Smart Pages section. Here, you will edit the page where payments are processed. Scroll down to find the ‘Add Webhook’ option, enable it, and paste the copied webhook URL from Pabbly Connect. Save your changes to complete the connection.

3. Testing the Payment Integration

With the connection established, it’s time to test if the integration works properly. Go back to Pabbly Connect and ensure it is waiting for a webhook response. To generate a test payment, copy the link to your smart page and paste it into a new browser tab. using Pabbly Connect

On the payment page, select a product, enter the customer’s details, and proceed to make a payment. Once the payment is successful, return to Pabbly Connect to check if the payment details have been captured correctly.

• Select a product to purchase.
• Enter customer information (name, email, phone).
• Complete the payment process.

After completing the payment, check Pabbly Connect for the payment response. You should see details such as payment ID, status, and customer information, confirming that the integration is functioning as intended.

4. Configuring Google Sheets to Receive Payment Data

Now that we have successfully tested the payment integration, the next step is to set up Google Sheets to receive payment information. In the action window of Pabbly Connect, add a new action step and select ‘Google Sheets’ as the app. Choose ‘Add New Row’ as the action event.

Connect your Google Sheets account by clicking on ‘Sign in with Google’. Once connected, select the specific spreadsheet where you want to store the payment data. For example, if you have a spreadsheet named ‘Instamojo Payment Data’, select that.

Select the spreadsheet to add payment details. Choose the specific sheet within the spreadsheet. Map the necessary fields from the payment response to the columns in Google Sheets.

After mapping the fields such as payment ID, customer name, email, and amount, click on ‘Save and Send Test Request’. This action will add a new row in your Google Sheets with the payment details, confirming that the integration is complete.

5. Sending Email Notifications for Failed Payments

In addition to recording successful payments, you can also set up email notifications for failed payments. In the action window of Pabbly Connect, create a router to handle different payment statuses. This router will allow you to define actions based on whether the payment was successful or failed.

For the failed payment route, select ‘Gmail’ as the app and choose ‘Send Email’ as the action event. Connect your Gmail account and set up the email details, including the recipient’s email (mapped from the payment response), subject line, and email body.

Select ‘Gmail’ for sending emails. Map the recipient’s email from the payment response. Customize the email subject and body as per your requirements.

After configuring the email settings, click on ‘Save and Send Test Request’ to ensure the email notification is sent correctly. This setup will notify customers of any payment failures, enhancing user experience and customer service.

Conclusion

In conclusion, integrating Instamojo payment details with Google Sheets and setting up email notifications for failed payments can be seamlessly accomplished using Pabbly Connect. This tutorial has guided you through the entire process, ensuring that every payment detail is captured accurately and that customers are notified promptly in case of payment failures. By leveraging Pabbly Connect, you can streamline your payment processing and enhance your business operations.