How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to automate adding IndiaMART leads to Google Sheets using Pabbly Connect in this step-by-step tutorial. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate adding IndiaMART leads to Google Sheets, you start by accessing Pabbly Connect. Navigate to the Pabbly Connect homepage by entering the URL Pabbly.com/connect/inr in your browser.

Once on the homepage, you can either sign in if you are an existing user or click on the ‘Sign up for free’ button to create a new account. This process is quick and provides you with 100 free tasks every month to explore the features of Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, you will see the dashboard where you can manage your workflows. Click on the ‘Create Workflow’ button to start setting up the automation for IndiaMART leads.

In the dialog that appears, name your workflow something like ‘Add IndiaMART Leads to Google Sheets for Rustic Texture Paint Service’. You can also choose a specific folder for better organization. Once done, click on ‘Create’. This will open a new screen with two sections: Trigger and Action.

• Select ‘IndiaMART’ as the trigger application.
• Choose ‘New Leads’ as the trigger event.
• This setup will ensure that whenever a new lead comes in, Pabbly Connect will capture the data automatically.

After configuring the trigger, you will receive a webhook URL from Pabbly Connect. This URL will be used to connect with your IndiaMART account.

3. Connecting IndiaMART to Pabbly Connect

To connect IndiaMART with Pabbly Connect, log into your IndiaMART seller account. Navigate to the ‘Lead Manager’ section and select ‘Import/Export Leads’. Here, you will find the ‘Push API’ option.

In the Push API settings, paste the webhook URL you copied from Pabbly Connect. Make sure to select the source as ‘Other’ and fill in the platform name as Pabbly Connect. After entering these details, save the settings and activate the webhook.

• Deactivate any existing API integrations before adding the new webhook.
• Generate an OTP to verify the changes you made.
• Once activated, Pabbly Connect will be ready to receive lead data from IndiaMART.

Now that the connection is established, you can proceed to test the setup by submitting a dummy inquiry through IndiaMART.

4. Testing the Integration with Dummy Leads

To ensure that the integration is working correctly, you need to send a test lead through your IndiaMART account. Open an incognito window and submit an inquiry using a dummy profile you created earlier.

Make sure to include details such as the inquiry message for the rustic texture paint service. After submitting the inquiry, check back on Pabbly Connect to see if the lead data has been captured successfully.

Verify that the response includes all necessary details like name, email, phone number, and inquiry message. This confirms that Pabbly Connect is receiving data from IndiaMART as intended. You can now proceed to add this data to Google Sheets.

Once the test submission is successful, you will see the lead details captured in Pabbly Connect’s response section.

5. Adding IndiaMART Leads to Google Sheets

Next, you will set up the action step to add the captured lead details into Google Sheets. In Pabbly Connect, select ‘Google Sheets’ as your action application and choose ‘Add New Row’ as the action event.

Connect your Google account to Pabbly Connect if you haven’t done so already. You will then need to select the specific spreadsheet where you want to store your IndiaMART leads. Ensure that the column names match the data you will be adding.

Map the fields from the previous step to the corresponding columns in Google Sheets. This includes name, email, phone number, company name, city, and inquiry message. Click on ‘Save and Send Test Request’ to check if the data is added correctly.

After running the test, check your Google Sheets to confirm that the lead information has been added successfully. This completes the setup, allowing you to automate the process of capturing leads from IndiaMART into Google Sheets seamlessly using Pabbly Connect.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automatically add IndiaMART leads to Google Sheets. By following these steps, you can streamline your lead management process and save time on manual data entry.

Automating this process not only enhances efficiency but also ensures that you never miss a lead. Start using Pabbly Connect today to take your business automation to the next level.