How to create a Google Sheets form
Send responses from your Fillout form to a Google Sheet. Set up this integration in less than 30 seconds to automatically sync a spreadsheet to your form questions.
Google Sheets is a web-based spreadsheet application, offering 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.
Note: If you already have a form that you now want to connect to Google Sheets, you can skip to the section below.
+ New formfollowed by
Google Sheetsas an integration option.
Choose your theme (don’t worry, you can always change this later).
Sign in with Googleto connect your account.
Choose the account you’d like to to have the Google sheet be created in. Click
Continueto grant access to Fillout to only the sheets that have been created by Fillout
At this point, a new Google Sheet has been created on your account, which you can always find by checking the settings of the integration on the Integrations tab in the editor. You can add new questions, change your theme, and all of those changes will automatically be reflected in the sheet.
To connect a form that you’ve already made to a Google Sheet, simply head to Integrations , and select
Once you’ve selected
Google Sheets, follow the steps above to Connect to your Google Account. Your form submissions will all now automatically sync to a new Google Sheet! You can always revisit this tab to view which sheet your submissions are heading to
- Note that all date timestamps that are sent to your Google Sheet (using the
Date time pickerfield in Fillout) are written in UTC.
- To display times in a local timezone, you can add an extra formula column to do so.
- By default, all of the answers in your address field will be added to separate columns in your Google Sheet. Use this to easily sift through answers from a certain City/State, or hide the columns which you don’t need