Use Google Drive or Picker API to Select/Download Files from Drive

Trying to use either the Google Drive API or what I understand is a 'subset' of that one, the Google Picker API to basically load the Google Picker, a sort of file browser, so a user could select files from their Google Drive to bring into Retool.

I'm open to different approaches, like for example loading the files in a Retool Table component rather than using the Drive Picker itself, but I know our users are familiar with Google's picker interface, making it a little more familiar.

I created a resource that gives me the authentication - but I'm not sure how to actually load the picker itself. Would I need to create a custom component that loads it -- and is that even possible if we are embedding retool within our parent app?

Interested to know if others have done something similar and what the general approach is or if you could point me to some resources/guides.

Overall goal - currently we have retool's file picker to select files from your computer and upload them -- would like users to have the option to select images from their google drive as another option. Thanks in advance!

3 Likes

Following as this is definitely a good to have feature I've been asked several times for

1 Like

Hello @shawnhoffman!

I love the idea, with the gist of the problem being that you want users to be able to see what folders/files are in a google drive and then access them in retool.

I was thinking about making a feature request for this and need to hash out the details of how this would work.

In the meantime there could be a workaround using queries and the Google Drive API to get a list of folders/files and potentially access them. I found this on their docs but we will need to do some more research for file/folder actions and how the permissions will work :sweat_smile:

1 Like

Completely -- they show some examples and I'm sure it's possible with their APIs... just not a pro myself and was hoping somebody else had already proven it out!

2 Likes

Hey there,

having a Retool native integration with the Google Picker API would be super helpful for our use cases as well.

I've recently asked about this here.

After more searching, I've found this thread and it seems like you guys have use cases as well.

@Jack_T did this feature request already make it to the backlog or onto the roadmap?

All the best
Michael

Hi @michael_h,

I had been hoping that the Google Picker component would be getting some attention as I can see how useful that would be given our other integrations with the Gsuite of products.

I just checked the ticket and it seems that it had been moved to the backlog at this time. I will continue to advocate for this feature and will be reaching out to the engineering team to get more details on how this can fit into our roadmap and will continue pass along any updates I get on this feature request.

1 Like