This article covers how to connect Openprise to Google Drive - Sheets when setting up a data source. You will need a Google Account and credentials for Openprise. You can learn more about Data Sources here.
When creating a new data source, select Google Drive - Sheets from the source technology and data format picklist.
- Select the Add Account Information button to link your Google Account to Openprise
- Click on the Add Account button to sign into your Google Account using your Google credentials
- Select from an existing account if you've already linked your Google Account to Openprise
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.
NOTE: We recommend importing data using Google Drive - Sheets if your table contains less than 10,000 rows of data. If your table contains over 10,000 rows of data, import data using Google Drive - CSV as the source technology.