Welcome!
This is the community forum for my apps Pythonista and Editorial.
For individual support questions, you can also send an email. If you have a very short question or just want to say hello — I'm @olemoritz on Twitter.
Import / Read Google Sheets document
-
How can I open or read a Google Sheets document.
I do not mind coding so that I download the sheet as a csv and then read and reprocess the downloaded contents.
I only need the information from google sheets as read only.
The google sheet contains details such as Member Number and Name.
My app would ideally
Read into a dictionary or store locally a csv file downloaded from Gdrive.
Present a screen to allow enter of member number.
Display member name. -
@G3KuXBxkQf, I used Google to search for ”python read csv” and this came up:
-
I would use the Google Sheets Python API. They have a QuickStart example. I haven't done a script for Sheets in Pythonista, but I have done one for Gmail and it worked fine.