Google Sheets API V4 403 Error

Question

I am pulling data from a spreadsheet via Google Sheets V4 REST API and Ruby:

https://sheets.googleapis.com/v4/spreadsheets/MASTER_SPREADSHEET_ID/values/A:GH?key=GOOGLE_SERVER_KEY

I had this working before, until the spreadsheet was removed and recreated. Now I am getting a 403 error with the new spreadsheet.

APIs:

The Docs state that you can just append the url with an API Key, am I interpreting this wrong?

Does the credentials the API call is using have access to the new spreadsheet? — Sam Berlin, Aug 18 '16 at 11:26
Well thats where I think I am confused a little bit. It is a spreadsheet shared with the account with the credentials. I have also created a new spreadsheet with the credentialed account. Can't get either to work. — AthleteInAction, Aug 18 '16 at 11:28
Is there something else I need to do to give access to the spreadsheet? — AthleteInAction, Aug 18 '16 at 11:28
i faced same issue issue cleared https://stackoverflow.com/a/63575941/11624647 — Balaji, Aug 25 '20 at 09:33

score 2 · Answer 1 · answered May 07 '21 at 06:50

I faced the same problem and solved it. The problem was the public scope of the Google sheet you were trying to access.

Enter the spreadsheets you want to access.
Click the Share button.
Click View Link.

If you set the public view of the spreadsheets you want to access to the link view, all users who want to access the link will be able to access it.

score 0 · Answer 2 · answered Aug 19 '16 at 09:54

First, make sure you have a permission to call this spreadsheet. You can also try to change the status of this spreadsheet to public and checked if you can access it now. This 403 error is usually caused by incorrect or missed some configuration in Authorizing Requests. For more information, if you authorizing requests with OAuth 2.0, make sure you use proper scope with it.

score 0 · Answer 3 · answered Apr 24 '20 at 19:25

0

Following up on what KENdi said, you will also get a

The remote server returned an error: (403) Forbidden.

If the API for the service you need is not enabled.

answered Apr 24 '20 at 19:25

Citroen

11
1

Google Sheets API V4 403 Error

3 Answers3

Linked