get_googlesheet

The generic function to get data from a Googlesheet and return a tibble dataframe

get_googlesheet(
  sheet_url,
  sheet = NULL,
  user_email = NULL,
  skip = 0,
  sleep = 5,
  range = NULL
)

Arguments

sheet	Either a string (the name of a sheet), or an integer (the position of the sheet). If not specified the first visible sheet will be read
user_email	user email if sheet contains authentication. This may open a browser for authentication and access to Gdrive (optional)
skip	number of lines to skip before reading header line (optional)
sleep	number of seconds to sleep after call to prevent overload of Google APIs
sheet_id	The url of a Google Sheet

Value

A tibble dataframe representation of the Googlesheet