Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential

google-sheets-api
Rana Ghosh picture Rana Ghosh · Oct 3, 2017 · Viewed 30.6k times · Source

I am trying to update Google sheet values.

"Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential."

I want to do this using API key not outh 2.0

Can anyone have any suggestions.

Answer

noogui picture noogui · Oct 4, 2017

Not possible. You need to use the OAuth login as indicated here in spreadsheets.values.batchUpdate:

You can see on the authorization part that it uses OAuth scopes, therefore it follows that it uses OAuth not API KEY:

Authorization

Requires one of the following OAuth scopes:

https://www.googleapis.com/auth/drive
https://www.googleapis.com/auth/drive.file
https://www.googleapis.com/auth/spreadsheets

Related questions

How can I access Google Sheet spreadsheets only with Javascript?

I want to access Google Spreadsheets using JavaScript only (no .NET, C#, Java, etc.) I came here and was shocked to know that there is NO API for JavaScript to access Google Sheets. Please tell me how to access (CREATE/…

Read More
Accessing Google Spreadsheets with C# using Google Data API

I'm having some information in Google Spreadsheets as a single sheet. Is there any way by which I can read this information from .NET by providing the google credentials and spreadsheet address. Is it possible using Google Data APIs. Ultimately …

Read More
How do I access (read, write) Google Sheets spreadsheets with Python?

I am wondering if you can point me to an example of reading/writing to/from a google doc/spreadsheet using python. I did look at google docs API here https://developers.google.com/google-apps/spreadsheets/ but not sure if …

Read More