Integrating Industrial Supplies Inquiries to Google Sheets with Pabbly Connect

Learn how to automate the process of adding Industrial Supplies inquiries to Google Sheets using Pabbly Connect. Step-by-step guide included. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, visit the official website and sign in to your account. If you are a new user, you can sign up for a free account, which provides you with 100 tasks monthly.

After logging in, you will see the dashboard that displays all your workflows. Click on the Pabbly Connect option to access the integration features. This platform allows you to automate tasks without any coding knowledge.

2. Creating a New Workflow in Pabbly Connect

In this section, we will create a new workflow to automate the process of adding inquiries from Industrial Supplies to Google Sheets. Click on the Pabbly Connect option and select Create Workflow.

• Name your workflow as ‘Add IndiaMart Inquiry Leads to Google Sheets’.
• Select the appropriate folder for your workflow.
• Click on Create to proceed.

After creating the workflow, you will see two boxes: one for the trigger and another for the action. The trigger will be set to IndiaMart and the action will be Google Sheets, allowing you to automate the inquiry process.

3. Setting Up Trigger and Action in Pabbly Connect

In this step, we will set up the trigger and action for our workflow using Pabbly Connect. For the trigger, select IndiaMart and choose the event as New Leads. This means that whenever a new inquiry is received, it will trigger the workflow.

Next, you need to connect your IndiaMart account to Pabbly Connect by using the provided webhook URL. This URL acts as a bridge between IndiaMart and Pabbly Connect. Copy the webhook URL and navigate to your IndiaMart account.

• Go to the Lead Manager in IndiaMart.
• Click on the three dots and select Push API.
• Paste the webhook URL and save your settings.

After saving, you will need to verify the connection by generating an OTP. Enter the OTP received to complete the integration.

4. Testing the Integration with Pabbly Connect

Now that the trigger is set up, it’s time to test the integration using Pabbly Connect. To do this, send a test inquiry from your IndiaMart account. This will allow you to check if the webhook is receiving data correctly.

After sending the inquiry, return to Pabbly Connect and check for the webhook response. If the response indicates success, it means your inquiry has been successfully captured. You will see details such as the unique query ID, sender’s name, email address, and the inquiry itself.

Verify the details received in the webhook response. Ensure that the data matches your test inquiry. Confirm that the connection is established successfully.

With the successful response, you can now proceed to set up the action step.

5. Adding Inquiries to Google Sheets Using Pabbly Connect

The final step is to add the inquiries to Google Sheets through Pabbly Connect. Select Google Sheets as your action application and choose Add New Row as the action event.

Connect your Google Sheets account to Pabbly Connect by signing in and granting the necessary permissions. Once connected, select the spreadsheet where you want to store the inquiries.

Choose the correct spreadsheet from the dropdown list. Map the fields from the webhook response to the corresponding columns in Google Sheets. Click on Save and Send Test Request to finalize.

After clicking save, check your Google Sheets to see if the inquiry has been added successfully. You should see all the details populated correctly, confirming that the integration works flawlessly.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the process of adding Industrial Supplies inquiries to Google Sheets. By following these steps, you can streamline your workflow and manage inquiries efficiently.