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.3.tar.gz
(3.6 kB
view hashes)
Built Distribution
Close
Hashes for gsheet_api-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | db06036455d99569cc4ee5eca63961e0e7015c778c049cf0e118d1bea8ea405d |
|
MD5 | b7360583f02229ec03ad8d6e0d05bbbc |
|
BLAKE2b-256 | a3a9b28a3ac3de76f308ef58f0f137245df1b0ac86e8a662e0281cb0985302a0 |