[dmdsoftware]

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.