How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to automate adding IndiaMART leads to Google Sheets for your auto spare parts business using Pabbly Connect. Step-by-step guide included. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the process of adding IndiaMART leads to Google Sheets, you need to access Pabbly Connect. Begin by typing the URL Pabbly.com/connect/ in your browser. This will take you to the Pabbly Connect homepage.

Once there, you’ll see options to Sign In or Sign Up for Free. If you’re an existing user, click on Sign In. For new users, click on Sign Up for Free to create an account, which will allow you to explore the platform with 100 free tasks each month.

2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, navigate to the dashboard where you can create a new workflow. Click on the Create Workflow button and provide a name for your workflow, such as ‘IndiaMART Leads to Google Sheets for Auto Spare Parts Business’.

• Click on the folder icon to select or create a folder for organization.
• Select the trigger application, which will be IndiaMART.
• Choose the trigger event as New Lead.

This setup ensures that every time a new lead is generated in IndiaMART, it will trigger the workflow to record the details in Google Sheets.

3. Setting Up IndiaMART Integration

To establish the connection between IndiaMART and Pabbly Connect, you will need to insert a webhook URL. After selecting the trigger event, copy the provided webhook URL from Pabbly Connect.

Next, log into your IndiaMART account and navigate to the Lead Manager. Here, select Push API and paste the webhook URL into the designated field. Activate the API by following the prompts, including generating an OTP for verification.

4. Capturing Lead Details in Pabbly Connect

Once the webhook is set up, you need to test the integration by submitting a new lead through IndiaMART. Use a dummy profile to send an inquiry. This step is crucial as it allows Pabbly Connect to capture the lead details such as name, email, phone number, and inquiry text.

After submitting the inquiry, return to Pabbly Connect to see the captured response. You should see all the details displayed, confirming that the integration is successfully capturing leads from IndiaMART.

5. Adding Leads to Google Sheets

Now that the lead details are captured, the next step is to add them to Google Sheets. In Pabbly Connect, select Google Sheets as your action application and choose the action event as Add New Row.

Connect your Google account to Pabbly Connect by clicking on Add New Connection. Ensure you have the correct permissions set. Map the fields from the IndiaMART lead response to the corresponding columns in your Google Sheets, such as name, email, phone number, and inquiry.

After mapping, click on Save and Send Test Request. Check your Google Sheets to verify that the lead information has been successfully added, confirming that the integration works seamlessly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding IndiaMART leads to Google Sheets for your auto spare parts business. By following these steps, you can efficiently manage your leads without manual data entry, enhancing your business operations.