Help · Sending responses on

Google Sheets

A spreadsheet per form in your own Drive, a row per response.

Settings › Google Sheets › Connect Google sends you to Google to allow Papias to make spreadsheets in your Drive. One Google account per workspace. The permission is the narrow one: Papias sees and writes the spreadsheets it made and nothing else in the Drive.

Back in the builder, a spreadsheet named after the form with a Responses tab is made and linked. Each response is appended as a row as it's stored: Submitted (UTC), then the form's questions in order, a repeating group as one column, and a link to the response. If you add or rename questions, the heading row is rewritten the next time a response arrives. The last five sends show in the settings with their outcome.

Stop sending keeps the spreadsheet in Drive and stops the rows. Disconnect forgets the Google account for the whole workspace. A copy of the form doesn't take the spreadsheet with it.

If Google stops accepting the connection (the permission was removed in your Google account, say), the settings say "connect the account again"; if the spreadsheet was deleted, that it's gone. Pro and Business only.

Not what you were looking for? Ask us, and we'll answer and fix the page.