Automating India Mart Inquiries to Google Sheets with Pabbly Connect

Learn how to automate inquiries from India Mart to Google Sheets using Pabbly Connect. Step-by-step guide for seamless integration. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate inquiries from India Mart to Google Sheets, the first step is accessing Pabbly Connect. You can do this by opening your web browser and searching for Pabbly Connect. Once on the landing page, you can choose to sign up for free if you don’t have an account, which allows you 100 tasks every month.

If you already have an account, simply sign in. After logging in, you will be directed to the dashboard where you can start creating your workflow. This is where the integration process begins, allowing you to connect India Mart with Google Sheets seamlessly.

2. Creating a Workflow in Pabbly Connect

In this section, we will create a new workflow using Pabbly Connect. Start by clicking on the ‘Create Workflow’ button on your dashboard. A pop-up will appear where you can name your workflow, such as ‘Add India Mart Inquiries to Google Sheets’. Select the appropriate folder to save this workflow.

• Click on ‘Create’ to proceed.
• You will see two boxes for Trigger and Action.
• Set up your Trigger and Action according to your needs.

After creating the workflow, you will be taken to the main workflow window. Here, you will set your trigger application, which will be India Mart, and the action application, which will be Google Sheets. This setup is crucial for automating the inquiry process effectively.

3. Setting Up Trigger with India Mart

Now, it’s time to set up the trigger in Pabbly Connect. Search for India Mart as your trigger application and select it. Choose the event ‘New Leads’ as your trigger event. This step is essential because it defines when the automation will start.

Next, you will need to connect India Mart with Pabbly Connect. Copy the VAB URL provided by Pabbly Connect, which serves as a bridge between India Mart and Pabbly Connect. Go to your India Mart account, navigate to the Lead Manager, and select the option to create a Push API integration.

• Select ‘Other’ as your source since the platform is not listed.
• Paste the copied VAB URL into the Webhook Listener URL field.
• Save the details and generate the OTP to finalize the integration.

Once you have completed these steps, your India Mart account will be successfully connected to Pabbly Connect, allowing you to receive inquiries automatically.

4. Setting Up Action with Google Sheets

After setting up the trigger, the next step is to configure the action in Pabbly Connect. Search for Google Sheets as your action application and select it. You will need to choose the action event ‘Add New Row’ to ensure that new inquiries are recorded in your Google Sheets.

Connect Google Sheets to Pabbly Connect by clicking on ‘Add New Connection’ and signing in with your Google account. Allow the necessary permissions for Pabbly Connect to access your Google Sheets. Once connected, select the specific spreadsheet where you want to add the inquiry details.

Map the fields from the inquiry data to the corresponding columns in Google Sheets. Ensure that each field is correctly matched to capture all relevant inquiry details. Save and test the action to confirm that the integration works correctly.

After mapping all the necessary fields, you will be able to automatically add new inquiries from India Mart into your Google Sheets without any manual effort.

5. Testing and Verifying the Integration

The final step is to test the integration between India Mart and Google Sheets using Pabbly Connect. To do this, create a test inquiry in your India Mart account. This will help you verify if the data is being sent correctly to Pabbly Connect.

Once the test inquiry is created, go back to Pabbly Connect and check if the webhook response has been received. If you see the test data in the response, it indicates that the integration is functioning as expected. You can then proceed to check your Google Sheets to confirm that the new row with inquiry details has been added.

Ensure that all details such as sender name, email, phone number, and inquiry message are accurately reflected. If everything is correct, your integration is successfully set up! You can now manage inquiries efficiently without manual entry.

With the successful setup of this automation, you can now keep track of all inquiries from India Mart in your Google Sheets, streamlining your workflow and improving efficiency in your pharmaceuticals and medical products business.

Conclusion

In this tutorial, we demonstrated how to automate inquiries from India Mart to Google Sheets using Pabbly Connect. By following the steps outlined, you can ensure that all new inquiries are recorded efficiently, allowing for better management and tracking of leads. Automating this process saves time and reduces the risk of manual errors, enhancing your business operations.