How to Add IndiaMART Leads to Google Sheets Using Pabbly Connect

Learn how to integrate IndiaMART leads to Google Sheets using Pabbly Connect. Follow our step-by-step guide for seamless automation. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect Dashboard for IndiaMART Integration

To begin the integration process of adding IndiaMART leads to Google Sheets, first access the Pabbly Connect dashboard. This platform allows you to automate workflows effortlessly. If you are a new user, you can sign up quickly and receive 100 free tasks to start your automation journey.

Once logged in, navigate to the dashboard. On the right side, click on the ‘Create Workflow’ button. A dialog box will appear where you can name your workflow. For this tutorial, name it ‘Add IndiaMART Leads to Google Sheets’ and click on ‘Create’ to proceed with the setup.

Setting Up Trigger with IndiaMART in Pabbly Connect

In this section, you will set up the trigger for your workflow using Pabbly Connect and IndiaMART. The trigger application will be IndiaMART, which will initiate the workflow every time a new lead is generated. Click on the trigger application and select ‘IndiaMART’.

Next, choose the trigger event as ‘New Leads’. This event will check for new data every 24 hours. Click on the ‘Connect’ button to establish a connection with your IndiaMART account. You will need to add a new connection by providing your CRM API key, which can be generated from your IndiaMART account settings under the CRM API section.

Connecting Google Sheets as the Action Application

After successfully setting up the trigger, the next step is to connect Google Sheets as the action application in Pabbly Connect. Click on the action application and select ‘Google Sheets’. The action event will be ‘Add New Row’ to ensure that each new lead is added to your spreadsheet.

Click on the ‘Connect’ button and sign in with your Google account. Allow Pabbly Connect to access your Google Sheets. Once authorized, select the spreadsheet where you want to store the leads. For this tutorial, create a spreadsheet named ‘IndiaMART Leads’ with columns for name, email address, contact number, company name, city, query subject, product name, and query message.

Mapping Fields for IndiaMART Leads in Google Sheets

Now, you need to map the fields from the IndiaMART trigger to the columns in your Google Sheets using Pabbly Connect. This step is crucial for ensuring that the correct data is populated in your spreadsheet. Start by selecting the spreadsheet name and sheet name you created earlier.

• Map the name of the lead from the IndiaMART trigger to the corresponding column in Google Sheets.
• Continue mapping the email address, contact number, company name, city, query subject, product name, and query message.

After mapping all the fields, click on ‘Save and Send Test Request’. This action will send a test lead to your Google Sheets. Check your spreadsheet to confirm that the new lead has been added successfully, indicating that the integration has been set up correctly.

Conclusion

In conclusion, using Pabbly Connect, you can effortlessly automate the process of adding IndiaMART leads to Google Sheets. This integration allows for efficient lead management without manual input, enhancing productivity significantly.