Access Google Sheets using the Sheets API V4


[Up] [Top]

Documentation for package ‘googlesheets4’ version 1.1.1

Help Pages

anchored Specify cells
as_sheets_id 'sheets_id' class
cell-specification Specify cells
cell_cols Specify cells
cell_limits Specify cells
cell_rows Specify cells
googlesheets4-configuration googlesheets4 configuration
gs4_api_key Edit and view auth configuration
gs4_auth Authorize googlesheets4
gs4_auth_configure Edit and view auth configuration
gs4_browse Visit a Sheet in a web browser
gs4_create Create a new Sheet
gs4_deauth Suspend authorization
gs4_endpoints List Sheets endpoints
gs4_example Example Sheets
gs4_examples Example Sheets
gs4_find Find Google Sheets
gs4_fodder Create useful spreadsheet filler
gs4_formula Class for Google Sheets formulas
gs4_get Get Sheet metadata
gs4_has_token Is there a token on hand?
gs4_oauth_client Edit and view auth configuration
gs4_random Generate a random Sheet name
gs4_scopes Produce scopes specific to the Sheets API
gs4_token Produce configured token
gs4_user Get info on current user
local_gs4_quiet googlesheets4 configuration
range_autofit Auto-fit columns or rows to the data
range_clear Flood or clear a range of cells
range_delete Delete cells
range_flood Flood or clear a range of cells
range_read Read a Sheet into a data frame
range_read_cells Read cells from a Sheet
range_speedread Read Sheet as CSV
range_write (Over)write new data into a range
read_sheet Read a Sheet into a data frame
request_generate Generate a Google Sheets API request
request_make Make a Google Sheets API request
sheets_id 'sheets_id' class
sheet_add Add one or more (work)sheets
sheet_append Append rows to a sheet
sheet_copy Copy a (work)sheet
sheet_delete Delete one or more (work)sheets
sheet_names Get data about (work)sheets
sheet_properties Get data about (work)sheets
sheet_relocate Relocate one or more (work)sheets
sheet_rename Rename a (work)sheet
sheet_resize Change the size of a (work)sheet
sheet_write (Over)write new data into a Sheet
spread_sheet Spread a data frame of cells into spreadsheet shape
with_gs4_quiet googlesheets4 configuration
write_sheet (Over)write new data into a Sheet