How to Search and Update Google Sheets Row using Pabbly Connect

Learn how to efficiently search and update Google Sheets rows using Pabbly Connect and Pabbly Connect in this detailed tutorial. 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. Setting Up Pabbly Connect for Google Sheets Integration

To search and update Google Sheets rows, the first step is to access Pabbly Connect. This platform allows seamless integration between various applications, including Google Sheets and Pabbly Form Builder. Start by logging into your Pabbly Connect account.

Once logged in, click on ‘Create New Workflow’. Name your workflow; for this tutorial, we will use ‘Find and Update Records Inside Google Sheet’. This name will help you easily identify the workflow later.

2. Triggering the Workflow with Pabbly Form Builder

In this section, we will set up the trigger for our workflow using Pabbly Connect. The trigger will be a new form submission from Pabbly Form Builder. This means whenever a new order ID is submitted, it will initiate the workflow.

• Select ‘Pabbly Form Builder’ as the trigger application.
• Choose the trigger event as ‘New Form Submission’.
• Copy the provided webhook URL.
• Go to your Pabbly Form Builder dashboard and add the webhook URL in the integration settings.

After saving, return to Pabbly Connect and click on ‘Capture Webhook Response’. This step ensures that any data submitted through the form is captured by Pabbly Connect.

3. Searching Google Sheets for the Order ID

Now that we have set up the trigger, the next step is to search for the order ID in Google Sheets using Pabbly Connect. This is done by selecting the Google Sheets integration and choosing the method ‘Lookup Spreadsheet Rows’.

Connect your Google Sheets account if you haven’t done so already. After connecting, select the spreadsheet containing your order data. In our case, it’s named ‘Order Sheet’. Specify the sheet as ‘Sheet1’ and the lookup column as ‘A’ where the order IDs are stored.

• Map the lookup value to the order ID received from the form submission.
• Select whether to include headers in the response.
• Choose to receive a simple response for easier mapping in the next steps.

Once everything is set up, click on ‘Save and Send Test Request’ to see if the order ID is found in the Google Sheet. The response will include the details of the order ID if it exists.

4. Updating the Google Sheets Row

After successfully searching for the order ID, the next step is to update the corresponding row in Google Sheets using Pabbly Connect. Select the Google Sheets integration again and choose the action event ‘Update Cell Value’.

Connect to your Google Sheets account once more, and select the same spreadsheet and sheet as before. For the range, you will specify the cell where the update needs to occur. Since we want to update the product shipped status, we will target column ‘F’.

Map the row index obtained from the previous step to specify which row to update. Set the value to ‘Yes’ for the product shipped status. Click ‘Save and Send Test Request’ to apply the changes.

Once the test request is successful, you will see that the product shipped status in your Google Sheet has been updated to ‘Yes’.

5. Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to search and update rows in Google Sheets based on form submissions from Pabbly Form Builder. By following these steps, you can automate the process of updating your Google Sheets easily.

This integration not only saves time but also ensures accuracy in managing your order data. Start using Pabbly Connect today to streamline your workflow!