The sheet_download function downloads the contents of a Google Sheet into an R object with with optional parameters for rows to skip and a missing value code upon import.

sheet_download(fileId, skipRows, missingValueCode)

Arguments

fileId

Sheet ID or URL of Google Sheet to import

skipRows

number of rows to skip when importing (optional; default:0)

missingValueCode

string to denote missing values (optional; default:"NA")

Value

R object of type tibble

Note

sheet_download is intended primarily as a helper function for batch downloading Google Sheets via a apply or map call but can be used independently.