1

My task is to use Google Sheets API method spreadsheets.values.append the easiest way possible.

This method requires OAuth 2.0, but can I make some kind of persistent token just for myself if I'm not gonna publish this app? Or, is this any "proxy-api" that allows to use that method just with their persistent key (like API key in case of Google Sheets API)?

BanterFace
  • 21
  • 3

1 Answers1

0

You should be able to use a Service Account authorized with an API Key, NOT using OAuth. The API key is persistent, so you don't need to refresh it.

In using this method, the service account owns the Sheets Doc, so you'll also need Drive API access to give permissions/ownership to someone else, assuming you want to do that.

John B
  • 20,062
  • 35
  • 120
  • 170
  • API key is not enough for "spreadsheets.values.append". You need OAuth 2.0 if you're using this method through API. – BanterFace Aug 24 '19 at 13:01
  • @BanterFace Why would you need OAuth for that method in particular? I don't see anything in the documentation that says that: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append If you're talking about Authorization Scopes mentioned in the documentation, I'm using the BatchUpdate method with an API Key and it works just fine. – John B Aug 26 '19 at 20:44