How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to automate the process of adding IndiaMART leads to Google Sheets for the chemical industry using Pabbly Connect. Step-by-step tutorial included. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add IndiaMART leads to Google Sheets, start by accessing Pabbly Connect. This platform allows you to automate workflows without coding. Visit the Pabbly Connect homepage by typing the URL in your browser.

Once there, you will see options to sign in or sign up for free. If you’re a new user, click on the ‘Sign Up for Free’ button to create your account. Existing users can simply sign in. Upon signing up, you will receive 100 free tasks every month to explore the software.

2. Creating a Workflow in Pabbly Connect

Next, you need to create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button. A dialog box will appear, prompting you to name your workflow. Enter a name such as ‘Add IndiaMART Leads to Google Sheets for Chemical Industry’.

• Select a folder for your workflow.
• Click on ‘Create’ to finalize the workflow.

After creating the workflow, you will see a blank screen where you can set up triggers and actions. The trigger will be IndiaMART, and the action will be Google Sheets. This setup allows you to automate the process of adding leads to your Google Sheets seamlessly.

3. Setting Up the Trigger with IndiaMART

To set up the trigger, select IndiaMART as your trigger application in Pabbly Connect. Then, choose the trigger event, which is ‘New Leads’. This means the workflow will start whenever a new lead is received from IndiaMART.

• Copy the webhook URL provided by Pabbly Connect.
• Navigate to your IndiaMART account and go to Lead Manager.
• Select ‘Push API’ to set up the connection.

In the Push API integration section, paste the webhook URL into the designated field. This URL acts as a bridge to transfer data from IndiaMART to Pabbly Connect. After saving the details, generate an OTP to activate the webhook.

4. Capturing Lead Data from IndiaMART

Once the webhook is activated, you need to test the connection by submitting a new lead inquiry in IndiaMART. This step is crucial as it allows Pabbly Connect to capture the lead data.

Create a dummy lead profile and submit an inquiry. Ensure all lead details, such as name and email, are filled out.

After submitting the inquiry, return to Pabbly Connect, where you will see that the response has been captured. This response includes all relevant details like the lead’s name, email, and inquiry, confirming that the connection is successful.

5. Adding Leads to Google Sheets

Now that the lead data is captured, the next step is to connect Google Sheets as the action application in Pabbly Connect. Select Google Sheets and choose the action event, which is ‘Add New Row’.

Click on ‘Connect’ and select ‘Add New Connection’. Sign in with your Google account and grant the necessary permissions. Once connected, select the specific spreadsheet where you want to save the lead details.

Map the fields from the lead data to the corresponding columns in Google Sheets. Ensure the name, email, phone number, and inquiry are correctly mapped.

After mapping, click on ‘Save and Send Test Request’. Check your Google Sheets to confirm that the new lead has been successfully added. This ensures that every time a new inquiry is received through IndiaMART, it will automatically populate in your Google Sheets.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of adding IndiaMART leads to Google Sheets. By following these steps, you can efficiently manage your leads without manual entry, saving time and improving productivity.