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()
gs_data = rows.get('values')
gs_header = gs_data.pop(0)
df = pd.DataFrame(gs_data, columns=gs_header)
print(df)