Comment by slouch | Hacker News Reader

Top New Best Ask Show Jobs

Comment by slouch | Hacker News Reader

Parent Full thread

Hi, I'm not OP, but have built a similar thing. Are you suggesting to use https://www.googleapis.com/auth/drive.file instead of https://www.googleapis.com/auth/spreadsheets?

Yeah. It gives read/write access to one file. The ideal for this use case would be read only access for one file. I think read/write access for one file follows the principle of least privilege better than read access for all files. https://developers.google.com/drive/api/v2/about-auth https://en.wikipedia.org/wiki/Principle_of_least_privilege

I've found that drive.file doesn't work so well with existing Sheets https://stackoverflow.com/questions/61778469/append-rows-to-...

Reply on news.ycombinator.com