opener = build_opener(HTTPCookieProcessor(CookieJar()))
resp = opener.open(
    'https://docs.google.com/spreadsheet/ccc?key=0ArM5yzzCw9IZdEdLWlpHT1FCcUpYQ2RjWmZYWmNwbXc&output=csv'
    )
data = resp.read()
Download google docs public spreadsheet to csv with python