Templates / Collect Google Form responses

 (updated: 1539707058598)
Helpers for interacting with data objects (updated: 1614613466973)

Collect Google Form responses

Beginner
WebhookObject HelperUniversal

Overview

Google Forms are commonly used to gather information from colleagues, leads, customers, and other groups.

This workflow takes Google Form Submission Data and formats it for use when a form is submitted. The formatted data can be further used in various ways, and thus, builders can configure the workflow to achieve the desired results.

Connectors Used

The following connectors are used in this template. This is provided for reference only - there is no need to read through the linked connector pages, as all you need to know for this template is explained here:

End Result

google-form
end-results-format-google-form-data

We have included a downstream steps example in the Getting Live section below, demonstrating how to store the formatted data in a third-party service. In this case, we are using Google sheets as a generic placeholder for any service or database you may wish to use.

The image below shows a Google sheet populated with formatted form-data:

end-results-add-data-to-google-sheet

Prerequisites

This workflow assumes the following:

  • You have access to Google Forms.

Workflow logic

The overall logic of the workflow is:

  1. Google Form Submission This is a webhook step that receives information sent from Google Forms.

  2. Format Google Form Data The object helper removes any special characters or spaces in the Google Form Fields so that they can be easily referenced in your workflow down the line using the Connector Snake.

  3. Set up any downstream steps The processed data can then be used in multiple ways like sending data to Salesforce, sending data through an email, or storing data in any third-party service of your choice.

complete_wf

Getting Live

In order to configure this workflow for use, simply:

Implementation notes

The key (and only!) thing that this template does is convert Google Form field names into a format that is universally acceptable by third party services and databases.

It does this by pulling in the form data from $.steps.trigger.body and using the Object Helpers 'Iterative transform (camelCase)' operation:

format-google-form-data

As you can see from the above screenshot this transforms e.g. "How satisfied were you with the event?" to "howSatisfiedWereYouWithTheEvent".

This format is acceptable as column headers in databases, custom field names etc.

So your workflow will be able to make use of them when adding new form results to e.g. Google Sheets, a CRM, a SQL database etc.