It would appear that the broad scope https://www.googleapis.com/auth/spreadsheets needed is a real show stopper for the use of the library in projects that we might wish to publish publicly. Google has been quite unequivocal about not allowing my app to have full access to users' sheets beyond the Active Spreadsheet. and have suggested I have to make do with https://www.googleapis.com/auth/spreadsheets.currentonly and https://www.googleapis.com/auth/drive.file scopes.
I am hitting a brick wall here with the Sheets.Spreadsheets.get function that doesn't work at all with the narrow scope. I have gone as far as taking the library local and refactoring it with getActiveSpreadsheet() and replacing range calls. the batchUpdate will just not budge and work with the narrow scope regardless of what I try.
Is there any way around this without having to use the broad scope?
It would appear that the broad scope
https://www.googleapis.com/auth/spreadsheetsneeded is a real show stopper for the use of the library in projects that we might wish to publish publicly. Google has been quite unequivocal about not allowing my app to have full access to users' sheets beyond the Active Spreadsheet. and have suggested I have to make do withhttps://www.googleapis.com/auth/spreadsheets.currentonlyandhttps://www.googleapis.com/auth/drive.filescopes.I am hitting a brick wall here with the
Sheets.Spreadsheets.getfunction that doesn't work at all with the narrow scope. I have gone as far as taking the library local and refactoring it with getActiveSpreadsheet() and replacing range calls. the batchUpdate will just not budge and work with the narrow scope regardless of what I try.Is there any way around this without having to use the broad scope?