Retool now supports an integration to Google Docs, which utilizes the Google Docs API and the Google Drive API. Use this integration to retrieve, create, and update documents.
This integration is currently in public beta on Retool Cloud and on Self-hosted Retool.
Hey @Michael_Huang
This comes in handy;
I just tested it but got this during the OAuth callback:
tried with two Google accounts, personal and workspace as well, but same issue.
Any clues?
Exciting news @Michael_Huang - looking forward to testing out the new integration.
In the past, we've experienced two things that have hold us back from integrating deeper between Google Workspace and Retool.
File Selector UX
Would this new integration allow us to bring up a UX for file selection from Google Drive? Either a Retool version or the native Google Drive UX (aka Google Picker API)? We need functionality, so that users can select the file / doc / sheet to work on via search or from their list of recent / starred files. This seems like such a standard requirement, so that it doesn't seem to make sense that every Retool customer re-implements such a UX on their own.
Lack of control regarding when the OAuth flow happens.
We'd like to use the user's identity to control access to files. But our Retool App users react very strongly against an OAuth flow being triggered when the app opens. To users who just want to discover / check out a Retool App to understand whether it's for them, it's the most sure-fire way to discourage users from using such an app at all. Instead we would like the OAuth flow to only start once when the user wants to interact with Google Drive / Docs / Sheets for the first time (i.e., only once, when they click an import or export button for the first time).
Is this something where the new integration can help us out?
I've noticed an issue with the Sheets Resource. The "Read data from a spreadsheet" action appears limited to 26 columns. When I try to read from a sheet with more columns, the columns beyond Z are ignored. Would love to see this limit relaxed to handle sheets with more than 26 columns of data.
Thanks for the feedback and questions!
@michael_h, the integration exposes the get /files endpoint, so you could filter those results as needed and connect it to a Retool component (table, listView, etc)
The integration is set up such that the end user will see an auth modal on page load if they aren't already authenticated.
@jericsinger, I will post here if we add that to the Sheets integration
@abusedmedia, I haven't been able to reproduce this bug with any of my google accounts 
Are you still experiencing this? What is the custom domain or Retool subdomain for the org where you're testing?
Hi Tess,
thanks a lot for looking into this, really appreciated.
The integration is set up such that the end user will see an auth modal on page load if they aren't already authenticated.
We would love if we could configure that unauthenticated users will only see the OAuth flow on first query run on a resource that requires OAuth.
Although this would be especially helpful for Google Workspace integrations, this has a bit wider scope and could be beneficial for any resource that uses OAuth. So maybe it's better to track this as a more general feature request:
