You can connect Google Drive - Sheets as a Data Source. Select Google Drive - Sheets from the Connect data dropdown. You will need a Google Account and credentials for Openprise.
When creating a new data source, select Google Drive - Sheets from the Connect data picklist.
- Select from an existing account if you've already linked your Google Account to Openprise
- Select the Add Credential button to link your Google Account to Openprise
If you've selected Add Credential, you will sign in to your Google Account. Begin by choosing the correct account.
Then, select the Continue button on the next screen.
Lastly, allow Openprise access to the account.
Directory or entity: Select the folder in your Google Drive containing the sheet you want to import as a new data source. We recommend storing sheets in folders and organizing folders based on projects you're working on in Openprise.
File format: Select the file that you'd like to import located inside of the folder you selected in the directory or entity section above.
Configure attributes types: Select the attribute type for each attribute that was imported from your sheet. Options are: Date & Time, IP Address, Whole Number, Real Number, Text single-value, Text multi-value, and Yes/No.