omz:forum

    • Register
    • Login
    • Search
    • Recent
    • Popular

    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

    Pythonista
    3
    3
    2641
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • G3KuXBxkQf
      G3KuXBxkQf last edited by

      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.

      mikael 1 Reply Last reply Reply Quote 0
      • mikael
        mikael @G3KuXBxkQf last edited by

        @G3KuXBxkQf, I used Google to search for ”python read csv” and this came up:

        How to read CSV files in Python

        1 Reply Last reply Reply Quote 0
        • comfortablynick
          comfortablynick last edited by comfortablynick

          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.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Powered by NodeBB Forums | Contributors