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.

Please follow this link https://stackoverflow.com/questions/38949318/google-sheets-api-returns-the-caller-does-not-have-permission-when-using-serve — LetsCMS Pvt Ltd, Oct 16 '17 at 10:57

score 2 · Answer 1 · edited May 23 '17 at 12:18

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.

Balaji · Answer 2 · 2020-08-28T17:20:58.773

2

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

edited Aug 28 '20 at 17:20

answered Aug 25 '20 at 09:32

Balaji

9,657
5
47
47

score 0 · Answer 3 · answered Mar 15 '17 at 10:24

0

Not a lot to go on here, have you checked that the user that you are authenticated as must have permission to the file. So check in the File->Share->Advanced and check if the Sharing settings have the email that you are logged in to in your application.

answered Mar 15 '17 at 10:24

JonasJR

76
9

1

Yup. It's there. – Nazar Abubaker Mar 15 '17 at 11:30

score 0 · Answer 4 · answered Jul 21 '20 at 11:32

I encountered the same problem and it turned out that I was trying to write to the sheet by using readonly scope

SCOPE_READ = ['https://www.googleapis.com/auth/spreadsheets.readonly']

Actually I need Read+Write scope (permissions) to write to the spreadsheet:

SCOPE_WRITE = ['https://www.googleapis.com/auth/spreadsheets']

When you will be prompted by Google Accounts prompt for authorizing the app to access the sheets, you can see there what permissions your script has requested. Make sure they are the right ones.

score 0 · Answer 5 · answered Oct 31 '22 at 10:20

i face the same issue

i just go https://console.developers.google.com then library->google sheet->enable and Enabled the Google Sheet API

then i have open google sheet and follow below steps:

Extension->Apps Script
Click on Deploy button and select Manage Deployments or new Deployments
Edit Configuration detail and give authorize rights for add, update, delete, view
Click on Deploy

this is working for me.

Error 403 on Google Sheets API

5 Answers5

Linked