Integrate IndiaMART Leads to Google Sheets Using Pabbly Connect for Marble and Granite Business

Learn how to automate the addition of IndiaMART leads to Google Sheets for your marble and granite business using Pabbly Connect. Step-by-step tutorial included. 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 begin automating the addition of IndiaMART leads to Google Sheets, you need to access Pabbly Connect. Start by typing the URL Pabbly.com/connect into your browser.

Once on the homepage, you will see options to sign in or sign up for free. If you are a new user, click on the ‘Sign up for free’ button, which allows you to create an account and receive 100 free tasks each month. Existing users can simply sign in to their accounts.

2. Creating a Workflow in Pabbly Connect

After signing into Pabbly Connect, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button to start.

In the dialog box that appears, name your workflow, such as ‘Add IndiaMART Leads to Google Sheets for Marble and Granite Business.’ Select the appropriate folder for your workflow and click on ‘Create’. This sets up a blank workflow where you can define your trigger and action.

• Name your workflow clearly for easy identification.
• Choose a folder to organize your workflows efficiently.

Now that your workflow is created, you will see two windows: one for the trigger and one for the action. The trigger defines what starts the automation, while the action specifies what happens as a result.

3. Setting Up the Trigger with IndiaMART

To set up your trigger, select IndiaMART as the trigger application in Pabbly Connect. Choose the trigger event as ‘New Lead’. This means that whenever a new lead is received, the workflow will activate.

Once you select the trigger event, a webhook URL will be generated. This URL acts as a bridge to transfer data from IndiaMART to Pabbly Connect. Copy this URL, as you will need it to configure your IndiaMART account.

• Select ‘New Lead’ as the trigger event.
• Copy the generated webhook URL for the next steps.

Next, log into your IndiaMART account and go to the Lead Manager section. Navigate to the ‘Push API’ integration option, where you will paste the webhook URL to establish the connection.

4. Configuring Google Sheets as the Action

With the trigger set, it’s time to configure Google Sheets as the action application in Pabbly Connect. Select Google Sheets and choose the action event as ‘Add New Row’. This action will create a new row in your Google Sheets for each new lead.

Click on ‘Connect’ to establish the connection between Pabbly Connect and Google Sheets. You can either add a new connection or select an existing one. If creating a new connection, sign in with your Google account and allow the necessary permissions.

Select ‘Add New Row’ as the action event. Authorize Pabbly Connect to access your Google Sheets.

Once connected, specify the spreadsheet where you want to store the lead details. Ensure you select the correct spreadsheet name and corresponding sheet within it for accurate data entry.

5. Testing and Saving the Automation

After setting up the action, it’s crucial to test the automation to ensure everything is functioning correctly. Click on the ‘Save and Send Test Request’ button in Pabbly Connect. This will create a test entry in your Google Sheets based on the lead data received from IndiaMART.

Check your Google Sheets to confirm that the lead details have been successfully added. You should see the name, email, phone number, and inquiry in the designated columns. This confirms that your automation is working as intended.

Verify that all lead details are correctly displayed in Google Sheets. Make any necessary adjustments to the workflow if needed.

Once verified, your automation is complete. Now, every time a new lead comes through IndiaMART, it will automatically populate in your Google Sheets, streamlining your lead management process.

Conclusion

In this tutorial, we explored how to integrate IndiaMART leads into Google Sheets for your marble and granite business using Pabbly Connect. By automating this process, you can efficiently manage leads without manual data entry, saving time and reducing errors.