Automate Your Indiamart Inquiries with Pabbly Connect and Google Sheets

Learn how to automate the import of Indiamart inquiries into Google Sheets using Pabbly Connect in this step-by-step tutorial. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, open your web browser and visit the Pabbly Connect website. This platform allows you to automate workflows between different applications, making it ideal for integrating Indiamart inquiries into Google Sheets.

Once on the Pabbly Connect site, click on the ‘Sign In’ button if you’re an existing user. If you’re new, you can sign up for free. After logging in, navigate to the dashboard where you can create a new workflow for your automation.

2. Creating a New Workflow in Pabbly Connect

In this section, we will create a workflow that connects Indiamart to Google Sheets using Pabbly Connect. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow and select a folder to save it. For instance, name your workflow ‘Automatically Import Indiamart Inquiries in Google Sheets’ and save it in the ‘Automation’ folder.

• Click on ‘Create’ to proceed.
• This opens the workflow window where you can set triggers and actions.

In the workflow window, select Indiamart as your trigger application. The trigger event should be set to ‘New Leads’. This means that every time a new lead is received through Indiamart, the workflow will activate and send the lead details to Google Sheets.

3. Setting Up the Trigger for Indiamart

Now that we have set up our workflow, it’s time to configure the trigger. After selecting Indiamart as the trigger application, you will receive a webhook URL from Pabbly Connect. This URL is crucial as it connects your Indiamart account to the workflow.

Copy the webhook URL and log into your Indiamart account. Navigate to the lead manager section, click on the three dots for more options, and select ‘Import/Export Leads’ followed by ‘Push API’. Here, enter ‘Pabbly Connect’ as the CRM platform name and paste the webhook URL you copied earlier.

• Select the source as ‘Other’.
• Click on ‘Save Details’ to finalize the connection.

After saving the details, you will need to generate an OTP to complete the setup. Enter the OTP in the provided field and click on submit. Once submitted, your Indiamart account will be successfully connected to Pabbly Connect.

4. Testing the Integration with Pabbly Connect

After setting up the trigger, you need to test the integration to ensure everything is working correctly. Go back to your Indiamart account and initiate a test submission to the webhook listener URL provided by Pabbly Connect.

Once the test submission is complete, return to Pabbly Connect and check if the response from Indiamart has been captured. You should see all the details of the test lead, including the sender’s name, email, phone number, and query message.

Verify that all expected fields are populated correctly. This confirms that the trigger is functioning as intended.

With the successful capture of the test submission, you are now ready to set up the action step to send the data to Google Sheets.

5. Adding Google Sheets as an Action in Pabbly Connect

In this final section, we will set Google Sheets as the action application in your workflow using Pabbly Connect. Select Google Sheets as the action application and choose the action event as ‘Add New Row’.

Next, you will need to connect your Google account with Pabbly Connect. Click on ‘Connect’, then ‘Add New Connection’, and sign in with your Google account. Grant the necessary permissions to allow Pabbly Connect to access your Google Sheets.

Select the spreadsheet where you want to add the new leads. Map the fields from the Indiamart lead response to the corresponding columns in Google Sheets.

Finally, click on ‘Save and Send Test Request’. If successful, the details will be added to your Google Sheets, confirming that the integration is complete. You can now view the new lead details directly in your spreadsheet.

Conclusion

By following this tutorial, you have learned how to automate the import of Indiamart inquiries into Google Sheets using Pabbly Connect. This integration streamlines your workflow, saving time and reducing the risk of errors in data entry. Now, every time you receive a new inquiry, it will automatically populate your Google Sheets, allowing for efficient management of your leads.