Integrate IndiaMart Leads with Google Sheets Using Pabbly Connect

Learn how to automate the integration of IndiaMart leads into Google Sheets using Pabbly Connect. Step-by-step tutorial with detailed instructions. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Automation

To integrate IndiaMart leads into Google Sheets, we will use Pabbly Connect. First, visit the Pabbly Connect website and sign in to your account. If you are a new user, you can sign up for free and get 100 free tasks each month.

Once logged in, you will see all the applications available in Pabbly. Click on the ‘Access Now’ button next to Pabbly Connect to enter the dashboard. Here, you will create a new workflow to automate the lead transfer process.

2. Create a New Workflow in Pabbly Connect

In this step, we will set up a workflow in Pabbly Connect to automate the lead integration. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard. A dialog box will appear prompting you to name your workflow and select a folder.

• Name your workflow as ‘Add IndiaMart Leads to Google Sheets’.
• Select the folder where you want to save this workflow.

After entering the details, click on the ‘Create’ button. Your new workflow will now appear, ready for configuration with a trigger and action setup.

3. Set Up Trigger for New Leads from IndiaMart

Now, we will configure the trigger in Pabbly Connect to capture new leads from IndiaMart. For the trigger application, select ‘IndiaMart’ and the trigger event as ‘New Leads’. Pabbly Connect will provide you with a unique webhook URL to connect with your IndiaMart account.

Copy the webhook URL and log in to your IndiaMart account. Navigate to the ‘Lead Manager’ section, then select ‘Import and Export Leads’. Choose the ‘Push API’ option and paste the copied webhook URL into the provided field. Name the source as ‘Pabbly Connect’ and save the details.

4. Generate a Test Lead to Verify the Connection

After setting up the webhook, it’s time to test the connection. Go back to your IndiaMart account and create a test lead. For this, select a dummy product and fill in the required details, including your inquiry message. using Pabbly Connect

• Enter all necessary information, including name, email, and phone number.
• Submit the inquiry and check if Pabbly Connect captures the response.

Once the lead is generated, return to your Pabbly Connect workflow to see if the lead details have been captured successfully. This confirms that the trigger is working as intended.

5. Set Up Action to Add Leads to Google Sheets

The final step involves configuring the action in Pabbly Connect. For the action application, select ‘Google Sheets’ and the action event as ‘Add New Row’. Click on the ‘Connect’ button to create a connection with your Google Sheets account.

Authorize Pabbly Connect to access your Google Sheets by clicking on the ‘Allow’ button. After authorization, select the spreadsheet and sheet where you want the lead details to be added. Map the fields from the previous lead capture step to the corresponding columns in Google Sheets.

Conclusion

By following this tutorial, you have successfully integrated IndiaMart leads into Google Sheets using Pabbly Connect. This automation saves time and ensures that all leads are recorded accurately in your spreadsheet, enhancing your business efficiency.