importSheet: importSheet

In AMGold99/piperr: Speeds up Piper Center Analytics

importSheet

Description

Imports data from a specified Google Sheets spreadsheet

Usage

importSheet(link, email, sheet, range = NULL, col_names = TRUE, ...)

Arguments

link	Link to Google Sheets document containing the data. May be a full url or a Google Sheets ID (the string between "../d/" and "/edit..." in the url).
email	Email address which has access to the Google Sheets document.
sheet	Character string specifying the name of the spreadsheet within the Google Sheets document which contains the desired data.
range	Optional. Character string specifying the range to be imported (e.g., 'A1:G100').
col_names	Defaults to TRUE, using the first row in the spreadsheet as the column names. A character vector of custom column names may be passed to this argument.
...	Other read_sheet arguments. See ?read_sheet for more.

Details

Wraps several googlesheets4 functions to import a specified sheet (and range if desired) from a Google Sheets document. Aside from link and email, all googlesheets4::read_sheet() arguments may be passed to importSheet()

AMGold99/piperr documentation built on March 29, 2022, 9:46 a.m.