Integrating IndiaMART Leads with Google Sheets Using Pabbly Connect

Learn how to automate adding IndiaMART leads to Google Sheets using Pabbly Connect. This step-by-step guide covers all necessary actions and settings. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating the process of adding IndiaMART leads to Google Sheets, you need to access Pabbly Connect. Simply type ‘Pabbly.com/connect’ in your browser to reach the landing page.

Once there, sign in to your Pabbly account using the options provided. If you’re a new user, you can sign up for free and get 100 tasks monthly. After logging in, navigate to the Pabbly Connect dashboard to begin creating your workflow.

2. Creating a New Workflow in Pabbly Connect

In this section, we will create a new workflow to handle IndiaMART leads. Click on the ‘Create Workflow’ button in the Pabbly Connect dashboard. Here, you need to name your workflow, such as ‘Add IndiaMART Leads to Google Sheets’. using Pabbly Connect

• Choose a folder for your workflow, like ‘IndiaMART Automations’.
• Click on ‘Create’ to initialize the workflow.

After creating the workflow, you will see two boxes: one for the trigger and another for the action. The trigger is the event that starts the automation, while the action is what happens as a result.

3. Setting Up Trigger and Action in Pabbly Connect

For this automation, select IndiaMART as the trigger application. Choose the event ‘New Leads’ to capture new inquiries. This means that whenever a new lead comes in, it will trigger the workflow.

Next, you will connect IndiaMART to Pabbly Connect using a webhook URL provided in the workflow. Copy this URL and head over to your IndiaMART account to set up the webhook. In your IndiaMART dashboard, go to the Lead Manager, click on the three dots, and select ‘Import/Export Leads’ followed by ‘Push API’.

• Select ‘Other’ as the source.
• Enter ‘Pabbly Connect’ as your CRM platform name.
• Paste the webhook URL and save the details.

After saving, Pabbly Connect will show that it is waiting for a webhook response, indicating that the connection is successful.

4. Mapping Data to Google Sheets Using Pabbly Connect

Now that the trigger is set, it’s time to add the action. Select Google Sheets as the action application and choose the event ‘Add New Row’. Click on ‘Connect’ to link your Google Sheets account with Pabbly Connect.

You will be prompted to sign in to your Google account and authorize Pabbly Connect to access your Google Sheets. Once connected, select the spreadsheet where you want to store the leads. For example, choose the spreadsheet named ‘IndiaMART Inquiries’.

Map the fields from the webhook response to the corresponding columns in Google Sheets. Ensure to use the mapping feature to keep the data dynamic.

After mapping all required fields like name, phone, email, product, and query, click on ‘Save and Send Test Request’ to verify if the data is being added correctly to Google Sheets.

5. Testing and Verifying the Integration

To confirm that everything is working, send a test inquiry from your IndiaMART profile. After submitting the inquiry, return to your Pabbly Connect workflow to see if the webhook has captured the response. using Pabbly Connect

If successful, you will see the details of the inquiry in Pabbly Connect, including the unique query ID, sender name, phone number, and email address. This indicates that the integration is functioning correctly.

Next, check your Google Sheets to see if the new inquiry has been added. This will confirm that the automation is working as expected, allowing you to manage your leads efficiently.

Conclusion

In this tutorial, we demonstrated how to integrate IndiaMART leads with Google Sheets using Pabbly Connect. This automation streamlines the process of managing inquiries, ensuring that all leads are captured in real-time.