Our new integration with Google Sheets enables a seamless connection between your Board forms and Google Sheets, streamlining data management and analysis. With this integration, form responses are effortlessly captured directly in a spreadsheet, enhancing your ability to process and respond to data efficiently.
Each response submitted through your form is instantly recorded in the Google Sheets, updating in real-time. You can easily access this spreadsheet from your form settings, where a direct link is provided once you create, update, and save your form.
Important: A Gmail account is mandatory.
Go to your Drive and search for the Page name/Form name:
To keep everything running smoothly, here are a couple of things to keep in mind:
- Keep the structure: Try not to rearrange the columns or delete anything in your Google Sheet that was set up through Board. Changes like these can break the link and stop new data from coming in.
- Data safety: Any adjustments you make directly in the Google Sheet, like changing text in the cells, won’t affect new data coming in. But remember, if you play around too much with the structure, we might not be able to get it back just the way it was.
- Copying pages: When a page with a form connected to Google Sheets is copied, the newly created page will require its own connection. Once connected, a dedicated spreadsheet will be created for this new form as well.
The integration is designed to be flexible and user-friendly:
- Modify your form: You can add or remove forms fields as necessary within Boards. These changes won’t affect the data already captured in your Google Sheet.
- Rename your spreadsheet: Feel free to rename your spreadsheet in Google Sheets at any time; it won’t affect the integration.
- Easy navigation: A quick link in your form’s settings allows you to jump straight to your Google Sheet for easy data access.
