Google Sheets Data Destination



The Google Sheets data destination sends data from submitted forms to a Google Sheets spreadsheet.  Use form data to create a new spreadsheet, or add information to an existing spreadsheet and keep track of related submissions in a single file. Create custom spreadsheet and folder names based on data in the form to logically organize and manage files.  

To set up a destination, follow the instructions here: Creating and Maintaining Data Destinations

Data destinations automatically back up data collected in the field.  They reduce the need to visit the web portal by making submitted forms available through the services you already use.  Different documents can also be sent to different services with a single form submission.  Read here for more information on data destinations.


Google Sheets allows users to create, share, and store spreadsheets in the cloud.   Google Sheets is directly integrated with Google Drive, making stored spreadsheets available on a number of desktop or mobile device environments.  Looking for two-way integration?  Read more about how ProntoForms connects with Google services.

[ top ]


Sheet Configuration

Spreadsheet Name

This is the name of the spreadsheet your data will be sent to.  If it exists already, your data will be added as a new row.  If it doesn't exist yet, it will be created.  Use Data Record Expression Language (DREL) to customize the spreadsheet name based on data collected forms.



 Worksheet Name

This is the name of the worksheet within the spreadsheet your data will be sent to.  Worksheet Name is static, and will not process DREL. 


[ top ]



This is the folder your documents will be sent to.  If the folder doesn't exist yet, it will be created.


  • Single folder: Enter the folder name.  For a folder named "Inspections",  enter "Inspections".
  • Multiple folders:  Use Data Record Expression Language.
    • %f - to sort submissions into folders named after the form.
    • %u - to sort submissions into folders named after the user submitting the form.
    • %a[Unique ID] - to sort submissions into folders named with the answer to a chosen question. Read our documentation on Unique IDs
    • Optionally add static text for formatting - eg.  "%f -- %a[Customer Name]"
  • Subfolders: Enter a forward slash (/) following the first folder, and then the name of the subfolder. 
    • %f/%a[Customer Name] - to sort submissions into folders named after the form, and subfolders named after customers.  

[ top ]


Metadata Columns

Optionally customize which metadata columns are included in your spreadsheet.  A number of columns are included by default, but these can be removed.  The Data Record Name and Reference Number columns are commonly added to the export to make rows of data more identifiable. 


  • Use the  right_arrow.jpg button to add columns to the Selected list.
  • Click on the column in the Selected list, then use the up.png and down.png arrows to reorder the columns as desired.  


  • The Available Metadata Columns are:

Data Record Name  

The name of the data record.


The address of where the form is submitted, based on geo location data.

User Name

This is the name and username of the user submitting the form. 

Form Version

The version of the form being filled out. 

Device OS

The operating system of the device the form is filled out on. 

Reference Number

An unique reference number for the form. 

Server Receive Time

The time the data record is received by the ProntoForms server.

Device OS Version

The operating system on the device the form is filled out on. 

FormSpace Name

The FormSpace where the form is saved. 

Local Submitter Entry Time  

Local time when the form is submitted

Mobile Application version

The version of the ProntoForms app when the form was filled out. 

Device Entry Time

What time the device accessed the form.

Form Name

The name of the form


The geo location collected when the form is submitted. 

[ top ]


Send all Answers

  • If selected, all questions from submitted forms will be sent to the spreadsheet.  
  • If not selected, only data from the questions chosen will be included.  
  • Under Question Labels to Send (which appears when the box is unchecked), enter the question labels to include, separated by a comma, semicolon, or return.  Read more about Unique IDs (Question Labels) here.


[ top ]


Expected Results

Once a form submission has been made and processed by the data destination, an entry will have been made to the appropriate Google Sheet. 


  • In the Folder you specified
  • In the Sheet you specified

If one of the above did not already exist, the Folder or Sheet should now have been created. 


  • Metadata Columns: These will be created as the first columns in the sheet
  • Answer Columns:
    • These will be created after the metadata columns
    • They will appear in the order they occur in the form
    • The column headers will be Unique IDs
      • If you modify a question unique identifier, a new column will be created for this question


  • Answers that were NOT collected in a repeatable section will be printed as a single row in your sheet
  • If you have Repeatable Sections in your form, an additional row will be printed for each answer into the Repeatable Section.  All other information will also be repeated on every line. 


Below is the result of a single form submission.    Part/Quantity/Price are questions within a repeatable section, which has 3 entries. 

Data Record ID Customer  PO Part Quantity Price
123456789 Company ABC 123 Compressor 1 $250.00
123456789 Company ABC 123 Control Board 1 $100.00
123456789 Company ABC 123 Switch 3 $25.00

 [ top ]



Testing and Troubleshooting Data Destinations

Data destinations should be configured and tested carefully before using them in production. This is key to ensuring that ProntoForms data is received correctly. Read more about testing and troubleshooting data destinations

Error: Overloaded Connection 

Google Sheets does not support multiple writes to a spreadsheet at the same time. If a team has a very high data record volume, a different Data Destination type should be used. Alternative Data Destination types are available for use with ProntoForms.  

If there are two or more data records submitted to a Google Sheets destination at or around the same time, one of them will receive the error message, "Connection to Google Sheets is overloaded, please try again later".

  • The destination will try to resubmit up to 5 times and, for a typical submission, it takes from 4 to 10 seconds for a single Google Sheets destination to execute. When the first execution finishes, the other execution(s) will be retried. If multiple re-submissions occur at the same time, the error will occur again.


Using Shared Google Sheets as Destinations

ProntoForms only reads and writes to Google Sheets in the "My Drive" folder, meaning that sheets that have been shared with the user associated with the connection/destination will not work. Below is a workaround for this error:

You can add a Google Sheet that has been shared with you into your "My Drive" area. Any changes made in your "My Drive" area (accessible by ProntoForms) will also be reflected in the Google Sheet in the "Shared with me" folder.

To add the Sheet to "My Drive", simply right-click on the file in the shared folder, and select "Add to My Drive":



[ top ]

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request


  • Avatar
    Richard Hammond

    Is it not possible to send the question text for the column headers rather that the question labels?