Function reference • googlesheets4

Reading Import data from a Sheet into a local data frame
`range_read()` `read_sheet()`	Read a Sheet into a data frame
`range_speedread()`	Read Sheet as CSV
`range_read_cells()`	Read cells from a Sheet
`spread_sheet()`	Spread a data frame of cells into spreadsheet shape
`cell-specification`	Specify cells
Writing Write data into a Sheet
`sheet_write()` `write_sheet()`	(Over)write new data into a Sheet
`gs4_create()`	Create a new Sheet
`sheet_append()`	Append rows to a sheet
`range_write()`	(Over)write new data into a range
`range_flood()` `range_clear()`	Flood or clear a range of cells
Data preparation Helpers for preparing data to write into Sheets
`gs4_fodder()`	Create useful spreadsheet filler
`gs4_formula()`	Class for Google Sheets formulas
Metadata on Sheets Helpers for accessing Sheets and their metadata
`gs4_get()`	Get Sheet metadata
`gs4_find()`	Find Google Sheets
`gs4_browse()`	Visit a Sheet in a web browser
`as_sheets_id()`	Coerce to a sheets_id object
`sheets_id`	`sheets_id` object
`as_id(<googlesheets4_spreadsheet>)`	Extract the file id from Sheet metadata
`gs4_random()`	Generate a random Sheet name
Modify a Sheet Make changes to a (spread)Sheet or to the (work)sheets it contains
`gs4_create()`	Create a new Sheet
`range_delete()`	Delete cells
`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_properties()` `sheet_names()`	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()` `write_sheet()`	(Over)write new data into a Sheet
`sheets_id`	`sheets_id` object
Formatting and aesthetics Change how a Sheet appears in the browser UI
`range_autofit()`	Auto-fit columns or rows to the data
Example Sheets World-readable Sheets to use in examples and reprexes
`gs4_example()` `gs4_examples()`	File IDs of example Sheets
Auth Take explicit control of the googlesheets4 auth status or examine current state
`gs4_auth()`	Authorize googlesheets4
`gs4_deauth()`	Suspend authorization
`gs4_user()`	Get info on current user
`gs4_auth_configure()` `gs4_api_key()` `gs4_oauth_app()`	Edit and view auth configuration
Programming around the Sheets API Low-level functions used internally and made available for programming
`request_generate()`	Generate a Google Sheets API request
`request_make()`	Make a Google Sheets API request
`gs4_token()`	Produce configured token
`gs4_has_token()`	Is there a token on hand?
`gs4_endpoints()`	List Sheets endpoints
Operate on (spread)Sheets or the Sheets API Functions that operate at the level of a (spread)sheet or the whole API/package
`gs4_auth()`	Authorize googlesheets4
`gs4_auth_configure()` `gs4_api_key()` `gs4_oauth_app()`	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()` `gs4_examples()`	File IDs of 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_random()`	Generate a random Sheet name
`gs4_token()`	Produce configured token
`gs4_user()`	Get info on current user
Operate on (work)sheets Functions that operate on whole (work)sheets
`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_properties()` `sheet_names()`	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()` `write_sheet()`	(Over)write new data into a Sheet
Operate on a range of cells Functions that can target a cell range
`range_autofit()`	Auto-fit columns or rows to the data
`range_delete()`	Delete cells
`range_flood()` `range_clear()`	Flood or clear a range of cells
`range_read()` `read_sheet()`	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

Reference

Reading

Writing

Data preparation

Metadata on Sheets

Modify a Sheet

Formatting and aesthetics

Example Sheets

Auth

Programming around the Sheets API

Operate on (spread)Sheets or the Sheets API

Operate on (work)sheets

Operate on a range of cells