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?
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?
Hey David, Did you end up finding a solution to this, I have run into the same issue…
Hey @Michael_Weaver – no solution yet. I ironically reached out to support just now forgetting I had posted this.
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.
No updates I am guessing?
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!