How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to automate adding IndiaMART leads to Google Sheets using Pabbly Connect for Polymer Industries with this step-by-step tutorial. 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. Accessing Pabbly Connect for Integration

To begin adding IndiaMART leads to Google Sheets, access Pabbly Connect. This platform facilitates the automation process seamlessly. 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 receive 100 free tasks each month.

Once logged in, you will see a dashboard displaying various applications available for integration. Click on the ‘Access Now’ button under Pabbly Connect to start setting up your automation workflow. This is where you will create a connection between IndiaMART and Google Sheets.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, creating a workflow is essential for automation. 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. For this integration, name it ‘Add IndiaMART Leads to Google Sheets for Polymer Industries’.

Next, select a folder where you would like to save this workflow. Choose a relevant folder, such as ‘IndiaMART Automations’. After naming your workflow and selecting the folder, click on the ‘Create’ button to finalize the workflow setup. This step is crucial for organizing your automations effectively.

3. Setting Up the Trigger in Pabbly Connect

Now that your workflow is created, you need to set up the trigger. The trigger application in this case is IndiaMART. Select IndiaMART as the trigger application and choose the event as ‘New Leads’. This means the workflow will activate whenever a new lead is generated in your IndiaMART account.

Pabbly Connect will provide you with a unique webhook URL. Copy this URL as it will be used to connect IndiaMART with Pabbly Connect. Log into your IndiaMART account, navigate to the Lead Manager, and select the option for ‘Push API’ integration. Here, you will paste the copied webhook URL.

• Select ‘Other’ as the source for the API integration.
• Enter ‘Pabbly Connect’ as the source name.
• Paste the webhook URL in the URL field.

After saving the details, confirm that the webhook URL is added successfully. This completes the trigger setup in Pabbly Connect.

4. Generating a Test Lead for Verification

To ensure that the setup is working correctly, you need to generate a test lead in your IndiaMART account. Using the dummy product you created, click on the ‘Contact Supplier’ button and fill in the required details. For the inquiry message, write something like, ‘Hello, I am interested in purchasing polymer sheets in bulk for my manufacturing unit.’

Submit the inquiry and check back in Pabbly Connect. Your workflow should show a waiting status for the webhook response. If the test lead is captured successfully, it will display the details such as lead name, email, phone number, and inquiry message. This confirms that the connection between IndiaMART and Pabbly Connect is established.

5. Adding Leads to Google Sheets Using Pabbly Connect

After verifying that the trigger works, it’s time to set up the action step in Pabbly Connect. Select Google Sheets as the action application and choose the action event as ‘Add New Row’. This allows you to automatically create a record of the new lead in your Google Sheets.

Connect your Google Sheets account by clicking on the ‘Connect’ button. Authorize the connection by signing in with your Google account and allowing Pabbly Connect access. After authorization, select the spreadsheet where you want to save the lead details. For this tutorial, choose the spreadsheet named ‘IndiaMART Lead Details’ and select the sheet named ‘Sheet1’.

• Map the fields from the previous step to the corresponding columns in Google Sheets.
• Ensure that the headers in your Google Sheets match the data being sent from IndiaMART.
• Click on ‘Save and Send Test Request’ to finalize the setup.

Upon completion, check your Google Sheets to confirm that the lead details have been added correctly. This automation ensures that every new lead from IndiaMART is recorded in your Google Sheets effortlessly.

Conclusion

In this tutorial, we explored how to automate the process of adding IndiaMART leads to Google Sheets using Pabbly Connect. By following these steps, you can streamline your workflow and save valuable time. With Pabbly Connect, managing your leads becomes efficient and hassle-free, allowing you to focus on growing your polymer manufacturing business.