[ashlar]

Edit: Am I correct in assuming that the spreadsheet file needs to be at root level on Drive?

No, I don't believe so. The sheets API ignores folders and will list all spreadsheets across the account.

Huh... ok. I was actually worried it wouldn't have been ok at the root level (where it's easier to place for my setup). Thanks!