Google Drive / FilePicker

Hi Retoolers.

I have a few use cases where I have lists of things, and I want a field which is a link to a document on Google Drive. I figure basically this needs (a) to build the connection to the Google Drive API, (b) provide some kind of UI (which would need to be able to navigate a directory structure, and ( c) return the url / id of the relevant drive object. Possibly using something like FilePicker, which I’ve just found whilst searching on this topic (example here, maybe). Bit tricky. Has anyone done anything like this?

Currently I’m cheating, I send all the files I need to a single list in ‘ClickUp’ which has a really simple api, and can then select a ClickUp TaskId, but that means storing docs in ClickUp which is not ideal either.

Thanks!