Skip to main content

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)

Uploaded Source

Built Distribution

gsheet_api-0.1.2-py3-none-any.whl (5.0 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page