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
Recent Comments