Skip to main content

In this package you will find functions to deal with google apis. Sheets, Drive, Storage and Slides

Project description


Some functions to make Google APIs more usable.


pip install google-api-support


The contributions are encouraged so the library can keep growing and help more people.

You can also create an issue in order to point other contributors to desired functionalities.

Discord Chat

Functions avaliable

  • Sheets

    • Get pandas.dataframe from Sheets
    • Upload pandas.dataframe to Sheets
    • Retrieve sheet names
    • Add sheets to a spreadsheet
    • Create new spreadsheet
  • Slides

    • Create presentation
    • Get presentation info
    • Get presentation slides
    • Get slide notes
    • Replace text
    • Replace shape with image
    • Replace image
    • Get slide notes
    • Batch replace text
    • Batch replace shapes with images
    • Insert image
    • Duplicate object
    • Delete object
    • Batch delete object
    • Delete text
    • Batch delete text
    • Delete presentation notes
    • Transform object
  • Drive

    • Get file name
    • Move file
    • Delete file
    • Copy file
    • Upload image
    • Create folder
    • List folders in folder
    • Get folder id by name
    • Get folder id by path
    • Download file
  • Storage

    • Upload a file to google storage and get its URL

Steps to use google Sheets API

In order to use Google APIs you will need to authenticate, this steps guide you through the process:

  1. Create a project in

  1. Create google service account. 0. Go to and create a new project. Create a developers project

    1. Create credentials.

      • In this first version, i will explain how to deal with Services accounts, so select "Service account key".
    2. Create a service account.

      • Download the .json file and KEEP IT SAFE.
    3. Now you have your service account created inside your new project.

    4. Copy your "user id" in "Manage service accounts" to use it later.

      • It looks like this one:
    5. Go to your dashboard screen and go to "ENABLE APIS AND SERVICES" to "unlock" the desired API calls. In our example, we will just enable "Google sheets API".

Check the specific credentials documentation file

Credentials documentation

Manually install dependencies

pip install httplib2 oauth2client pandas google-api-python-client google.auth.transport.requests google.oauth2.credentials google_auth_oauthlib.flow

Complete first use example

Example using virtualenv in bash terminal

virtualenv venv pip install google-api-support pip install jupyterlab source venv/Scripts/activate export GOOGLE_APPLICATION_CREDENTIALS=C:/path/to/my/service_account_credentials.json jupyter lab

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

google-api-support-0.1.4.tar.gz (15.3 kB view hashes)

Uploaded source

Built Distribution

google_api_support-0.1.4-py3-none-any.whl (19.3 kB view hashes)

Uploaded py3

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