How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to seamlessly add IndiaMART leads to Google Sheets for biofertilizers using Pabbly Connect. Follow our step-by-step tutorial for efficient lead management. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start adding IndiaMART leads to Google Sheets, you need to access Pabbly Connect. Open your browser and navigate to the Pabbly Connect website.

If you are a new user, click on ‘Sign Up for Free’ to create an account. Existing users should select ‘Sign In’ to access their dashboard. Once logged in, navigate to the Pabbly Connect dashboard to begin creating your automation workflow.

2. Creating a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the ‘Create Workflow’ button. You will be prompted to name your workflow and select a folder for organization. using Pabbly Connect

For this integration, name your workflow ‘Add IndiaMART Leads to Google Sheets for Biofertilizers’. After naming, click on ‘Create’ to proceed. This action opens the workflow window where you can set triggers and actions.

3. Setting Up Trigger for IndiaMART Leads

To capture leads from IndiaMART, you need to set up a trigger in Pabbly Connect. Select IndiaMART as the trigger application and choose the event as ‘New Leads’. This event will initiate the workflow when a new lead is generated.

Next, you will be provided with a webhook URL. Copy this URL and log into your IndiaMART account. Navigate to the leads section, select ‘Import/Export Leads’ from the menu, and then click on ‘Push API’. Here, set the source to ‘Other’ and enter ‘Pabbly Connect’ as the CRM platform name. Paste the webhook URL you copied earlier and save the details.

• Select ‘Other’ for the source.
• Enter ‘Pabbly Connect’ as the CRM platform name.
• Paste the webhook URL from Pabbly Connect.

After saving, you will be prompted to generate an OTP. Click the button to generate the OTP, enter it, and submit. This completes the trigger setup in IndiaMART.

4. Testing the Trigger Response

After setting up the trigger, Pabbly Connect will indicate that it is waiting for a webhook response. To test this, go back to your IndiaMART account and click on the ‘Test Your Webhook’ button. This will send a test lead to your Pabbly Connect workflow.

Once the test submission is complete, check Pabbly Connect to see if the response has been captured. You will see details such as the status, unique query ID, and lead information. Ensure that the details align with the expected format.

• Check for the unique query ID in the response.
• Verify that all lead details are correctly captured.

This confirms that your trigger is successfully set up to capture new leads from IndiaMART.

5. Adding Leads to Google Sheets

With the trigger successfully configured, it’s time to set up the action to add leads to Google Sheets using Pabbly Connect. Select Google Sheets as the action application and choose ‘Add New Row’ as the action event.

You will need to connect your Google Sheets account to Pabbly Connect. Click on ‘Add New Connection’ and sign in with your Google account, granting the necessary permissions. Once connected, select the spreadsheet where you want to add the leads, such as ‘New Leads and Inquiries’.

Choose the correct spreadsheet from your Google Sheets. Select the appropriate sheet (e.g., Sheet1) for data entry.

Map the lead details from the trigger response to the corresponding columns in Google Sheets. This ensures that every new lead is added correctly without manual entry. After mapping, click on ‘Send Test Request’ to confirm that the integration is working. You should see the lead details appear in your Google Sheets almost instantly.

Conclusion

By using Pabbly Connect, you can efficiently add IndiaMART leads to Google Sheets for biofertilizers, streamlining your lead management process. This integration allows for real-time updates and ensures that your sales team can follow up quickly. Automate your lead capturing today and enhance your business operations.