Google Docs integration

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.

4 Likes

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?

1 Like

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.

  1. 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.

  2. 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 the 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?

1 Like