Integrate IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate IndiaMART leads into Google Sheets using Pabbly Connect for your Cultural Club Programme. Step-by-step guide included. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin integrating IndiaMART leads into Google Sheets, you need to access Pabbly Connect. Start by visiting the Pabbly Connect website and signing in to your account. If you are a new user, you can sign up for free and receive 100 tasks every month.

Once logged in, you will see various Pabbly applications. Select Pabbly Connect to create a new workflow for integrating IndiaMART with Google Sheets. This tool allows you to automate the process without any coding knowledge.

2. Creating a New Workflow in Pabbly Connect

After selecting Pabbly Connect, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. Enter a descriptive name like ‘Add IndiaMART Leads to Google Sheets for Cultural Club Programme’ and select a folder to save it.

• Click on ‘Create’ to open the workflow window.
• In the workflow window, select ‘IndiaMART’ as your trigger application.
• Choose ‘New Leads’ as the trigger event to start the automation.

By setting up the trigger in Pabbly Connect, you will ensure that every new lead from IndiaMART initiates the workflow, allowing you to capture lead details automatically.

3. Configuring IndiaMART as the Trigger Application

With the trigger event selected, Pabbly Connect will provide a webhook URL. Copy this URL as it will be used to link your IndiaMART account with the workflow. Log into your IndiaMART account and navigate to the Lead Manager section.

In the Lead Manager, go to the three dots menu, select ‘Import/Export Leads’, and then choose ‘Push API’. Here, select ‘Other’ for the source and enter ‘Pabbly Connect’ as the CRM platform name. Paste the webhook URL you copied earlier into the webhook listener URL field and save the details.

4. Testing the Integration with a Test Submission

To ensure that the integration works, perform a test submission in IndiaMART. After saving the webhook details, you will see a prompt to test the webhook listener URL. Click on the test button and submit a sample lead.

• Return to Pabbly Connect to check if the webhook response was captured.
• If successful, the lead details will appear in the workflow.

This step verifies that Pabbly Connect is receiving data from IndiaMART correctly, setting the stage for the next phase of adding lead information to Google Sheets.

5. Adding Leads to Google Sheets via Pabbly Connect

Now that the trigger is set up and tested, it’s time to configure the action application. Select ‘Google Sheets’ as the action application in Pabbly Connect. Choose ‘Add New Row’ as the action event.

Connect your Google Sheets account by clicking on ‘Connect’ and following the prompts to authorize. Select the spreadsheet where you want the leads to be recorded. Map the fields from the webhook response to the corresponding columns in your Google Sheets.

Map the lead’s name, phone number, address, and query message from the webhook response. Click on ‘Save and Send Test Request’ to finalize the integration.

Once you receive a positive response, check your Google Sheets to confirm that the lead details have been added successfully. This completes the integration process using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to integrate IndiaMART leads into Google Sheets using Pabbly Connect. By following these steps, you can automate lead management for your Cultural Club Programme, ensuring timely follow-ups and efficient tracking of inquiries.