gspread.exceptions.SpreadsheetNotFound

google-api gspread
TestIsFun picture TestIsFun · Jun 2, 2016 · Viewed 10.1k times · Source

I am writing a python(ver 3) script to access google doc using gspread. 

  1)  import gspread
  2)  from oauth2client.service_account import ServiceAccountCredentials
  3)  scope = ['https://spreadsheets.google.com/feeds']
  4)  credentials = ServiceAccountCredentials.from_json_keyfile_name(r'/path/to/jason/file/xxxxxx.json',scope)
  5)  gc = gspread.authorize(credentials)
  6)  wks = gc.open("test").sheet1

test is a google sheet which seems to be opened and read fine but if I try to read from a Office excel file it gives me error.here is what they look: enter image description here

The folder which test and mtg are under is shared with the email I got in json file.Also both files were shared with that email.

Tried:

wks = gc.open("mtg.xls").sheet1

and

wks = gc.open("mtg.xls").<NameOfFirstSheet>

and 

wks = gc.open("mtg").<NameOfFirstSheet>

error:

/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/gspread/client.py", line 152, in open raise SpreadsheetNotFound gspread.exceptions.SpreadsheetNotFound

Answer

ishandutta2007 picture ishandutta2007 · Nov 6, 2018

I was getting this as I had missed step 4 here

Go to your spreadsheet and share it with a client_email from the step above. Otherwise you’ll get a SpreadsheetNotFound exception when trying to access this spreadsheet with gspread.

Related questions

Is there a link to the "latest" jQuery library on Google APIs?

I use the following for a jQuery link in my <script> tags: http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.js Is there a link to the "latest" version? Something like the following (which doesn't work): http://ajax.…

Read More
Access-Control-Allow-Origin error sending a jQuery Post to Google API's

I read a lot for the 'Access-Control-Allow-Origin' error, but I don't understand what I have to fix :( I'm playing with Google Moderator API, but when I try to add new serie I receive: XMLHttpRequest cannot load https://www.googleapis.com/…

Read More
Alternative to google finance api

I wanted to use Google Finance API to get stock data about the company but this API is deprecated since 2011/26/05. What do you use as free API to get stock data in real time?

Read More