How to create a Google Sheets form
Sync responses from your Fillout form to a Google Sheet in under 30 seconds.
![notion image](/_next/image?url=https%3A%2F%2Fwww.notion.so%2Fimage%2Fhttps%253A%252F%252Fprod-files-secure.s3.us-west-2.amazonaws.com%252F2a7ed980-5add-4b51-82ab-889415f57134%252F7ff59883-2275-4173-ad8f-23bce84d3b7e%252Fimage.png%3Ftable%3Dblock%26id%3Dd93a0843-bf4b-4f7f-961a-82c71dfbf5fa%26cache%3Dv2&w=3840&q=75)
What Google Sheets is
Google Sheets offers users a collaborative platform to create, edit, and store spreadsheets online. It provides a wide range of features for data analysis, visualization, and sharing, making it a versatile tool for businesses, educators, and individuals.
Video Tutorial
![Video preview](https://i.ytimg.com/vi/lD4h82s0LeE/hqdefault.jpg)
How it works
1. Start with a form synced to Google Sheets
In the homepage,
+ Make a Fillout
followed by Connect
and choose Google Sheets.![notion image](/_next/image?url=https%3A%2F%2Fwww.notion.so%2Fimage%2Fattachment%253A82de94a2-3adb-44f7-a24b-49677a2ad75d%253Aimage.png%3Ftable%3Dblock%26id%3D19a0ee47-667b-8022-a288-cf51c52a12de%26cache%3Dv2&w=3840&q=75)
Choose your theme (don’t worry, you can always change this later).
Sign in with Google
to connect your account. If you already have an existing form, simply go to the Integrate page and look for Google Sheets.
2. View the spreadsheet
A new sheet will automatically be created that will receive form responses. Click
this sheet
to open the sheet linked to your form. ![notion image](/_next/image?url=https%3A%2F%2Fwww.notion.so%2Fimage%2Fattachment%253A42bc5a86-3fb4-403e-bb3b-bee77f9fa39e%253AScreenshot_2025-02-14_at_2.35.10_PM.png%3Ftable%3Dblock%26id%3D19a0ee47-667b-8089-84ce-e25d69c18791%26cache%3Dv2&w=3840&q=75)
Every question or field you add to your form will automatically become a column in your sheet.
![notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fc6397d81-4807-4eb5-8ddf-f83afdb10cb7%2FUntitled.png?table=block&id=fe42734e-a5e1-45b8-b994-9b444d06bd59&cache=v2)
Good to know: Fillout has many powerful features like branching and conditional hide/appear logic. No matter how complex your needs are, there’s a way to build it in Fillout.
Working with different field/question types in Fillout
Date times
- Note that all date timestamps that are sent to your Google Sheet (using the
Date time picker
field in Fillout) are written in UTC.
- To display times in a local timezone, you can add an extra formula column to do so.
Address field
- By default, each part of the address field is added to separate columns in your Google Sheet. This makes it easy to filter responses by city or state, or simply hide the columns you don’t need.
Specify a condition
You can run your integration only when a specific condition is met. Check out this guide.