Google Spreadsheets is a popular, free platform for creating and maintaining spreadsheets.


Its popularity has also resulted in Google Spreadsheets becoming a commonly accepted means of sharing data between systems.


One of the easiest ways to automate your process is to connect your form data entries to a Google Spreadsheet.


For example, if a timesheet form is captured, it would be helpful if that information appeared in a timesheet spreadsheet. This is where the Google Spreadsheet Connector for Forms comes in.


Requires an authenticated Google Connection before any form connectors can be added.

Adding a Google Spreadsheet Connector


The Form Connectors page can be accessed from the Form Designer, settings, or Screens listing page.



Once you are on the Connectors page, setting up the Google Spreadsheet connector is easy:

  • Click the ADD CONNECTOR button to see a list of the available Connectors.
  • Then click the Google Spreadsheet option.



This will refresh the page and display your Connector, ready for configuration. 



1. Spreadsheet Name

Please specify the spreadsheet's name that our system will create and keep updated as form entries are received from the app. The name of your spreadsheet should be the same as it appears on your Google account.


2. Folder Path: 

Optionally, enter a folder path on Google Drive for the exported file to be placed in. The path should be entered in the following format: 'FolderName/AnotherFolder/FileGoesInThisOne' 


3. Shared/Team Drive ID

Specify the unique identifier for this drive if you are using Shared or Team Drive.


4. Data Column

Defined which form fields to populate as row values in your target dataset.

Upon your first Form entry, each selected Form field will auto-create a column of the same name if it does not already exist.


5. Anonymize Personal Data

If enabled, data from fields marked as Personal Data will be converted to a non-human-readable format to aid privacy.


Add a Run Condition


Sometimes, you may have a Connector you only want to fire if the Form entry has a given answer value.


For example, you may have an Audit Form, which has a risk rating question with options like "Low", "Medium" and "High".

If the user answers the risk rating as "High," you want to send an email to a supervisor for follow-up and action.


This is where a Run Condition comes in.

Run Conditions are defined by creating a true/false formula.

The Connector will only run if the formula you define in the Run Condition has a true result.


So in the example above, the Run Condition formula would be something like this:

{{riskRating}} = 'High'


When you hover over the Run Condition field, you will see a hammer icon appear.

Clicking the hammer will take you to the Formula Builder, where you can create a formula as desired.


See the Creating a Formula page to learn more about form formulae.