How to Set Up Google Sheets Integration

Google Sheets integration allows you to automatically get your form response data to the specified Google Sheet of your connected Google account. The integration is set up on a per form basis.

To set up the integration: Form -> Builder -> Set Up -> 3rd Party Integrations -> Google Sheets Please follow further instructions to connect to your Google account and create a new or use an existing spreadsheet to get the form’s responses.

How Google Sheets Integration works

As soon as the first response arrives, AidaForm creates a sheet in the specified document. The sheet contains columns with the headings equal to the headings of the fields on your connected form and following in the same order as the fields on your form.

When other responses for the form arrive, AidaForm decides where to add their data on the basis of the chosen ‘Set up sheet’ option.

What is the difference between the ‘Set up sheet’ options?

There are two options allowing you to set up how the response data will be added to the connected spreadsheet:

• Let AidaForm create a new sheet when any changes on the form occur
• Always add the form results to the sheet named ‘Results’

How ‘Let AidaForm create a new sheet when any changes on the form occur’ works:

When you choose this option, every time a new response arrives, AidaForm compares the headings, order, and the number of the columns of the current sheet with the headings, order, and the number of fields on the connected form. If any changes are discovered, AidaForm creates a new sheet and adds new response data to the new sheet.

A new sheet is created when:

• You change the headings of the columns of the sheet
• You change the order of the columns of the sheet
• You change the headings of the fillable fields on your form
• You change the order of the existing fillable fields on your form
• You add/delete fillable fields to your form

How ‘Always add the form results to the sheet named ‘Results’ works:

When you choose this option, AidaForm will always add response data to the sheet with the specified name. In this case, AidaForm does not compare the headings of the column with that of a form field; it simply distributes data from form fields into columns in the same order in which the fields are located on the form.

Advantages:

• You can rename your sheet columns’ headings and still be able to collect response data in the sheet.
• You can change headings of any fillable fields on your form, but the response data will be correctly added to the sheet.

Tips and Tricks: if you’d like to add/delete fillable fields to your form or move some fields to other parts of your form, simply rename your current sheet. When the next response data arrives, AidaForm will create in your document a new sheet with the specified name and start adding response data to the columns corresponding to your renewed form.