Integrating India Mart Leads to Google Sheets Using Pabbly Connect

Learn how to integrate India Mart leads into Google Sheets automatically using Pabbly Connect. This step-by-step tutorial covers everything you need to know. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To integrate India Mart leads into Google Sheets, we will use Pabbly Connect. First, visit the Pabbly Connect homepage by typing the URL in your browser. Here, you will find options to sign in or sign up for free. If you are a new user, click on the ‘Sign Up for Free’ button to create your account, which includes 100 free tasks monthly.

Once logged in, navigate to the ‘All Apps’ section. Here, you will find various Pabbly products. Click on ‘Access Now’ for Pabbly Connect to reach the dashboard. This platform allows you to automate tasks between applications without coding knowledge, making it ideal for this integration.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, you need to create a new workflow. Click on the ‘Create Workflow’ button located in the top right corner. A dialog box will appear, prompting you to name your workflow. Enter a suitable name, such as ‘Add India Mart Leads to Google Sheets Automatically,’ and select a folder to save it in. using Pabbly Connect

• Click on the ‘Create’ button to save your workflow.
• You will see two main windows: Trigger and Action.
• Select India Mart as the trigger application and Google Sheets as the action application.

This setup is essential for defining how the workflow will operate. The trigger will initiate the process when a new lead is generated on India Mart, and the action will record that lead in Google Sheets.

3. Setting Up the Trigger in Pabbly Connect

Next, we will set up the trigger for our workflow. Select ‘India Mart’ as the trigger application and choose the ‘New Leads’ event. This event will activate the workflow whenever a new lead is created on India Mart. After selecting the trigger event, Pabbly Connect will provide a webhook URL.

Copy this webhook URL, as it will be used to connect India Mart with Pabbly Connect. Now, log into your India Mart account, navigate to the lead manager section, and select the option to import or export leads. Choose the push API option and paste the webhook URL into the designated field.

4. Verifying the Integration with a Test Lead

After setting up the webhook URL in India Mart, you need to verify the integration. Create a new lead in India Mart by filling out the required details, including name, email, and inquiry. Once you submit this lead, Pabbly Connect will capture the response. You can check the response status in your Pabbly Connect dashboard.

If the integration is successful, you will see the details of the new lead captured in Pabbly Connect. This confirms that the connection between India Mart and Pabbly Connect is working correctly. You can now proceed to set up the action that will record this lead in Google Sheets.

5. Adding Leads to Google Sheets Using Pabbly Connect

The final step is to set up the action in your workflow to add the lead details to Google Sheets. Select ‘Google Sheets’ as the action application and choose ‘Add New Row’ as the action event. Connect your Google account to Pabbly Connect by clicking on ‘Sign In with Google’ and granting the necessary permissions.

• Select the specific spreadsheet where you want to store the leads.
• Map the fields from the lead response to the corresponding columns in your Google Sheets.
• Click on ‘Save and Send Test Request’ to ensure everything is functioning properly.

Once the test is successful, your workflow is complete. Now, every time a new lead is generated in India Mart, its details will be automatically added to your Google Sheets through Pabbly Connect, streamlining your lead management process.

Conclusion

This tutorial outlined how to integrate India Mart leads into Google Sheets using Pabbly Connect. By following these steps, you can automate the process of recording new leads, saving time and reducing manual data entry. This integration enhances your operational efficiency and ensures that all leads are captured seamlessly.