New Google Sheets authentication methods
We've added more ways for your organization to connect to Google Sheets securely.
- Service account authentication: Authenticate with a service account tied to a Google Cloud project. Allows user to give Retool access on a spreadsheet by spreadsheet basis by sharing a spreadsheet with the service account’s email.
- User OAuth: OAuth-based authentication with individual user credentials. Each user is prompted to authenticate with Google Sheets using an OAuth flow, and API calls from Retool are made on behalf of the logged-in user. When using apps built on top of Google Sheets, users can only access and edit sheets that have been shared with them in Google.
See our Google Sheets documentation for more information.
Fixes and improvements
- Fixed an invalid default ID when using a Module that starts with a number
- Fixed an issue where a Table with empty column-based data would not display the column headers
- Fixed scrollbars incorrectly appearing on the Multiselect component when wrapping is disabled
- Added year information to the History modal
- Fixed a case where query.data references would not evaluate correctly on manual query runs
- Improved labeling of components, queries, transformers, and temporary state in autocomplete
- Updated search in the Code section of the Explorer to autofocus on click
- Fixed a bug where Module input queries could be imported to the Query Library and subsequently cause the Query Library to freeze
- Added timeout support to gRPC queries
- Fixed support for sending body with custom authentication browser requests
Check out this guide to see the on-prem versions and their release notes. These fixes and improvements will be rolling out to on-prem customers in the next few weeks.