Google Sheets API: How to Retrieve Shared Files in Bold BI

At present, the Google Sheets API does not support the retrieval of shared files owned by other users. However, this functionality can be achieved by utilizing the ‘Shared data source permission’ or ‘Manage Permission’ feature in Bold BI. To enable access to a shared file, the owner of the file must create a Google data source using that file and then share the created data source with the specific user. Alternatively, if a user has ‘Manage permission’ to access all data sources, they can access the data sources.

For Example:
There are two users in Bold BI namely Sync and Demo. The Sync user has created a Google Sheet data source.

To share a specific data source with a user:

1. Click on the Sharing Permissions option for the desired data source.
   

   

2. Select the Users and Group with whom you would like to share this data source, then click the Share button
   

   
   
   
   

3. The Google Sheet data source will now be available for the Demo user
   

   

To provide access permission to all data sources:

1. On the Users page, click Manage Permissions for the user to whom you would like to grant read/write permissions.
   

   

2. Click the Add Permission button.
   

   

3. Select the All Data Sources entity and set the access mode to ‘Read’ and ‘Write.’ Then, click the Add button.
   

   

4. The provided permissions will be displayed on the Manage Permission page.
   

   

5. All data sources can be viewed under the Demo user on the ‘Data Source’ page.
   

   

Additional References

• Google Sheets connector in Bold BI