Loop through Google Spreadsheet with Python

Create a simple spreadsheet with Google Drive 

Publish the spreadsheet

(Example: https://docs.google.com/spreadsheet/pub?key=0BBZ40Xdv4Me8dEotdGVVS1dLR05KVjZMS3VpMXozSEE&output=html)

Download BeautifulSoup for Python

Put BeautifulSoup.py in your scripts folder

Start the Python terminal

Command:

import urllib2
from BeautifulSoup import BeautifulSoup
url = urllib2.urlopen("https://docs.google.com/spreadsheet/pub?key=0BBZ40Xdv4Me8dEotdGVVS1dLR05KVjZMS3VpMXozSEE&output=html")
content = BeautifulSoup(url)
items = content.findAll('td',{ 'class' : 's1'})
for item in items:
   print item.string