Integrate Instamojo with Google Sheets Using Pabbly Connect

Learn how to integrate Instamojo with Google Sheets using Pabbly Connect to automate your sales tracking. Step-by-step guide with detailed instructions. 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. Introduction to Pabbly Connect for Instamojo and Google Sheets

In this section, we will introduce Pabbly Connect, the integration platform that connects Instamojo with Google Sheets. This integration allows you to automatically add new sales from Instamojo into Google Sheets without any coding knowledge.

By using Pabbly Connect, you can streamline your sales tracking process. The integration works by capturing new sales data from Instamojo and transferring it to Google Sheets, ensuring that all your sales records are up-to-date.

2. Setting Up Pabbly Connect for Instamojo Integration

To start the integration, access Pabbly Connect by visiting its website. Sign in to your account or create a new one if you don’t have it yet. Once logged in, navigate to the ‘Connect’ section.

• Go to the URL and type Pabbly.com.
• Hover over the product section and click on ‘Connect’.
• Click on ‘Access Now’ to create a new workflow.

After creating a workflow, name it ‘Instamojo Integration’. Then, select ‘Instamojo’ as the application for your trigger event, specifically choosing ‘New Sale’ as the trigger. This setup is crucial for capturing sales data whenever a new transaction occurs.

3. Configuring the Webhook in Instamojo

Once you have set up the trigger in Pabbly Connect, a webhook URL will be generated. This URL is essential for linking Instamojo with Pabbly Connect. Copy this URL to your clipboard.

Next, log into your Instamojo account and navigate to the product section. Here, you will paste the webhook URL into the designated field under the product settings. Make sure to save the changes to ensure the webhook is active.

• Go to your product settings in Instamojo.
• Locate the ‘Webhook URL’ field and paste the copied URL.
• Save the product settings to enable the webhook.

After saving, return to Pabbly Connect and click on ‘Capture Webhook Response’. This action prepares Pabbly Connect to receive data from Instamojo as soon as a sale is made.

4. Making a Test Sale in Instamojo

With the webhook set, it’s time to test the integration. Go back to your Instamojo account and make a test purchase. Fill in the necessary details like name, email, and address. After completing the payment, Pabbly Connect will capture the sale data automatically.

Check Pabbly Connect to see if the data has been captured successfully. You should see details such as buyer name, email, and payment ID. This confirms that the integration is working correctly.

5. Integrating Google Sheets with Pabbly Connect

Now, let’s integrate Google Sheets with Pabbly Connect. In your workflow, add a new action and select Google Sheets as the application. Choose ‘Add New Row’ as the action event. This step ensures that every new sale recorded in Instamojo is added to your Google Sheets.

Connect your Google Sheets account and select the spreadsheet you created earlier for this integration. Map the fields from the captured data to the columns in your Google Sheets, such as name, email, and amount.

Select the appropriate Google Sheets account. Choose the spreadsheet you created for Instamojo sales. Map the data fields to the correct columns in Google Sheets.

Finally, test the integration by saving the setup in Pabbly Connect. Check your Google Sheets to confirm that the new sale data appears correctly. This completes the integration process!

Conclusion

Integrating Instamojo with Google Sheets using Pabbly Connect automates your sales tracking efficiently. By following these steps, you can ensure that every sale is recorded seamlessly in your spreadsheet, enhancing your business management.