googlesheets41.1.1 package

Access Google Sheets using the Sheets API V4

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

pipe

Pipe operator

cell-specification

Specify cells

googlesheets4-configuration

googlesheets4 configuration

googlesheets4-package

googlesheets4: Access Google Sheets using the Sheets API V4

googlesheets4-vctrs

Internal vctrs methods

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_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_app

Get currently configured OAuth app (deprecated)

range_autofit

Auto-fit columns or rows to the data

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

request_generate

Generate a Google Sheets API request

request_make

Make a Google Sheets API request

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

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

sheets_id class

spread_sheet

Spread a data frame of cells into spreadsheet shape

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.

  • Maintainer: Jennifer Bryan
  • License: MIT + file LICENSE
  • Last published: 2023-06-11