I like to automate tasks, I think every software engineer like that, right? After all thats our job. I wrote the following script for downloading google spreadsheet as csv. Just got it when I was going through my old code base, hopefully it would help someone else too.
To run the script you have to install gdata python module.
You have to run the script like below:
python gdooc.py spread_sheet_id#gid=tab_id
For example check the following screenshot:
And after downloading you will have the csv file in the same directory, currently the document id is being used as name of the csv file, you can change it as you want.
Happy Coding 🙂