How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to integrate IndiaMART leads with Google Sheets for Electric Vehicle Service using Pabbly Connect. Step-by-step tutorial for seamless automation. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To start integrating IndiaMART leads with Google Sheets, you first need to access Pabbly Connect. Open your browser and search for Pabbly Connect, then navigate to the landing page. Here, you will see options to sign in or sign up for free. If you are a new user, you can sign up and get 100 tasks free every month.

As an existing user, click on the sign-in option. Once logged in, you will see all Pabbly applications. Select Pabbly Connect to begin creating your workflow. Click on ‘Create Workflow’, give it a name, and save it in your desired folder. This sets the stage for your automation process.

Creating the Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this integration, name it something like ‘Add IndiaMART Leads to Google Sheets for Electric Vehicle Service’. This helps in organizing your workflows efficiently.

Once your workflow is created, you will reach the workflow window. Here, you will set a trigger event. The trigger application will be IndiaMART, and the event will be when a new lead is captured. This integration ensures that every new lead received will automatically update your Google Sheets.

• Select IndiaMART as the trigger application.
• Choose ‘New Lead’ as the trigger event.
• Copy the provided webhook URL for the next steps.

With these steps, you have set the foundation for your automation process using Pabbly Connect.

Connecting IndiaMART to Pabbly Connect

To connect IndiaMART to Pabbly Connect, log into your IndiaMART account. Navigate to the Lead Manager section on the left sidebar. Click on the three dots for the menu, then select Import/Export Leads and choose Push API. This is where you will configure the connection.

In the Push API settings, select ‘Other’ as the source and enter ‘Pabbly Connect’ in the CRM platform name. Paste the webhook URL you copied earlier into the Webhook Listener URL field. This establishes the connection between IndiaMART and Pabbly Connect.

• Choose ‘Other’ as the source.
• Enter ‘Pabbly Connect’ in the CRM platform name.
• Click ‘Save Details’ to finalize the connection.

After saving, you will be prompted to generate an OTP. Once you receive the OTP, enter it to complete the integration. This step ensures that your IndiaMART leads are now connected to Pabbly Connect.

Adding Leads to Google Sheets

Now that you’ve connected IndiaMART to Pabbly Connect, the next step is to add leads to Google Sheets. For the action application, select Google Sheets and choose the ‘Add New Row’ action event. This allows you to add new leads automatically as they come in.

Click on ‘Connect’ and choose to add a new connection. You will need to sign in with your Google account and grant the necessary permissions. Once connected, select the spreadsheet you want to use for this integration, typically named ‘New Leads and Inquiries’.

Choose the spreadsheet where leads will be stored. Select the specific sheet (e.g., Sheet1) for data entry. Map the fields from the lead data to the corresponding columns in Google Sheets.

After mapping the fields, save and send a test request. This will check if the integration works correctly. If successful, you will see the new lead information populated in your Google Sheets, demonstrating the power of Pabbly Connect in automating this process.

Conclusion

In this tutorial, we explored how to integrate IndiaMART leads with Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the process of adding new leads to your Google Sheets, ensuring efficient management of inquiries for your Electric Vehicle Service business. This integration not only saves time but also enhances productivity.