Integrating IndiaMart Inquiries to Google Sheets Using Pabbly Connect

Learn how to automate the addition of IndiaMart inquiries to Google Sheets using Pabbly Connect. Follow this step-by-step guide for seamless integration. 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

1. Accessing Pabbly Connect for Automation

To begin the integration process, access Pabbly Connect by visiting the official website. Log in using your credentials or sign up for a free account to get started with 100 tasks monthly.

Upon logging in, navigate to the Pabbly Connect dashboard. Here, you can create new workflows that will automate tasks between IndiaMart and Google Sheets. Click on the ‘Create Workflow’ button to start building your automation.

2. Creating a Workflow in Pabbly Connect

In this section, you’ll create a workflow to automate the addition of inquiries from IndiaMart to Google Sheets. Name your workflow appropriately for easy identification. using Pabbly Connect

• Name your workflow based on its function, e.g., ‘IndiaMart to Google Sheets’.
• Select a folder for organizational purposes.
• Click on ‘Create’ to initialize your workflow.

Once the workflow is created, you will see two boxes labeled ‘Trigger’ and ‘Action’. The trigger will initiate the workflow when a new inquiry is received, and the action will perform the task of adding this inquiry to Google Sheets.

3. Setting Up Trigger and Action in Pabbly Connect

For this automation, select IndiaMart as the trigger application. Choose the event ‘New Leads’ to ensure that the workflow activates when a new inquiry is submitted.

Next, you will need to connect Pabbly Connect with IndiaMart using a webhook URL. This URL acts as a bridge to facilitate communication between both applications.

• Copy the webhook URL provided by Pabbly Connect.
• Log into your IndiaMart account and navigate to the Lead Manager.
• Paste the webhook URL in the appropriate field for the API connection.

After saving the details, generate an OTP to verify the connection. Enter the OTP received to finalize the integration setup.

4. Capturing Inquiries from IndiaMart

Now that the webhook is set up, it’s time to test the connection by sending an inquiry through IndiaMart. Navigate to your business profile and submit a test inquiry.

Once the inquiry is submitted, return to Pabbly Connect to verify if the response has been captured. You should see the inquiry details populated in the webhook response section.

Check for the unique ID and other details from the inquiry. Ensure that all relevant fields such as name, email, and inquiry are visible. Confirm that the status is marked as success.

This step is crucial as it validates that the integration is functioning correctly before proceeding to add the inquiry to Google Sheets.

5. Adding Inquiries to Google Sheets

With the inquiry successfully captured, the next step is to add this data to Google Sheets. Set Google Sheets as the action application in your Pabbly Connect workflow. using Pabbly Connect

Select the action event ‘Add New Row’ and connect your Google Sheets account to Pabbly Connect. You may need to authorize the connection by signing in with your Google account.

Choose the spreadsheet you created for IndiaMart inquiries. Map the fields from the inquiry response to the corresponding columns in your Google Sheets. Click on ‘Save and Send Test Request’ to finalize the setup.

After completing these steps, check your Google Sheets to confirm that the inquiry details have been added correctly. This automation will now run seamlessly, adding each new inquiry to your spreadsheet automatically.

Conclusion

Using Pabbly Connect, you can efficiently automate the process of adding IndiaMart inquiries to Google Sheets. This not only saves time but also enhances your workflow efficiency.