Versions Compared

Version Old Version 6 New Version 7
Changes made by

Megan Ellis

Megan Ellis

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...


Section


Column

Live Forms provides wizards and a Google Connector that support easy direct connectivity with Google Sheets. You'll need a Google account and a Live Forms account.

Each time someone uses and submits your form, a new row is added to your Google sheet.

Let’s look at the most basic and common use case. You have a form and you want to collect your submissions in a Google Sheet.


Column
width30%

On This Page:

Table of Contents
maxLevel1

...



Step 1 - Obtain the Google Account Access token

...

Tip

Google sheet column names are not case sensitive. So a column name “First Name” is equivalent to a column named “first name”. Also spaces in the column name are ignored. So “first name” is equivalent to "firstname".


Warning

Google sheet column names must match Control Names exactly. Keep in mind that Control Names cannot contain space, special characters or start with a number.

Step 4: Connect your form to your spreadsheet using the Save to Google Sheets wizard.


Excerpt
  1. Edit your form/workflow
  2. Click the Image Modified Edit Form/Workflow Properties icon in the designer(s) toolbar.
  3. Click on the Document Actions tab, then click the Send Data tab.
  4. Check Post Submissions to a Google Spreadsheet.
    Image Modified
  5. This launches the Google Sheet Wizard.
  6. Enter your Oauth token (from Step 1). Note that the email field is optional and intended only to describe which account is associated with the access token. This email does not validate against the token provided.
  7. A Spreadsheet dropdown appears listing all the spreadsheets in your Google account
  8. Select the Google Sheet from the list. 
  9. Select the worksheet of your Google Sheet from the dropdown.

  10. Click Submit.

  11. That’s it. When the form is submitted, the data will be saved to the selected Google Sheet.  



You can perform all the usual operations on the data e.g. see the Graphs Tab in our example sheet and you can see how we have created some sample graphs to analyze our submission data.

Image Modified 

Troubleshooting

"An unknown error has occurred" message

You may see the error message "An unknown error has occurred" when selecting your Google sheet from the dropdown after you log into the wizard with your Google account and access code. To prevent this, set the Share permission for your Google Sheet to private then run the Save to Google Spreadsheet wizard. Change the share permission to public once the wizard is completed. Click here for other reasons this error may occur.