Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

Get Started for Free

googlesheets4

Access Google Sheets using the Sheets API V4

Interact with Google Sheets through the Sheets API v4 <https://developers.google.com/sheets/api>. "API" is an acronym for "application programming interface"; the Sheets API allows users to interact with Google Sheets programmatically, instead of via a web browser. The "v4" refers to the fact that the Sheets API is currently at version 4. This package can read and write both the metadata and the cell data in a Sheet.

Functions (42)

as_id.googlesheets4_spreadsheet

Extract the file id from Sheet metadata

as_sheets_id

Coerce to a sheets_id object

cell-specification

Specify cells

googlesheets4-deprecated

Deprecated functions

googlesheets4-package

googlesheets4: Access Google Sheets using the Sheets API V4

googlesheets4-vctrs

Internal vctrs methods

Authorize googlesheets4

gs4_auth_configure

Edit and view auth configuration

Visit a Sheet in a web browser

Create a new Sheet

Suspend authorization

gs4_endpoints

List Sheets endpoints

gs4_example

File IDs of example Sheets

Find Google Sheets

Create useful spreadsheet filler

gs4_formula

Class for Google Sheets formulas

Get Sheet metadata

gs4_has_token

Is there a token on hand?

Generate a random Sheet name

Produce configured token

Get info on current user

pipe

Pipe operator

range_autofit

Auto-fit columns or rows to the data

range_delete

Delete cells

range_flood

Flood or clear a range of cells

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

request_generate

Generate a Google Sheets API request

request_make

Make a Google Sheets API request

Add one or more (work)sheets

sheet_append

Append rows to a sheet

Copy a (work)sheet

sheet_delete

Delete one or more (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

sheets_id object

spread_sheet

Spread a data frame of cells into spreadsheet shape

googlesheets4

Access Google Sheets using the Sheets API V4

v0.3.0

MIT + file LICENSE

Authors

Jennifer Bryan [cre, aut] (<https://orcid.org/0000-0002-6983-2759>), RStudio [cph, fnd]

Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.