Google Spreadsheets data source (Enterprise setup guide)

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 client ID 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 = "..."