gsheet2dwh_2.py

def gsheet2df(spreadsheet_name, sheet_num):
    scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']
    credentials_path = 'tutorial-sa-b04b423afd77.json'
    
    credentials = sac.from_json_keyfile_name(credentials_path, scope)
    client = gspread.authorize(credentials)
    
    sheet = client.open(spreadsheet_name).get_worksheet(sheet_num).get_all_records()
    df =  pd.DataFrame.from_dict(sheet)
    
    return df.head()