Page Comparison

To use Google Spreadsheets as a data source, you need to add authentication keys for the Google Spreadsheets source application. To add the authentication keys you need to
To do this, follow these instructions:

1. 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.)
2. In the Dashboard

...

1. section, go to Enable APIS AND SERVICES and enable Google Drive API and Google Sheets API.
   Image Modified
2. Add the Google Drive API to the created project.
3. Go to the

...

1. Credentials section displayed on the left sidebar.
   
   Image Modified
   
   
2. In the Credentials section, create a new OAuth clientID

...

1. .
2. Choose the Web application type.
3. If prompted, follow the instructions to verify your domain and configure your consent screen.

4. In the Authorized redirect URIs section enter the URI in the following format and press

...

1. Create. (Change flexbi to the prefix that you have set up in the start.sh file.)

   Code Block
   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. 

1. Enter the Client ID and Client secret inside your flex.bi

...

1. config/eazybi.toml

...

1.  file:

   Code Block
   [source_application.google_spreadsheets] client_id = "..." client_secret = "..."

   
   

2. Add "google_spreadsheets"

...

1.  to the application_tupes list in your config/eazybi.toml

...

1.  file: 

   Code Block
   application_types =

...

1. "jira", "rest_api", "sql", "hansaworld", "google_spreadsheets" ]

   
   

2. Restart flex.bi

...

1. Enterprise service.