lares (version 5.1.0)

readGS: Google Sheets Reading and Writing (API v4)

Description

Read and write data from Google Sheets knowing the file's title. You may use a single value from a cell or a data.frame from a cell range.

Usage

readGS(
  title,
  sheet = "Hoja 1",
  range = NULL,
  drop_nas = TRUE,
  json = NULL,
  email = NULL,
  api_key = NULL,
  server = FALSE,
  ...
)
writeGS(
  data,
  title,
  sheet = "Hoja 1",
  range = "A1",
  reformat = FALSE,
  append = FALSE,
  json = NULL,
  email = NULL,
  api_key = NULL,
  server = FALSE,
  ...
)

Arguments

title

Character. Title of Google Drive file. Uses regular expressions so you may fetch with patterns instead of names.

sheet

Character. Working sheet to import

range

Character. A cell range to read from

drop_nas

Boolean. Remove columns and rows that contain only NAs?

json

Character. JSON filename with service auth

email, api_key

Character. If you have multiple pre-authorized accounts in your machine, you may non-interactively select which one you wish to use by email and/or api_key.

server

Boolean. Force interacting auth process?

...

Additional parameters passed to read_sheet().

data

Object (value, vector, data.frame, list).

reformat

Boolean. Reformat the affected cells?

append

Boolean.

Value

For reading, data.frame with the results of your Google Sheets file based on its title, specificially the sheet and range requested. For writing, no return value.

See Also

Other Scrapper: filesGD(), get_mp3(), gtrends_related(), holidays(), ip_data(), splot_etf(), stocks_quote()

Other Google: filesGD(), gtrends_related(), queryGA()