I have a set of documents stored in Google Drive that I am trying to read into dataframes in a Google Colab notebook but am receiving a SpreadsheetNotFound error.
I am following the steps outlined here and here and am successful in mounting my Google drive. However, when I attempt to open a file connection, e.g.
gc = gspread.authorize(creds)
df = gc.open('/content/drive/MyDrive/folder/worksheet.gsheets')
I receive an error saying that the spreadsheet is not found (the file appears in the list when I run !ls /content/drive/MyDrive/folder).
Is there a specific way that I should be referring to the document or drive that I'm missing?
Thank you!