So I have Python basically connected to google sheets at the moment. It can access the first sheet and read and write data:
sheet = client.open("Remake").sheet1
I can access sheet 1 inside the overarching spreadsheet, but I cannot access the second sheet (sheet2) by just changing it to:
sheet = client.open("Remake").sheet2
To explain this, it is because Google Spreadsheet only implemented sheet1 to let you retrieve the first sheet in your spreadsheet as a shortcut. So if you want to retrieve other sheets, you need to use other methods like:
wks = gc.open("doc_name").get_worksheet(index)
or
wks = gc.open("doc_name").worksheet(title)
Related infos:
In my case this code working (python 3.7)
Spreadsheet = client.open("sheet_name").worksheet("sheet_title")
