To use Google Spreadsheets you need to add authentication keys for the Google Spreadsheets source application. To add the authentication keys you need to:
- Create a project (or use an existing project) at https://console.developers.google.com
- In API section enable the Google Drive API.
- Add the Google Drive API to the created project.
- In the Credentials section create a new OAuth client ID then:
- Choose the Web application type
In the Authorized redirect URIs section enter the URI in the following format and press create
https://www.example.com/bi/source_applications/auth/google_spreadsheets/callback
Place the Client ID and Client secret inside your flex.bi installations config/eazybi.toml file like so:
[source_application.google_spreadsheets] client_id = "..." client_secret = "..."