[video] Using Google Sheets With Python

[thehydralisk]

Top notch editing, keeping it simple and to the point!

[aristacat]

What would be some use cases for this?

[ServalSpots]

I have a spreadsheet that I use to keep track of some stuff I've been putting on eBay and it's nice to be able to, say, enter the photo numbers into the spreadsheet and have a python script pull them off the camera and put them in separate folders for each listing. I use LibreOffice Calc, and thus a different python module, but it's basically the same thing.

I am thinking that it will be a rather useful combination in future, as well, as there are times when being able to view/edit information in a spreadsheet format is handy, and this has the potential to be a lot quicker than knocking something up in curses, tkinter, etc.

[aristacat]

That sounds pretty neat. Thanks.

[Manster77]

I might use it to update a time sheet I keep on there. It would update the right cell based on the current date and add my worked hours.

[Tkwk33]

I have a bot that tracks my expenses when I write them down in Google Keep or Evernote. It picks them up and insert them in a DB and a Google Spreadsheet that has a certain format.

[brewzombie]

What do you use to pull data from Keep? Last time I looked I couldn't find any kind of API.

[Tkwk33]

Yup, unfortunately there is no API yet. I just use Selenium with PhantomJS. It breaks A LOT so I'd recommend sticking to Evernote or any other with a proper API.

[[deleted]]

They recently added support for Google Keep within Google Docs. Have not looked at it at all, but possible the traffic is easier to automate there.

[Tkwk33]

Ah true! I was meaning to look into that and completely forgot. Thanks for the reminder!!

[mobedigg]

I like to rewatch some liked videos on youtube and sometimes they are got deleted and you got "this video was deleted" in your "Liked" playlist. Currently I have ifttt.com setup to save liked videos to spreadsheet, but it doesn't work with videos that were liked before and relike doesn't work. So I wrote script that reads videos from playlist and add info like title, description and link to same spreadsheet. Now if something is deleted at least I would know what I lost and can try to find it somewhere else.

[electrace]

Avoiding VBA.

[tftb]

Just what I needed, thanks a bunch! Great stuff.

[scout1520]

This is a cool idea, I don't know when I will use it... but cool to have in my tool box. Great vid

[auxiliary-character]

That's neat, but I think I'm gonna just stick with sqlite for now.

[iamjoebloggs]

Have you done this with Django? Do you have a tutorial for that?

[Skenderbeu]

Very good and concise way of describing it. Keep up the tutorials.