Skip to content
Integrations Google Sheets

Every response,
one new row.

Send completed form responses straight to Google Sheets. Pick a spreadsheet once and every new answer lands in its own row, in the columns you chose.

Included on Free, Pro, and Business.

TRULYFORM

A response is completed

Name, email, answers, scores.
Saved in trulyform first.

Completed
GOOGLE SHEETS

A row appears

Same columns every time.
Ready to sort, filter and share.

Added in seconds

THREE STEPS. NO FORMULAS.

From form to spreadsheet in a minute.

  1. 1

    Connect Google

    Connect your Google account once on the Integrations page. Everyone in your organization can then use it on any form.

  2. 2

    Choose a spreadsheet

    Let trulyform create a new spreadsheet with the right headers, or pick an existing one and match its columns.

  3. 3

    Collect responses

    Each completed response adds a row. Send the responses you already have, too, with one click.

A sheet you can rely on.

Columns that stay put

Columns follow the question, not its wording. Rename a question and its answers keep landing in the same column.

No duplicate rows

Every row carries the response ID. If Google hiccups, trulyform checks the sheet before trying again.

Nothing silently lost

If a tab is deleted or access changes, the delivery is held, you get one email, and you can retry when it is fixed.

A little more detail.

What can trulyform see in my Google Drive?

Only the spreadsheets trulyform creates for you and the ones you pick in Google’s own file picker. It cannot browse, read or change anything else in your Drive. You can disconnect at any time from the Integrations page or from your Google account settings.

What goes in each row?

A Response ID column, the submission time in UTC, and one column for each question and calculated value you choose. Choices are separated by commas, files appear as their names with a link that opens them for signed-in members of your organization, and answers are always written as plain values, so text that looks like a formula is never run.

What happens when I add a question to my form?

Existing columns keep working. trulyform shows the new question on the form’s Integrations tab, and one click adds its column to the sheet.

Can I send responses I collected before connecting?

Yes. When you set up the integration you can include the form’s existing completed responses. They are added oldest first, at a pace Google allows, and a response is never added twice.

Does it update rows when a response changes or is deleted?

No. Each completed response adds one row, and trulyform never edits or deletes rows already in your spreadsheet. Deleting a response in trulyform keeps your spreadsheet as it is.

Your answers,
already in a sheet.

Beautiful forms, connected to the spreadsheets your team already uses. Google Sheets is included on every plan.

Start free