Installation

$ pip install google-objects

Usage

Google Drive v3

fromgoogle_objectsimportDriveClientgdrive=DriveClient(OAUTH2LIB_CREDS)about=gdrive.get_about()print(about.email)print(about.name)# prints link to profile photoprint(about.photo)# ...

files_by_type= {'slides':gdrive.list_files('presentation'),'folders':gdrive.list_files('folder'),'spreadsheets':gdrive.list_files('spreadsheets'),}forfileinfiles_by_type['folders']:print(file.id)print(file.name)forfileinfiles_by_type['spreadsheets']:# prints list of parent folder IDsprint(file.parents)# ...

file=gdrive.get_file('FILE_ID')new_file=file.copy('NEW_FILE_NAME', ['PARENT_FOLDER_1','PARENT_FOLDER_2'])# allow myfriend@hotmail.com to viewpermission=new_file.add_permission('myfriend@hotmail.com')# print newly created permission informationprint(permission.role,permission.type,permission.email)

Google Slides v1

fromgoogle_objectsimportSlidesClientgslides=SlidesClient(OAUTHLIB_CREDS)presentation=gslides.get_presentation('PRESENTATION_ID')# print slides attributesforslideinpresentation:print(slide.id)forelementinslide:# equivalent to 'for element in presentation.elements()'print(element.type)# Shape, Table, etc

shape=presentation.get_element_by_id('SHAPE_ID')forsegmentinshape.text:print(segment.text)

# use with to perform batch updates in blockwithpresentationaspres:table=pres.get_element_by_id('TABLE_ID')forcellintable:print(cell.location)# tuple containing cell locationforsegmentincell.text:# update cellsegment.text='UPDATED_VALUE'

Google Sheets v4

fromgoogle_objectsimportSheetsClientgsheets=SheetsClient(OAUTHLIB_CREDS)spreadsheet=gsheets.get_spreadsheet('SPREADSHEET_ID')forsheetinspreadsheet:print(sheet.id,sheet.title)

sheet=spreadsheet['Sheet 1']values=sheet.values()

named_ranges=spreadsheet.named_ranges('SHEET_NAME!A:C')forrnginnamed_range:values=named_range.get_block()

values=spreadsheet.get_range('SHEET_NAME!A:C')# loop through rowsfori,rowinenumerate(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()

to_append= [[1,2,3], [4,5,6]]values.append(to_append)