Accessing Google Sheets Api with Python

Question

I'm currently trying to make updates to google sheets via python and I'm running into some issues with permissions.

I've been following the instructions from this Twilio guide:https://www.twilio.com/blog/2017/02/an-easy-way-to-read-and-write-to-a-google-spreadsheet-in-python.html

I'm doing all of this in Jupyter, and I did save the JSON file to the proper code directory. I had no problems defining scope, creds and client.

import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope = ['https://spreadsheets.google.com/feeds']
creds = ServiceAccountCredentials.from_json_keyfile_name('client_id.json', scope)
client = gspread.authorize(creds)

sheet = client.open("MixIQ Tracker").sheet1

I've followed all of the steps to link the two, but I am getting this API Error with the last line.

APIError: {
"error": {
  "errors": [{
      "domain": "global",
      "reason": "insufficientPermissions",
      "message": "Insufficient Permission: Request had insufficient authentication scopes."
    }],
  "code": 403,
  "message": "Insufficient Permission: Request had insufficient authentication scopes."
 }
}

I'm not exactly sure how to resolve this. Any direction would be greatly appreciated!

have you tried this: https://stackoverflow.com/questions/38534801/google-spreadsheet-api-request-had-insufficient-authentication-scopes — Mason Caiby, May 10 '19 at 22:31

score 19 · Accepted Answer · edited Nov 28 '19 at 21:58

19

I believe google drive API endpoint needs to be included in your scope. I was writing data from Mailchimp API to Google Sheet.

Check this out: https://www.youtube.com/watch?v=7I2s81TsCnc> It was helpful for me.

scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']

edited Nov 28 '19 at 21:58

Areza

5,623
7
48
79

answered May 13 '19 at 18:34

Michael deVry

206
1
3

1

Updating that scope and enabling google sheet API helped me – EntryLevelR May 25 '19 at 18:06
Updating scope with the second term helped me fix this as well – guyts Jul 26 '19 at 21:01

score 3 · Answer 2 · answered May 13 '19 at 07:53

If you look at the google API scopes documentation, the scope url you are using is not referenced anywhere. This may be the problem. Try changing the scope url to https://www.googleapis.com/auth/spreadsheets.

Also, make sure the spreadsheet API is correctly enabled in your project in the google developer console.

Alternatively, you could try the Sheetfu library (I'm the author), that handles the scopes for you.

score 2 · Answer 3 · answered Jul 22 '19 at 05:51

Use this as your scope:

scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']

Before calling the "ServiceAccountCredentials"

You will need to enable the Google Drive API in the "console.cloud.google" as well as the sheets API.

score 0 · Answer 4 · answered Dec 31 '19 at 11:26

0

You only need this scope

scope = ["https://www.googleapis.com/auth/drive"]

answered Dec 31 '19 at 11:26

Jack

1
2

Accessing Google Sheets Api with Python

4 Answers4

Linked