Retrieve the data from Google Forms that are saved to a Google Spreadsheets file

form_data.py

import gspread
from oauth2client.service_account import ServiceAccountCredentials

SCOPE = ['https://spreadsheets.google.com/feeds']
# The key file can be downloaded from Google Developer Console
KEY = 'yourkey.json'

# Authenticate using your key file
credentials = ServiceAccountCredentials.from_json_keyfile_name(KEY, SCOPE)

gc = gspread.authorize(credentials)

# List all available spreadsheets
gs = gc.openall()
print(gs)

# Open a single spreadsheet
gs = gc.open('Your Uber Form')
worksheet = gs.sheet1