import gsheet to dataframe.py

from Google import Create_Service
import pandas as pd

CLIENT_SECRET_FILE = 'client_secret.json'
API_SERVICE_NAME = 'sheets'
API_VERSION = 'v4'
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']
gsheetId = '<Google Sheet Id>'

s = Create_Service(CLIENT_SECRET_FILE, API_SERVICE_NAME, API_VERSION, SCOPES)
gs = s.spreadsheets()
rows = gs.values().get(spreadsheetId=gsheetId,range='Test1').execute()
data = rows.get('values')
df = pd.DataFrame(data)
print(df)

I'd suggest this code totally screws up the data by interpreting header as first row of data. Instead i'd do something along these lines:
https://gist.github.com/mick-d/d2dbb35151198ef9d6db11cf422f9c1b