In this package you will find functions to deal with google apis. Sheets, Drive and Slides
Project description
google-api-support
Some functions to make Google APIs more usable.
Functions avaliable
- Sheets
- Get pandas.dataframe from Sheets
- Upload pandas.dataframe to Sheets
- Retrieve sheet names
- 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
Install
'''pip install google-api-support'''
You might need to install manually:
'''pip install google-api-python-client httplib2 oauth2client pandas'''
Steps to use google Sheets API
In order to use Google APIs you will need to authenticate, this steps guide you through the process:
- Create a project in console.developers.google.com
https://console.developers.google.com
-
Create google service account. 0. Go to https://console.developers.google.com/projectselector/apis/credentials and create a new project.
-
Create credentials.
- In this first version, i will explain how to deal with Services accounts, so select "Service account key".
-
Create a service account.
- Download the .json file and KEEP IT SAFE.
-
Now you have your service account created inside your new project.
-
Copy your "user id" in "Manage service accounts" to use it later.
- It looks like this one: "first-service-account@example-id-175820.iam.gserviceaccount.com"
-
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".
-
Save credentials file inside the project:
Create a folder named .Credentials
and store newly downloaded credentials renaming them with service_credentials.json
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for google_api_support-0.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6e727284e1d307617dbcb1519ffe0da0b3ea34eefffda8b75b809492056f1132 |
|
MD5 | f1c0c4807122fbbddfadd845f52129ff |
|
BLAKE2b-256 | 48d13e3fac6bf2e48731cae11e023d0e9280c48220282a94352c21f1704e9858 |