Thin, pythonic OO wrapper around Google's "google-api-python-client" library. Currently supports Python 3+
$ pip install google-objectsRequires a valid Google API Credentials object from Google's excellent oauth2lib library. For more information, visit here.
- Retrieve drive 'About' information:
from google_objects import DriveClient
gdrive = DriveClient(OAUTH2LIB_CREDS)
about = gdrive.get_about()
print(about.email)
print(about.name)
# prints link to profile photo
print(about.photo)
# ...- List files in drive by type:
files_by_type = {
'slides': gdrive.list_files('presentation'),
'folders': gdrive.list_files('folder'),
'spreadsheets': gdrive.list_files('spreadsheets'),
}
for file in files_by_type['folders']:
print(file.id)
print(file.name)
for file in files_by_type['spreadsheets']:
# prints list of parent folder IDs
print(file.parents)
# ...- Copy and share file:
file = gdrive.get_file('FILE_ID')
new_file = file.copy('NEW_FILE_NAME', ['PARENT_FOLDER_1', 'PARENT_FOLDER_2'])
# allow myfriend@hotmail.com to view
permission = new_file.add_permission('myfriend@hotmail.com')
# print newly created permission information
print(permission.role, permission.type, permission.email)- Retrieve presentation and loop through elements:
from google_objects import SlidesClient
gslides = SlidesClient(OAUTHLIB_CREDS)
presentation = gslides.get_presentation('PRESENTATION_ID')
# print slides attributes
for slide in presentation:
print(slide.id)
for element in slide: # equivalent to 'for element in presentation.elements()'
print(element.type)
# Shape, Table, etc- Check text in shape:
shape = presentation.get_element_by_id('SHAPE_ID')
for segment in shape.text:
print(segment.text)- Batch update every cell in table:
# use with to perform batch updates in block
with presentation as pres:
table = pres.get_element_by_id('TABLE_ID')
for cell in table:
print(cell.location) # tuple containing cell location
for segment in cell.text:
# update cell
segment.text = 'UPDATED_VALUE'- Retrieve spreadsheet and loop through sheets:
from google_objects import SheetsClient
gsheets = SheetsClient(OAUTHLIB_CREDS)
spreadsheet = gsheets.get_spreadsheet('SPREADSHEET_ID')
for sheet in spreadsheet:
print(sheet.id, sheet.title)- Get sheet by name and return its full block of values:
sheet = spreadsheet['Sheet 1']
values = sheet.values() - Get named range value block:
named_ranges = spreadsheet.named_ranges('SHEET_NAME!A:C')
for rng in named_range:
values = named_range.get_block()- Update values block:
values = spreadsheet.get_range('SHEET_NAME!A:C')
# loop through rows
for i, row in enumerate(values):
values[i] = [1, 2, 3]
print(row)
values.update()
# you can also use the slice syntax for updating..
values[2:5] = [[1,2,4], [4, 5, 6], [6, 7, 8]]
values.update()- Append to values block:
to_append = [[1, 2, 3], [4, 5, 6]]
values.append(to_append)