Coda's Google Sheets Pack and Google Shared Drive Files

Suggestion Box Bugs
1

Hey Coda (& @Shaina_Torgerson). Thank you for creating so many awesome packs! The Google Sheets by Coda is also great but appears it doesn’t work with Sheets that are located in a Google Shared Drive, only Sheets in a Google My Drive.

So when using the “Sheets” search param on the pack it will only return Sheets in My Drive so it doesn’t appear like you’re able to select a sheet that’s in a Google Shared Drive. I tried pasting the Google Sheet ID directly into the the “Sheets” param but that doesn’t work either.

Is there a way to get the pack to work with a Sheet in a Shared Drive that I’m just not seeing or is this an issue with the pack?

4 Likes
2

Yes, this is needed! We need to operate on files in Shared Drives as nothing in our organization (should) live in individual users’ drives. So these packs are not valuable without this. If we could manually specify the sheet ID (as you can in the pack’s GetSheetValue() formula) versus having to go through the search, this could resolve this issue.