kouyou.google.sheets module¶
This module make use of Google Sheets API.
-
kouyou.google.sheets.connect_to_google_sheet()¶ Create connection with google spreadsheets api.
- Returns
instance os google api connection
- Return type
gspread.client.Client
-
kouyou.google.sheets.get_workbook_as_df(file_name)¶ Get shared spreadsheet from google drive.
- Parameters
file_name (str) – File name to search
- Returns
dict from spreadsheet file (pandas.core.frame.DataFrame)
- Return type
dict
-
kouyou.google.sheets.send_df_to_gspread(workbook_name, folder_id, df_list)¶ Upload a file as a google spreadsheet direct to google drive.
- Parameters
workbook_name (str) – File name, without extension
folder_id (str) – Google Drive Folder ID
df_list (list) – List of pandas.core.frame.DataFrame with the datas