Easily and efficiently manage a Google Sheet
Project description
gsheet-api
Easily and efficiently manage a Google Sheet.
Notes
- Credentials required are the Google Service account json file
- Sheet must be shared with edit access to the
client_email
found the the service account - Credentials can be entered as a dictionary or a file path to a json file, both will work.
Usage Example
gsheet = GSheetAPI(..) # initialize the class
gsheet.sheet_to_df(..) # import data from the sheet to a Pandas DataFrame
gsheet.change_gsheet(..) # switch to a new Google Sheet to work off of
gsheet.get_cell(..) # get the contents of a single cell
gsheet.change_tab(..) # switch to a new tab in the current working Google Sheet
gsheet.set_cell(..) # set the value of a single cell
gsheet.df_to_sheet(..) # export a Pandas DataFrame to the current working sheet
gsheet.timestamp_to_cell(..) # export a timestamp to a single cell in the sheet
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
gsheet_api-0.1.2.tar.gz
(3.5 kB
view hashes)
Built Distribution
Close
Hashes for gsheet_api-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bc783e20155c173af947185021569ea9f69ba178235c299d182c8f9c727a4d4f |
|
MD5 | 58c086e50b248938ce93cb1b5a65df3c |
|
BLAKE2b-256 | ec97f12804acbab684518f974238fb861ded5c4950a1bcb707d02632c79c9943 |