gspread_pandas_quickstart_read_write_google_sheet_dataframe.py

1import pandas as pd
2from gspread_pandas import Spread, Client
3
4# Replace 'Example Spreadsheet' with your spreadsheet name or ID
5# and 'Sheet1' with your worksheet name
6spread = Spread('Example Spreadsheet')
7
8# Pull data from the first sheet into a DataFrame
9df = spread.sheet_to_df()
10print(df.head())
11
12# Create a sample DataFrame to push
13new_df = pd.DataFrame({'col1': [1, 2], 'col2': [3, 4]})
14
15# Push the DataFrame to a specific sheet (it will be created if it doesn't exist)
16spread.df_to_sheet(new_df, index=False, sheet='Sheet2', replace=True)