opener = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(CookieJar()))
response = opener.open(spreadsheet_url)
with open('data.csv', 'wb') as f:
    pass
Authenticate to Google Drive and download spreadsheet with Python urllib2/requests