Integrating Indiamart Leads with Google Sheets Using Pabbly Connect

Learn how to integrate Indiamart leads with Google Sheets using Pabbly Connect in this detailed tutorial. Automate your lead management process effectively! 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

Accessing Pabbly Connect for Integration

To start integrating Indiamart leads into Google Sheets, we first need to access Pabbly Connect. Open your browser and visit the Pabbly Connect landing page. Here, you’ll find options to sign in or sign up for free. If you’re new, clicking on ‘Sign up for free’ gives you 100 tasks free each month.

As an existing user, select ‘Sign in’ to access your dashboard. Once logged in, locate the Pabbly Connect application and click on ‘Access Now’. This action takes you to the workflow dashboard where you can create and manage your integrations.

Creating a Workflow in Pabbly Connect

Now that you have accessed Pabbly Connect, the next step is to create a workflow. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this integration, name it ‘Add Indiamart Leads to Google Sheets’ and select the appropriate folder to save it in.

After naming your workflow, click ‘Create’. This opens the workflow window where you can set up your trigger and action applications. Remember, we will use Indiamart as the trigger application and Google Sheets as the action application.

Setting Up Indiamart as a Trigger in Pabbly Connect

In the workflow window, select Indiamart as the trigger application. For the trigger event, choose ‘New Lead’. This event initiates the workflow whenever a new lead is captured. Pabbly Connect will provide you with a webhook URL to connect Indiamart with this workflow. using Pabbly Connect

Copy the webhook URL and log into your Indiamart account. Navigate to the Lead Manager section, then go to ‘Import/Export Leads’ using the three-dot menu. Select ‘Push API’ and set the source to ‘Other’. Enter ‘Pabbly Connect’ as the CRM platform name, and paste the webhook URL in the designated field.

• Select the reason for integration and click ‘Generate OTP’.
• Enter the OTP to finalize the connection.
• Submit and confirm the integration.

After completing these steps, Pabbly Connect will indicate that it is waiting for a webhook response, confirming that the integration is live.

Testing the Integration with Pabbly Connect

To ensure the integration works correctly, perform a test submission through your Indiamart account. Click on the ‘Test Your Webhook Listener URL’ in the Push API section. This action sends a test lead to Pabbly Connect, which should capture the response. using Pabbly Connect

Once the test is submitted, return to your Pabbly Connect workflow to verify that the response has been captured. You will see the details of the test lead, including the sender’s name, phone number, and query message.

• Check that all details are accurately captured.
• This confirms that the trigger is functioning as expected.

With the test successfully completed, you can proceed to set up the action in Google Sheets.

Adding Google Sheets as the Action in Pabbly Connect

Now, select Google Sheets as your action application in the workflow. For the action event, choose ‘Add New Row’. Click on ‘Connect’ and if you haven’t connected your Google Sheets account yet, select ‘Add New Connection’ and sign in using your Google account. using Pabbly Connect

Once signed in, grant Pabbly Connect the necessary permissions. After successful authorization, select the spreadsheet where you want to add the leads. In this case, choose the ‘New Leads and Inquiries’ spreadsheet and select the appropriate sheet within it.

Map the fields from the trigger response to the corresponding columns in Google Sheets. Ensure each detail such as name, phone number, and query message is accurately mapped.

After mapping all fields, click on ‘Save and Send Test Request’ to finalize the setup. Check your Google Sheets to confirm that the lead details have been added correctly.

Conclusion

In this tutorial, we demonstrated how to integrate Indiamart leads into Google Sheets using Pabbly Connect. This automation streamlines lead management, allowing for efficient follow-up and organization. By following the steps outlined, you can easily set up similar integrations for your business needs.