spreadsheet_url = (
    'https://docs.google.com/spreadsheets/d/***SHARED-SECRET***/export?format=csv'
    )
opener = urllib.request.build_opener(urllib.request.HTTPCookieProcessor(CookieJar()))
Authenticate to Google Drive and download spreadsheet with Python urllib2/requests