How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to automate adding IndiaMART leads to Google Sheets for your advertising agency using Pabbly Connect. Step-by-step tutorial included. 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 Automation

To automate adding IndiaMART leads to Google Sheets, you first need to access Pabbly Connect. Begin by visiting the Pabbly Connect website and signing in to your account. If you are a new user, you can sign up for free and receive 100 tasks every month.

After logging in, you will see all Pabbly applications. Click on the ‘Access Now’ button for Pabbly Connect to open the dashboard. From here, you can create a workflow that connects IndiaMART and Google Sheets seamlessly.

2. Creating a Workflow in Pabbly Connect

Creating a workflow is essential to automate the process. In your Pabbly Connect dashboard, click on the ‘Create Workflow’ button located in the top right corner. A dialog box will appear for you to name your workflow.

• Name your workflow, for example, ‘Add IndiaMART Leads to Google Sheets for Advertising Agency’.
• Select a folder to save your workflow, such as ‘IndiaMART Automations’.

After entering the name and selecting the folder, click on the ‘Create’ button. This will set up the workflow where you will define the trigger and action.

3. Setting Up the Trigger with IndiaMART

The next step is to set up the trigger in Pabbly Connect. For the trigger application, select ‘IndiaMART’ and choose the event as ‘New Leads’. This setup ensures that every time a new lead is generated in IndiaMART, it triggers the workflow.

After selecting the trigger event, Pabbly Connect provides a unique webhook URL. Copy this URL and log into your IndiaMART account. Navigate to the lead manager section, select ‘Import/Export Leads’, and click on the ‘Push API’ button.

• In the Push API integration page, select ‘Other’ as the source.
• Enter ‘Pabbly Connect’ as the platform name.
• Paste the copied webhook URL and click on the ‘Save’ button.

Once saved, return to your workflow in Pabbly Connect and wait for a webhook response to confirm the connection.

4. Testing the IndiaMART Connection

To test whether the connection between IndiaMART and Pabbly Connect is successful, generate a test lead in your IndiaMART account. Log in to your IndiaMART account and create a dummy product. Click on the ‘Contact Supplier’ button and fill in the inquiry details.

Once you submit the inquiry, check back in Pabbly Connect to see if the test lead response has been captured. If successful, you will see details such as the query ID, name, email, and other lead information displayed in your workflow.

Ensure the response includes all necessary details like name, email, and inquiry message. Confirm that the trigger status indicates success.

This verification step is crucial to ensure that Pabbly Connect is capturing leads correctly from IndiaMART.

5. Adding Leads to Google Sheets

After confirming the test lead is captured, the next step is to set up the action in Pabbly Connect. Select ‘Google Sheets’ as the action application and choose ‘Add New Row’ as the action event. Click on the ‘Connect’ button to authorize the connection.

Log in to your Google account and grant the necessary permissions. After authorization, select the spreadsheet you created for IndiaMART leads and the specific sheet where you want to store the lead details.

Map the fields from the previous step to the corresponding columns in Google Sheets. Fields include unique query ID, name, email, phone number, company, address, city, state, country, product name, and message.

Once all fields are mapped correctly, click on the ‘Save and Test Request’ button. If successful, the lead details will appear in your Google Sheets, confirming that the integration is working perfectly.

Conclusion

In this tutorial, we demonstrated how to automate the process of adding IndiaMART leads to Google Sheets using Pabbly Connect. This integration allows advertising agencies to manage leads efficiently, ensuring timely follow-ups and organized records.

By utilizing Pabbly Connect, you can streamline your workflow and focus on growing your business without the hassle of manual data entry.