Can you view a shared Google Drive Folder (via coda table) with the Google Drive Pack

Making Packs
#1

I’m trying to make a table that is a view of all files in a specified Gdrive folder. However, the Gdrive folder is a “Shared” folder across our org.

However, it seems I can only query unshared folders. Advice?

1 Like
#2

Hey David, Did you end up finding a solution to this, I have run into the same issue…

1 Like
#3

Hey @Michael_Weaver – no solution yet. I ironically reached out to support just now forgetting I had posted this.

#4

Ah, damn. I’ve not found a way around it either.
Seems it might just be another item on the list of “some day, if we’re lucky” Coda features.

1 Like
#5

No updates I am guessing?

#6

Hi! We were able to get this to work by doing the following:

1 - Pick a folder that belongs to your Google drive
2 - Click “View Formula” for the folder section of the Sync configuration
- This shows the folder ID (the same one you see in your URL when that folder is open in your browser) Something like “ASDF1234567890”
3 - Open the shared folder
4 - Copy the shared folder ID (For an example https://drive.google.com/drive/folders/ABC123-XYZ999 → ABC123-XYZ999)
5 - Paste it into the Folder formula - don’t forget the quotes!
6 - Sync Now

Hope that does it for you!

1 Like