Using Google Spreadsheets as a Database in the Cloud




About this tutorial:

Video duration: 6:2
Watch Jeffrey Scudder demonstrate his GData Python Client Library extension that makes it easy to use Google Spreadsheets as a database in the cloud.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

43 thoughts on “Using Google Spreadsheets as a Database in the Cloud

    TheNanoWeb

    (May 18, 2018 - 4:55 am)

    If you are not very technical this someone can help you on Fiverr. I used this quy, link is here
    http://bit.ly/2E4yhqg

    Ridhwanul Haque

    (May 18, 2018 - 4:55 am)

    whats in the client file?

    LachyWarner

    (May 18, 2018 - 4:55 am)

    This video was gay lol

    impactime22

    (May 18, 2018 - 4:55 am)

    hello Google Developers ! thanks for this great insight!
    i have a question.
    do you know how to use google spreadsheet as a video metadata cataloger? Having the ability to timestamp video footage from a hard drive and save the metadata in google spreadsheets online to share with easily customize searches for different clips of footage? it would be similar to CatDV. 
    thanks!

    TOMYSSHADOW

    (May 18, 2018 - 4:55 am)

    I'm really confused and wondering if anyone can help me out.

    I have a game entirely written in Javascript, and my server will not allow me to use PHP, Python etc. as such, I need to do this solely in Javascript. Anyhow, my game is written in Javascript, and I want to add a highscore table. What I plan to do is have a spreadsheet hosted on my Google account. Then, when the user scores, I want to update the spreadsheet – which is on my account – with their score.

    I don't actually want to put my username and password at risk, so from my understanding I must use OAuth. But I don't understand how to use it in this case. I don't want to log into another user's account. I just want my script to temporarily be able to modify my spreadsheet, using some sort of key deal. And I only want that key to be able to modify that spreadsheet, nothing else. Naturally, I want the spreadsheet to be private, because I don't want people overriding values in the spreadsheet with their own, fake, made up scores.

    I know there are APIs, such as this one, for that purpose, but videos such as this are focused more on letting other users edit their spreadsheets with the API, which is not what I want. And naturally, I want to be able to EDIT the sheet, not just view it.

    I'm lost – where on earth do I start?

    Arthur Penta

    (May 18, 2018 - 4:55 am)

    I'm curious to know which program you used to create this instructional video?

    Michael Maguire

    (May 18, 2018 - 4:55 am)

    There's a book on this here:
    https://leanpub.com/googlespreadsheetprogramming
    There's quite a bit of free content that includes Google Apps Script/Excel VBA examples side-by-side

    John Fenley

    (May 18, 2018 - 4:55 am)

    This is super great. So much easier than the gdata spreadsheets service.
    for anyone wondering, i think demo just calls:
    client = gdata.spreadsheet.text_db.DatabaseClient()
    client.SetCredentials('<username>','<password>')

    LiquidSequence

    (May 18, 2018 - 4:55 am)

    We're extensively using Google Spreadsheets to poplulate/map data to databases (import) as well as using Spreadsheets to expose/export data.
    See slideshare LiquidSequence – creating-a-banking-application-using-google-docs-spreadsheets

    Almir Bispo

    (May 18, 2018 - 4:55 am)

    Hello! I develop the CSV Comp Framework.Is a system to manipulate CSV files (tables) in de cloud (with CQL) (something like sql).I'll could like to use in the Google Cloud,but needs Pascal CGI in Server.In the Server run Pascal.Watch my channel.

    MrBeardo

    (May 18, 2018 - 4:55 am)

    I dislike Google Docs, it is horrible and disorganised, so many problems with it, I'd rather stick to a paid Suite

    Alex Miller

    (May 18, 2018 - 4:55 am)

    Cool, I think Google should make this type of use into a complete product, something like Ragic, not just simple form builder like Google Form or this.

    Rickson Menezes

    (May 18, 2018 - 4:55 am)

    but It can only be used for Python? Or can it work for PHP etc?

    Conan Li

    (May 18, 2018 - 4:55 am)

    how did you type so fast

    Mat

    (May 18, 2018 - 4:55 am)

    title should be "using google spreadsheet for coders only"

    Wa33ab1

    (May 18, 2018 - 4:55 am)

    I'm having trouble at the part where you do the record= db.AddRecord({'Knight':,'Lancelot'}) It gives me the error: Please wait…' , 'reason': 'Bad Request'. Which is bullshit because that's what it says to do in table_db.

    In addition. table.db[0].GetTables(name='Knight') returns an empty list which is also bullshit because I clearly made the table in the google spreadsheet.

    I would really like someone to help me with this, please?

    Will Nicholson

    (May 18, 2018 - 4:55 am)

    This is the step he skipped for login…

    Instead of doing:
    client = demo.Client()

    you can just do:
    client = gdata.spreadsheet.text_db.DatabaseClient(username='jo@example.com', password='12345')

    Worked like a champ for me.

    kelekokerupuk

    (May 18, 2018 - 4:55 am)

    Your Video Is Very Useful Sharing Watch Jeffrey Scudder demonstrate his GData Python Client Library extension that makes it easy to use Google Spreadsheets as a database in the cloud.

    Naveen Venkat

    (May 18, 2018 - 4:55 am)

    is there a similar Google Spreadsheet API in java?

    Sylvan012

    (May 18, 2018 - 4:55 am)

    I have no idea what Python is. All I want to do is pull specific cells of data from a spreadsheet onto a Web page. HOW DO I DO THIS? Is there a simple tutorial that just says "type this for your jQuery script to pull 'x' data from your spreadsheet"?!

    bikingviking

    (May 18, 2018 - 4:55 am)

    If you want to see more code for this, do a search for Andreas Kahler's blog (i can't post the url here). He has a great example which includes the authentication code that is not shown here.

    gachola2 gaginho

    (May 18, 2018 - 4:55 am)

    nhbn

    bvllets

    (May 18, 2018 - 4:55 am)

    Dude probably gets mad pussy

    woodygar

    (May 18, 2018 - 4:55 am)

    Can someone tell me whats in the demo module please

    bikingviking

    (May 18, 2018 - 4:55 am)

    This tutorial is useless without showing what is in the demo module. You'd think the geniuses at Google would figure that out!

    Carlos Jorge

    (May 18, 2018 - 4:55 am)

    @luinva hahahahahha

    Alex Toussieh

    (May 18, 2018 - 4:55 am)

    The guy is too advanced for me. He goes straight into coding and doing geeky things I have no idea about, and I don't know how to even get started. Actually when I open the p/gdata etc. page I get it slightly different because I don't have all his documents saved up there and he just jumps into the next thing without explaining where I should click to open up his database thingy and it's more… encouraging… than it is teaching… but thanks!

    luinva

    (May 18, 2018 - 4:55 am)

    My favorite is when he pauses to swallow :40
    I know, I'm just being stupid. I love this.

    Melinda Traynor

    (May 18, 2018 - 4:55 am)

    Someone kill me now…I just want a database to track training in the cloud so my clients can access it. I c
    ould NEVER do this mess.

    faisal raza

    (May 18, 2018 - 4:55 am)

    import demo

    this is not working…?

    Joseph Vaughan

    (May 18, 2018 - 4:55 am)

    It would be really nice if you could post the contents of demo, so that we could understand what demo.Client() does

    Luis Carlos Ramírez Rodríguez

    (May 18, 2018 - 4:55 am)

    @ashlovemira if you can get python to run on the iPhone :S

    Otherwise youll have to use REST services to call the API from your server, which in turn fetches data from Gdocs.

    SuperAmok Ash

    (May 18, 2018 - 4:55 am)

    ca n this database link the iphone?

    thebarak

    (May 18, 2018 - 4:55 am)

    Yikes, a green on black command line window and mentions of knights. It's like 1980 all over again. I hope normal people will be able to use Google Spreadsheets as full-blown databases one day soon. I do, but mine are really just Google Spreadsheets with data in them, and everything in your command window looks like Martian to me. Luckily, Google takes care of business and I don't seem to need to do that.

    Michael Kariv

    (May 18, 2018 - 4:55 am)

    This is a very useful feature. My silver light Gantt editor written 2 years ago works with gdata on the back end using all that complexity that Jeff hides with text db.
    Like krislyttle I would like to see SQL features – especially JOIN between "tables" ("worksheets"). Still, current state is very appreciated. Thanks Jeff

    Drew LeSueur

    (May 18, 2018 - 4:55 am)

    can we please see the demo class?

    Mikolaj Dawidowski

    (May 18, 2018 - 4:55 am)

    man, why oh why didn't you show us HOW TO LOGIN.
    Now I have to snoop around and try to figure what the hell did you do in the demo object…
    Sheeet

    kelmer carvalho

    (May 18, 2018 - 4:55 am)

    Really cool !!! this can be really useful, a free simple database on the web.

    greekmonstervt91

    (May 18, 2018 - 4:55 am)

    this is so hard..i'm confused…what the hell is he talking about…

    rrrrr

    (May 18, 2018 - 4:55 am)

    Why don't you add a rudimentary database offering to join Google docs and spreadsheets?

    utemkes

    (May 18, 2018 - 4:55 am)

    3rd

    James Throgmorton

    (May 18, 2018 - 4:55 am)

    How about giving him an "Awesome" for containing his enthusiasm, as he presented an amazing new api. I would have geeked out and crapped my pants!

    Josh

    (May 18, 2018 - 4:55 am)

    First.

Leave a Reply

Your email address will not be published. Required fields are marked *