Integrate IndiaMART Leads into Google Sheets with Auto Timestamp Using Pabbly Connect

Learn how to automate adding IndiaMART leads into Google Sheets with auto timestamp using Pabbly Connect. Step-by-step tutorial for seamless integration. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating the process of adding IndiaMART leads into Google Sheets, you first need to access Pabbly Connect. This platform allows you to integrate various applications seamlessly.

Navigate to the Pabbly Connect website and log in or sign up for a new account. Once logged in, you will see the dashboard that provides access to all Pabbly applications, including the automation tools necessary for this integration.

2. Creating Your Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button on the top right corner of the dashboard. You will have the option to choose between the new beta method or the classic method; select the classic method for this tutorial.

• Name your workflow as ‘Add India Leads into Google Sheets with Auto Timestamp’.
• Choose a folder to save your workflow.
• Click on the ‘Create’ button to finalize your workflow setup.

Once created, you will see two windows: one for the trigger and another for the action. Understanding these components is crucial as they define how your automation will function.

3. Setting Up the Trigger for IndiaMART Leads

The next step involves setting up the trigger in Pabbly Connect. For the trigger application, select IndiaMART and the trigger event as ‘New Leads’. This will allow Pabbly Connect to capture data whenever a new lead is generated in your IndiaMART account.

After selecting the trigger, you will receive a unique webhook URL from Pabbly Connect. Copy this URL and log into your IndiaMART account. Navigate to the Lead Manager section, and under Import/Export Leads, select the option for Push API.

• Paste the webhook URL into the designated field.
• Name your source as ‘Pabbly Connect’.
• Click on the ‘Save’ button to activate the API.

With the webhook successfully added, return to your Pabbly Connect workflow. You should see a message indicating that it is waiting for a response from IndiaMART.

4. Testing the Connection Between IndiaMART and Pabbly Connect

To ensure that the connection between IndiaMART and Pabbly Connect is working, you will need to send a test lead. Click on the test button in Pabbly Connect to generate a test response. This step is crucial to verify that the trigger is capturing the data correctly.

Once the test data is sent, return to your Pabbly Connect workflow and check if the test response has been captured. You should see the details of the test lead, including the unique query ID, name, email, and other relevant information.

If the test response is successful, it confirms that your Pabbly Connect trigger is set up correctly and ready to capture real leads in the future.

5. Adding Leads to Google Sheets with Auto Timestamp

Now that the trigger is set up and tested, the final step is to add the captured lead data into Google Sheets. For this, select Google Sheets as your action application within Pabbly Connect and choose the action event as ‘Add New Row’.

Connect your Google Sheets account by signing in and granting the necessary permissions. Once connected, select the spreadsheet where you want the leads to be added, and choose the specific sheet within that spreadsheet.

Map the fields from the previous step to the corresponding columns in Google Sheets. Ensure to include the timestamp of when the lead was generated. Click on the ‘Save and Send Test Request’ button to finalize the setup.

After completing this step, you should see your leads being added to Google Sheets automatically with the timestamp, allowing you to track inquiries efficiently.

Conclusion

In this tutorial, we have successfully demonstrated how to integrate IndiaMART leads into Google Sheets using Pabbly Connect. This automation not only saves time but also ensures that you have a real-time record of your leads along with timestamps for better tracking and follow-ups.