How to Add Formula in Google Sheets inside Pabbly Connect Workflow

Learn how to integrate Google Sheets with Pabbly Connect and add formulas to automate your workflows effectively. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect Workflow

To begin using Pabbly Connect for integrating Google Sheets, first access your Pabbly Connect account. Once logged in, create a new workflow by selecting the trigger application, which in this case is Pabbly Builder. This allows you to capture responses from forms created in Pabbly Builder.

After setting up the trigger, connect your Pabbly Builder form with Pabbly Connect using the provided webhook URL. This integration will enable Pabbly Connect to capture the data, such as first name, last name, and numerical values, which will be used in Google Sheets.

2. Adding Data to Google Sheets Using Formulas

After capturing the form responses, the next step is to add this data into Google Sheets. In your Pabbly Connect workflow, select the Google Sheets application as your next action step. Here, you will map the captured data fields to the corresponding columns in your Google Sheet.

• Select the Google Sheets action event.
• Map the first name, last name, and numerical values to their respective columns.
• In the result column, you will add a formula to sum the numerical values.

In the mapping data, enter the formula directly. For example, use the SUM function to calculate the total of the three numerical values. This formula will automatically update in your Google Sheet whenever a new form submission is processed through Pabbly Connect.

3. Testing the Integration with Pabbly Connect

Once you have set up the formula in your Google Sheets action, it’s essential to test the integration. In Pabbly Connect, click on the ‘Test Request’ button to send a test submission. This will help verify that the data is correctly added to Google Sheets.

After testing, you should see the data in your Google Sheet, including the first name, last name, and the calculated sum in the result column. Ensure that the formula is functioning correctly by checking if the sum reflects the values submitted through the form.

4. Using Number Formatter in Pabbly Connect

Another method to handle formulas in Google Sheets is by using the Number Formatter feature in Pabbly Connect. To do this, add an action step before your Google Sheets action and select the Number Formatter app.

Choose the action event for spreadsheet formulas and enter the desired formula, such as SUM, in the provided field. Map the same numerical values from your form submission into this formula. After saving and sending the test request, you will receive the calculated result directly from the Number Formatter.

5. Mapping Results Back to Google Sheets

After receiving the calculated result from the Number Formatter, you can map this result back into your Google Sheets action step in Pabbly Connect. Clear the previous mapping in the result field and select the response from the Number Formatter.

This method allows you to add the actual calculated value into Google Sheets rather than the formula itself. Click on ‘Save and Send Test Request’ to finalize the integration and ensure that the correct data appears in your Google Sheets.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to integrate Google Sheets and automate the addition of formulas. By following the steps outlined, you can efficiently manage data submissions and calculations within your workflows. This integration streamlines your processes and enhances productivity.