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.
- Go to the credentials section displayed on the left sidebar
- In the Credentials section create a new OAuth clientID then:
- Choose the Web application type
- If prompted, follow the instructions to verify your domain and configure your consent screen
In the Authorized redirect URIs section enter the URI in the following format and press create
https://www.example.com/flexbi/source_applications/auth/google_spreadsheets/callback
Where "flexbi" is your prefix that you have set up in start.sh file.
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 = "..."
- Restart flex.bi server