Error 403 on Google Sheets API

Question

The URL

https://sheets.googleapis.com/v4/spreadsheets/[ID_OF_SPREADSHEET]?key=[MY_API_KEY]

What I get

   {
      "error": {
        "code": 403,
        "message": "The caller does not have permission",
        "status": "PERMISSION_DENIED"
      }
    }

At the moment, I have no Key Restriction on my API Key for the sake of testing.

I've had a look at a past question that's been popular but no luck.

Answer 1

i faced same issue in my electron app

i just did

https://console.developers.google.com/

then

choose library->google sheet->enable 

thats it started working to me

Answer 2

This is similar to this 403 error in Drive API wherein you have insufficient permission. By that, you need authentication and authorization using OAuth. There are quickstart guides which has implementation in JavaScript, Python,etc.

To prove this, go to auth playground and get the permissions for 'Google Sheets API v4'. Follow the steps and place your URI request in Step 3. You shouldn't have problems performing operations after that.

Check this SO thread for additional reference on how to use OAuth Playground.

Answer 3

This is similar to this 403 error in Drive API wherein you have insufficient permission. By that, you need authentication and authorization using OAuth. There are quickstart guides which has implementation in JavaScript, Python,etc.

To prove this, go to auth playground and get the permissions for 'Google Sheets API v4'. Follow the steps and place your URI request in Step 3. You shouldn't have problems performing operations after that.

Check this SO thread for additional reference on how to use OAuth Playground.