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 (If at any point you do not have permission to add or edit make sure you are on the right project)
• In Dashboard section go to Enable APIS AND SERVICES and enable Google Drive API and Google Sheets 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 = "..."

    
    

  • Add "google_spreadsheets" to your config/eazybi.toml file like so: 

    application_types = [ "jira", "rest_api", "sql", "hansaworld", "google_spreadsheets" ]

    
    

• Restart flex.bi server
• If you are receiving a "This app isn't verified" error, when creating a Google Spreadsheet, consider joining your user to the "Risky access by unreviewed apps group" or submit an app approval form to Google