How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to automate adding IndiaMART leads to Google Sheets for your handloom business using Pabbly Connect. Follow our step-by-step tutorial. 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 IndiaMART Leads

To automate adding IndiaMART leads to Google Sheets for your handloom business, you first need to access Pabbly Connect. Start by navigating to the Pabbly Connect website by typing Pabbly.com/sl/connect/ in your browser. This platform allows you to create workflows that automate tasks without needing coding skills.

Once on the Pabbly Connect page, sign in using the ‘Sign In’ option in the top right corner. If you are a new user, you can click on ‘Sign Up for Free’ to create an account and receive 100 free tasks per month. After signing in, click on the Pabbly Connect icon to access your dashboard where you can manage your workflows.

2. Creating a Workflow to Integrate IndiaMART with Google Sheets

In this section, you will create a workflow that connects IndiaMART to Google Sheets using Pabbly Connect. Start by clicking on the ‘Create Workflow’ button. Name your workflow something descriptive, such as ‘Add IndiaMART Leads to Google Sheets for Handloom Business’ and select the appropriate folder to save it.

• Click on the ‘Create’ button to initiate the workflow.
• You will see two boxes: one for ‘Trigger’ and another for ‘Action’.
• Select ‘IndiaMART’ as your trigger application and choose the ‘New Leads’ event.

After selecting the trigger, Pabbly Connect will provide you with a webhook URL. This URL will be used to connect your IndiaMART account to Pabbly Connect. Copy this URL, as you will need it in the next steps to set up the connection.

3. Setting Up IndiaMART to Send Leads to Pabbly Connect

Now that you have your webhook URL from Pabbly Connect, log into your IndiaMART account. Navigate to the ‘Lead Manager’ section and click on the three dots to find the ‘Push API’ option. This is where you will input the webhook URL.

• Select your source as ‘Other’ and enter ‘Pabbly Connect’ as your CRM platform name.
• Paste the webhook URL you copied earlier into the designated field.
• Click ‘Save Details’ to complete this setup.

After saving, you will need to generate an OTP to confirm the connection. Once you receive the OTP on your registered mobile number, enter it and submit. This will finalize the connection between IndiaMART and Pabbly Connect.

4. Testing the Connection Between IndiaMART and Pabbly Connect

To ensure that the connection between IndiaMART and Pabbly Connect is successful, you need to perform a test submission. Open your IndiaMART profile in incognito mode and submit a test query to your own business.

Once you submit the query, return to Pabbly Connect and check for a response. If the setup is correct, you should see a successful response with details like query ID, name, email, and other relevant information captured from your test submission.

This step confirms that Pabbly Connect is correctly receiving leads from IndiaMART. If you see the expected data, it means the integration is functioning as intended, and you can now proceed to add these leads to Google Sheets.

5. Adding Leads to Google Sheets with Pabbly Connect

In the final step, you will set up the action to add the leads received from IndiaMART into Google Sheets. In your Pabbly Connect workflow, select ‘Google Sheets’ as your action application and choose the ‘Add New Row’ event.

Click on ‘Connect’ and sign in with your Google account. Grant permissions to allow Pabbly Connect to access your Google Sheets. Select the spreadsheet where you want to add the leads.

Map the fields from the leads received from IndiaMART to the corresponding columns in your Google Sheets. This mapping ensures that every new lead is automatically added to the correct fields in your spreadsheet. After mapping, click on ‘Save and Send Test Request’ to check if the data is being added correctly.

Conclusion

By following this tutorial, you have successfully integrated IndiaMART leads into Google Sheets using Pabbly Connect. This automation streamlines your lead management process, making it easier to handle inquiries for your handloom business. With Pabbly Connect, you can now focus on growing your business instead of managing data manually.