Integrating IndiaMART Leads with Google Sheets Using Pabbly Connect

Learn how to automate the addition of IndiaMART leads to Google Sheets for your Dance Academy using Pabbly Connect. Step-by-step guide included. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for IndiaMART Leads

To automate the addition of IndiaMART leads to Google Sheets, the first step is to set up Pabbly Connect. Access the platform by visiting the URL Pabbly.com/connect in your browser. Here, you will find options to sign in or sign up for free.

If you are a new user, click on the ‘Sign Up for Free’ button to create an account. Existing users can simply log in. After signing in, navigate to the dashboard where you can create a new workflow. This is where you will set up the automation for your Dance Academy.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this tutorial, name it ‘Add IndiaMART Leads to Google Sheets for Dance Academy’.

After naming your workflow, select a folder to organize it. Choose a relevant folder, such as ‘IndiaMART Leads Automation’, and click on ‘Create’. This will open a new screen with options for triggers and actions necessary for your automation process.

• Select the trigger application as IndiaMART.
• Choose the trigger event as New Leads.
• Copy the webhook URL provided by Pabbly Connect.

This setup ensures that whenever a new lead is generated on IndiaMART, your workflow is triggered automatically through Pabbly Connect.

3. Connecting IndiaMART to Pabbly Connect

To establish a connection between IndiaMART and Pabbly Connect, go to your IndiaMART account and navigate to the Lead Manager section. Here, select the option for Push API and deactivate any existing webhook.

Once deactivated, activate the new webhook by selecting a source and entering ‘Pabbly Connect’ as the CRM platform name. Paste the copied webhook URL into the designated field and save the details. Generate an OTP if prompted to complete the setup.

• Select ‘Other’ as the source of the leads.
• Confirm the activation of the new webhook.

With this connection established, Pabbly Connect will now receive data from IndiaMART whenever a new lead is created, allowing for seamless integration.

4. Adding Leads to Google Sheets via Pabbly Connect

Next, you will set up Google Sheets as the action application in your Pabbly Connect workflow. Select Google Sheets and choose the action event as ‘Add New Row’. This will ensure that every new lead received from IndiaMART is added to your Google Sheets.

To establish the connection, click on ‘Add New Connection’ and sign in to your Google account. Ensure that you allow Pabbly Connect the necessary permissions to access your Google Sheets. Once authorized, proceed to map the fields from the lead data to the corresponding columns in your Google Sheets.

Select your spreadsheet name (e.g., ‘Leads Data’). Map the fields: Name, Email, Phone Number, Company, City, and Inquiry.

This mapping allows Pabbly Connect to dynamically insert new lead details into Google Sheets, creating a systematic record of inquiries for your Dance Academy.

5. Testing the Integration and Finalizing Setup

To test your setup, create a dummy lead inquiry through IndiaMART. Once the inquiry is submitted, check your Pabbly Connect dashboard to confirm that the lead details have been captured successfully.

If the details appear correctly in Pabbly Connect, you can then check Google Sheets to see if the new row has been added with the lead information. This confirms that your automation is working correctly and that every new inquiry from IndiaMART is recorded without manual input.

By following these steps, you can effectively manage your leads and inquiries for your Dance Academy, ensuring efficient follow-ups and better customer management through the power of Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate the addition of IndiaMART leads to Google Sheets using Pabbly Connect. This integration allows you to efficiently manage inquiries for your Dance Academy, enhancing your workflow and customer engagement.