Integrating Agriculture Products with Google Sheets Using Pabbly Connect

Learn how to integrate agriculture inquiries with Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless automation. 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 start the integration process, you need to access Pabbly Connect. First, open your web browser and go to the Pabbly Connect landing page. Here, you will find options to sign up or sign in. If you are a new user, click on ‘Sign up for free’ to create an account. Existing users can directly sign in.

Once logged in, you will see various applications offered by Pabbly. Click on ‘Access Now’ under Pabbly Connect to enter your dashboard. From here, you can create a new workflow that connects your agriculture inquiries from IndiaMART to Google Sheets.

2. Creating a Workflow in Pabbly Connect

After accessing your Pabbly Connect dashboard, click on the ‘Create Workflow’ button. You will need to name your workflow and select a folder for saving it. For this tutorial, name it ‘Agriculture Products and Farming Inquiries in Google Sheets’ and save it in the ‘Automations’ folder. using Pabbly Connect

• Click on ‘Create’ to open the workflow window.
• Select the trigger application as IndiaMART.
• Choose the trigger event as ‘New Leads’.

After setting up the trigger, Pabbly Connect will provide you with a webhook URL. This URL is crucial as it will connect your IndiaMART account with Pabbly Connect. Copy this URL for later use in the IndiaMART settings.

3. Configuring IndiaMART for Webhook Integration

Log in to your IndiaMART account and navigate to the Lead Manager section. Here, you will find the option for ‘Push API’ under Export Leads. Click on it to set up the connection with Pabbly Connect. using Pabbly Connect

• Select ‘Other’ as the source.
• Enter ‘Pabbly Connect’ as the CRM platform name.
• Paste the webhook URL you copied earlier.

After entering these details, click on ‘Save Details’. You will need to generate an OTP to complete the setup. Once you enter the OTP and submit, your IndiaMART account will be successfully connected to Pabbly Connect, allowing it to receive new lead inquiries automatically.

4. Testing the Webhook Connection

To ensure the webhook is working correctly, perform a test submission in IndiaMART. Create a dummy inquiry by clicking on ‘Contact Supplier’ and filling out the required fields. This will simulate a real inquiry and help you verify the connection. using Pabbly Connect

Once the test submission is complete, go back to Pabbly Connect’s workflow. You should see the webhook response indicating that the inquiry details have been captured. This confirmation shows that your setup is functioning correctly.

After verifying the webhook, you can proceed to set up the action step in Pabbly Connect, which will send the inquiry details to Google Sheets.

5. Adding Inquiry Details to Google Sheets

Now, select Google Sheets as the action application in Pabbly Connect. Choose the action event as ‘Add New Row’. If you haven’t already connected your Google Sheets account, click on ‘Add a New Connection’ and authorize Pabbly Connect to access your Google Sheets. using Pabbly Connect

Select the spreadsheet where you want to store the inquiry details. Map the fields such as name, email, phone number, and query from the webhook response to the corresponding columns in your Google Sheets. This mapping ensures that every new inquiry is recorded accurately.

Finally, click on ‘Save and Send Test Request’ to confirm that the details are being added to your Google Sheets. Upon successful completion, you will see the inquiry details reflected in your spreadsheet, confirming that the integration is working seamlessly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding agriculture inquiries to Google Sheets. By following these steps, you can streamline your lead management effectively and save valuable time.