Integrating Indiamart Leads to Google Sheets Using Pabbly Connect: A Step-by-Step Guide

Learn how to integrate Indiamart leads into Google Sheets using Pabbly Connect. This detailed tutorial covers every step of the process with specific examples. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin integrating Indiamart leads into Google Sheets, you first need to access Pabbly Connect. Start by navigating to the Pabbly Connect website, which can be done by typing ‘Pabbly.com/connect’ in your browser.

Once there, sign in using your existing account. If you are new, you can click on ‘Sign Up for Free’ to create an account that provides you with 100 free tasks monthly. After signing in, you will see your dashboard where you can manage your workflows.

2. Creating a Workflow in Pabbly Connect

In this section, we will create a workflow in Pabbly Connect that connects Indiamart and Google Sheets. Click on the ‘Create Workflow’ button and name your workflow, for example, ‘Indiamart Leads to Google Sheets’.

• Select the folder where you want to save your workflow.
• Click on ‘Create’ to initiate the workflow.

After creating the workflow, you will see two boxes: one for the trigger and one for the action. The trigger will be Indiamart, and the action will be Google Sheets. This setup allows you to automate the process of adding inquiries to your Google Sheets whenever a new lead is generated in Indiamart.

3. Setting Up the Trigger with Indiamart

Now, let’s set up the trigger in Pabbly Connect. Choose Indiamart as your trigger application and select ‘New Lead’ as the trigger event. This means that every time a new lead is received in Indiamart, it will trigger the workflow to add details into Google Sheets.

Next, you will be provided with a webhook URL. This URL is essential as it connects Indiamart with Pabbly Connect. Copy this URL and head over to your Indiamart account. In the lead manager section, click on the three dots and select ‘Import/Export Leads’ then ‘Push API’.

• Select ‘Other’ as your source and enter ‘Pabbly Connect’ as your CRM platform name.
• Paste the webhook URL you copied earlier and click ‘Save Details’.
• Generate OTP to complete the connection setup.

Once the webhook is successfully added, Pabbly Connect will wait for the response whenever a new lead is generated in Indiamart.

4. Testing the Integration with a Sample Inquiry

To ensure that the integration is working correctly, you need to test it by submitting a sample inquiry through Indiamart. Open your Indiamart profile in incognito mode and search for your business. Click on ‘Contact Supplier’ and fill in the inquiry form with the necessary details.

Once you submit the inquiry, Pabbly Connect should capture the response. Check your Pabbly Connect dashboard to see if the inquiry details appear. If successful, you will see the unique query ID and all the provided details, confirming that the connection is established properly.

This test is crucial as it verifies that the data flow from Indiamart to Pabbly Connect is functioning as expected. If you see the data in your dashboard, it means the integration is set up correctly and ready for use.

5. Adding Inquiry Details to Google Sheets

Now, let’s set up the action to add the inquiry details to Google Sheets. In Pabbly Connect, select Google Sheets as your action application and choose ‘Add New Row’ as the action event. Click ‘Connect’ and select your Google account to authorize the connection.

After connecting, select the specific spreadsheet where you want to add the inquiry details. Use the mapping feature to dynamically insert the inquiry data into the appropriate fields, such as first name, last name, email, phone, and inquiry message.

Map each field from the Indiamart response to the corresponding column in your Google Sheets. Click ‘Save and Send Test Request’ to ensure the data is added correctly.

Once you receive a successful response, check your Google Sheets to verify that the inquiry details have been added correctly. This completes the integration process using Pabbly Connect, allowing you to automate your lead management efficiently.

Conclusion

In this tutorial, we explored how to integrate Indiamart leads into Google Sheets using Pabbly Connect. By following the step-by-step process, you can automate your lead management and streamline your business operations effectively.