Collecting and importing data using a Google Form is easy with our Google Sheets integration.
For step-by-step instructions watch the video below.
- Make sure date is in the following format: 8/23/2019 19:12:54 This is the default format for Google sheets.
- Share your Google Sheet spreadsheet with firstname.lastname@example.org
- Click on Authorize access to google sheets. Log into your google account, click advanced, and then go to FMYI. Authorize FMYI to access google sheets, allow read access. If the person who authorized the sync is no longer working with you, you will need to have the new owner of the spreadsheet re-authorize the sync.
- Verify access to your spreadsheet by entering spreadsheet ID. This is the long string of letters and numbers in the middle of the web address.
- Select workspace type and default profile. Save Settings.
- Select unique identifier and corresponding column to enable Sync.
- Optional - Select column for default workspace name. If left blank, new workspace name will default to "no name".
- Map any additional fields.
- Tip: Search label tag will be set to blank if a matching tag name is not found. Ex: If search label, has tags "yes" and "no". To reset to a blank value, set column value to anything besides "yes" or "no" ie "unknown".
Need to Authorize Grouptrail to Access your sheet?
Follow these steps: