Accessing Google Spreadsheet Data using Python

csharp

Well-known member
  • Nov 19, 2016
    1,263
    781
    113
    Melbourne

    If you’re building a simple internal app and you might probably be thinking that ‘I’m going to need a database now right!’. Well, Not so fast!



    As you all are familiar with importing, exporting and manipulating comma separate files (CSV) using Python, Hereby in this article I’m going to show you the step-by-step guide to access Google Spreadsheets on the cloud using Python.
    As the very first thing, go to Google API Manager by simply googling it and go to https://console.developers.google.com/
    1*Izo9A50RHKjXGsPO-x0Hxw.png

    https://console.developers.google.com/
    To kick things off first create a new project.
    1*vKGuojn7KZV7HAvPY95_DA.png

    Figure 1.0: Creating a new Project
    I’ll name my project as ‘Telemedicine’ since we will be working with a spreadsheet that includes all the tweets related to Telemedicine hashtags which I extracted earlier (Click here to see how I extracted tweets using hashtags). Define a suitable project name according to your dataset on the cloud then click CREATE to initiate the project. (You don’t have to worry about the Location* below the project name)

    Read full article here