Integrate IndiaMART Inquiries with Google Sheets Using Pabbly Connect

Learn how to automate the import of IndiaMART inquiries into Google Sheets using Pabbly Connect step-by-step. Efficiently manage your B2B leads without coding! 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

1. Accessing Pabbly Connect for Integration

To integrate IndiaMART inquiries with Google Sheets, start by accessing Pabbly Connect. Open your browser and search for the Pabbly Connect landing page.

Once there, you will see options to either sign in or sign up. If you’re a new user, click on ‘Sign up for free’ to get started. As an existing user, click on ‘Sign in’ to access your dashboard. After signing in, select Pabbly Connect to begin your integration process.

2. Creating a New Workflow in Pabbly Connect

Next, you will create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button and name it something descriptive, like ‘Automatically Import IndiaMART Inquiries in Google Sheets’. Choose the appropriate folder for organization.

• Click on ‘Create’ to open the workflow window.
• Select your trigger application as IndiaMART.
• Set the trigger event to ‘New Leads’.

After selecting the trigger, Pabbly Connect will provide a webhook URL. This URL will be used to connect your IndiaMART account with the workflow, allowing for automatic lead capture.

3. Setting Up IndiaMART with Pabbly Connect

To connect IndiaMART with Pabbly Connect, log into your IndiaMART account. Navigate to the ‘Lead Manager’ section from the left sidebar. From there, click on the three dots menu, then select ‘Import/Export Leads’ followed by ‘Push API’.

• Choose ‘Other’ for the source.
• Enter ‘Pabbly Connect’ as the CRM platform name.
• Paste the webhook Listener URL you copied earlier.

Once you have saved the details, IndiaMART will prompt you to generate an OTP for verification. Enter the OTP to finalize the connection. This step ensures that Pabbly Connect is authorized to receive leads from your IndiaMART account.

4. Capturing Lead Data in Pabbly Connect

After setting up the webhook, Pabbly Connect will be in a waiting state for a webhook response. To test this, go back to your IndiaMART account and perform a test submission to trigger the webhook.

Once the test is successful, Pabbly Connect will capture the lead details sent from IndiaMART. This includes the sender’s name, email, phone number, and query message. You can verify this by checking the response captured in your workflow.

With the test response successfully captured, you are ready to set up the action application to send this data to Google Sheets, ensuring that all inquiries are logged automatically.

5. Sending Data to Google Sheets Using Pabbly Connect

Now, to send the captured lead data to Google Sheets, select Google Sheets as the action application in Pabbly Connect. Choose the action event as ‘Add New Row’ to insert the lead details into your spreadsheet.

You will need to connect your Google account with Pabbly Connect. Click on ‘Add a New Connection’, select your Google account, and allow the necessary permissions. After connecting, choose the spreadsheet where you want the leads to be stored.

Select the correct spreadsheet and sheet (e.g., Sheet1). Map the fields from the lead response to the corresponding columns in Google Sheets. Test the action to ensure data is being sent correctly.

Once the mapping is complete, Pabbly Connect will automatically add new inquiries to your Google Sheets whenever a new lead is received from IndiaMART, streamlining your data management process.

Conclusion

In this tutorial, we explored how to integrate IndiaMART inquiries into Google Sheets using Pabbly Connect. This automation simplifies lead management and ensures accurate record-keeping without manual data entry. Automate your workflow today for better efficiency!