As the name implies, it means that your Python IDE hasn't found the spreadsheet you want to connect to. If you have followed all the instructions above (connect to your creds.json credentials + share the spreadsheet with your Google Developer Service email (not your personal email), it could be that there's some form of lag / caching which prevents the API to find the spreadsheet by name. In that case, a quick fix is to connect using the ID of the spreadsheet instead of its name (which also comes with a bonus = you can rename your spreadsheet at a later stage without breaking the connection). In order to connect via the spreadsheet ID (which you'll find in the URL of the spreadsheet after /d/), use sh = gc.open_by_key("your spreadsheet ID").sheet 1 instead of gc.open("your spreadsheet name").sheet 1. It tested this fix and it worked like a (py)charm!