How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to automate the process of adding IndiaMART leads to Google Sheets for your plywood business using Pabbly Connect. Step-by-step tutorial included. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start adding IndiaMART leads to Google Sheets, you must first access Pabbly Connect. This powerful integration platform allows you to automate tasks seamlessly. If you’re new, you can sign up for a free account on the Pabbly website, which offers 100 free tasks every month.

Once you log into your existing Pabbly Connect account, you will see a dashboard displaying all your apps. From here, select Pabbly Connect by clicking on the access button. This will take you to the Pabbly Connect dashboard where you can create your workflow.

2. Creating a Workflow in Pabbly Connect

In this step, we will create a new workflow in Pabbly Connect to automate the process. Click on the ‘Create Workflow’ button located at the top right corner of your dashboard. A dialog box will appear asking for the workflow name and folder selection.

• Name your workflow: ‘Add IndiaMART Leads to Google Sheets for Plywood Business’.
• Select a folder to save your workflow, such as ‘IndiaMART Automations’.

After entering the details, click on the ‘Create’ button. You will see two windows: one for the trigger and another for the action. The trigger captures the event, while the action executes a response based on that event.

3. Setting Up the Trigger in Pabbly Connect

Next, we will set up the trigger in Pabbly Connect to capture new leads from IndiaMART. Select ‘IndiaMART’ as the trigger application and choose ‘New Leads’ as the trigger event. After selecting these options, Pabbly Connect will provide a unique webhook URL.

Copy this webhook URL and log into your IndiaMART account. Navigate to the ‘Lead Manager’ section, then click on ‘Import/Export Leads’ and select ‘Push API’. Here, choose ‘Other’ as the source and enter the platform name as ‘Pabbly Connect’. Paste the copied webhook URL in the designated field and click on the ‘Save Details’ button.

4. Generating a Test Lead for Verification

Now that the webhook is set up, it’s time to verify the connection. Go back to your Pabbly Connect workflow, where it says ‘Waiting for webhook response’. To generate a test lead, log into your IndiaMART user account. using Pabbly Connect

• Search for your dummy product and select it.
• Click on ‘Contact Supplier’ and fill in the lead details.
• Submit the inquiry with all required information, including a dummy GST number.

Once you submit the inquiry, check back in Pabbly Connect to see if the test lead details have been successfully captured. You should see the status as ‘Success’ along with all relevant lead information.

5. Setting Up the Action in Google Sheets

With the test lead verified, we will now set up the action to add these leads to Google Sheets using Pabbly Connect. Select ‘Google Sheets’ as the action application and choose ‘Add New Row’ as the action event. Click on the connect button and select ‘Add New Connection’.

Authorize the connection by signing in with your Google account and granting the necessary permissions. Once authorized, you will need to select the spreadsheet you created earlier, named ‘IndiaMART Leads Detail’, and choose the appropriate sheet within that spreadsheet.

Next, map the fields from the previous step to the columns in your Google Sheets. This includes mapping the unique query ID, name, email, phone number, and other relevant details. After mapping all the required fields, click on the ‘Save and Send Test Request’ button to finalize the process.

Conclusion

By following this tutorial, you can automate the process of adding IndiaMART leads to Google Sheets using Pabbly Connect. This integration saves time and enhances your ability to manage leads efficiently. With Pabbly Connect, you can ensure that every new lead generated is recorded without manual effort, streamlining your business operations.