How to Use ‘Append Value’ Action Event in Google Sheets with Pabbly Connect

Learn how to use the ‘Append Value’ action event in Google Sheets using Pabbly Connect. This tutorial covers setup, integration, and mapping steps. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Sheets Integration

To use the ‘Append Value’ action event in Google Sheets, start by accessing Pabbly Connect. This platform allows you to integrate various applications seamlessly. First, log in to your Pabbly Connect account and create a new workflow.

Choose the trigger application, which in this case is Pabbly Form Builder. This integration enables you to collect data from a form and append it to Google Sheets. Once you set up the trigger, you can proceed to configure the action event.

2. Filling Out the Form in Pabbly Form Builder

Next, you need to fill out the form that you’ve created in Pabbly Form Builder. This form collects user data that you want to append to Google Sheets. For example, enter the following dummy data:

• Name: Dummy User
• Email: [email protected]
• Phone: 1234567890
• Travel Date: 28th September
• Number of Travelers: 4+
• Destination: Sikkim
• Travel Budget: 80000

After filling out the form, submit it. You will receive a confirmation message indicating that your submission was successful. This data will now be sent to Pabbly Connect for further processing.

3. Connecting Google Sheets to Pabbly Connect

Now that you have the data from the form, the next step is to connect Google Sheets using Pabbly Connect. Select Google Sheets as the action application and choose the action event ‘Append Values’. This will allow you to add the form data to your Google Sheets.

In the connection settings, select the specific spreadsheet you want to use for appending the data. Make sure to map the correct fields from the form submission to the corresponding columns in your Google Sheet. This step ensures that all data is accurately reflected in your spreadsheet.

4. Mapping Values in Google Sheets

In this step, you will map the values received from the form submission to your Google Sheets. In Pabbly Connect, you need to enter the row values in a comma-separated format. For instance, if you have eight fields, you will input them in the following format:

• Value 1: First Name
• Value 2: Last Name
• Value 3: Email
• Value 4: Phone Number
• Value 5: Travel Date
• Value 6: Destination
• Value 7: Travel Budget
• Value 8: Number of Travelers

Ensure that you do not leave any extra commas or spaces in your mapping to avoid errors. Once you have accurately mapped all the values, you can proceed to save and send the test request.

5. Testing the Integration in Pabbly Connect

After mapping the values, click on the ‘Save and Send Test Request’ button in Pabbly Connect. This action will attempt to append the values to your Google Sheets. If everything is set up correctly, you will receive a successful response indicating that the data has been appended.

If you encounter any errors, double-check your mapping for any extra commas or incorrect formats. Once the test is successful, you can view the appended data in your Google Sheets. This confirms that the integration is working seamlessly through Pabbly Connect.

Conclusion

Using Pabbly Connect to integrate Google Sheets with Pabbly Form Builder allows for efficient data management. The ‘Append Value’ action event simplifies adding form submissions directly into your spreadsheet. Follow the outlined steps to ensure smooth integration and accurate data handling.