Integrating Indiamart Inquiries with Google Sheets Using Pabbly Connect

Learn how to automate the integration of Indiamart inquiries into Google Sheets using Pabbly Connect for efficient online store management. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Indiamart inquiries into Google Sheets, access Pabbly Connect. Sign in to your existing account or create a new one for free, which allows you 100 free tasks every month.

Once logged in, you will see the Pabbly Apps window. Click on ‘Access Now’ under Pabbly Connect to access its dashboard. This is where you will create your automation workflow.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the ‘Create Workflow’ button located in the top right corner. You will be prompted to name your workflow and select a folder to save it in.

• Name your workflow: ‘Add Online Store Management Software Business Indiamart Inquiries and Google Sheets’.
• Select the folder where you want to save this workflow.

Once you have named your workflow and selected the folder, click on ‘Create’ to proceed. You will now see two sections: Trigger and Action, which are essential for your automation process.

3. Setting Up the Trigger in Pabbly Connect

The next step in Pabbly Connect is to set up the trigger. Select ‘Indiamart’ as your trigger application. The trigger event you need to choose is ‘New Leads’. This ensures that every time a new inquiry is generated, it will be captured.

After selecting the trigger application and event, Pabbly Connect will provide you with a unique webhook URL. Copy this URL as you will need it to connect Indiamart with Pabbly Connect.

• Log into your Indiamart account.
• Navigate to the Lead Manager and select ‘Export and Import Leads’.
• Click on the ‘Push API’ button and enter ‘Pabbly Connect’ as the CRM platform name.
• Paste the webhook URL and save the details.

After saving, generate an OTP to confirm the connection. Once done, your Indiamart account will be successfully connected to Pabbly Connect.

4. Setting Up the Action in Pabbly Connect

Now that the trigger is set up, it’s time to configure the action step in Pabbly Connect. Select ‘Google Sheets’ as your action application. The action event should be set to ‘Add New Row’ to log the details of the inquiries into your spreadsheet.

Click on the ‘Connect’ button and authorize your Google account to allow Pabbly Connect to manage your Google Sheets. After authorization, select the specific spreadsheet where you want to record the leads.

Select the spreadsheet named ‘Indiamart Lead Details’. Choose the sheet where the data will be recorded, typically ‘Sheet1’. Map the fields from the previous step to the corresponding columns in Google Sheets.

After mapping the fields like Unique Query ID, Name, Email, and Message, click on ‘Save and Send Test Request’ to verify the integration.

5. Verifying the Integration with Pabbly Connect

To confirm that the integration between Indiamart and Google Sheets via Pabbly Connect is successful, generate a test lead in your Indiamart account. Fill out the inquiry form and submit it.

Once you submit the inquiry, check your Google Sheets to see if the new lead details have been recorded. You should see all relevant information such as the name, email, and message populated in the respective columns.

Ensure that all fields are accurately filled out in the inquiry form. Verify that the details appear correctly in Google Sheets.

If the details appear as expected, your automation is successfully set up! This integration allows for efficient tracking of inquiries and improves your response time.

Conclusion

In this tutorial, we explored how to integrate Indiamart inquiries into Google Sheets using Pabbly Connect. This automation streamlines your inquiry management process, ensuring you never miss a lead and can respond quickly to customer inquiries.