gsheet (version 0.4.6)

construct_download_url: Construct a google sheet download url from the sheet's viewing url

Description

Converts the viewing url for a google sheet to a download url.

Usage

construct_download_url(url, format = "csv", sheetid = NULL)

Arguments

url

the google sheet url

format

controls the column separator used. csv or tsv

sheetid

the id of the sheet to download from. (Default NULL, downloads the first sheet)

Examples

# Download a sheet manually using readr
url <- 'docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo'

if(requireNamespace('readr', quietly=TRUE)){
  library(readr)
  read_csv(construct_download_url(url), col_types = cols(
    mpg = col_double(),
    cyl = col_integer(),
    disp = col_double(),
    hp = col_integer(),
    drat = col_double(),
    wt = col_double(),
    qsec = col_double(),
    vs = col_integer(),
    am = col_integer(),
    gear = col_integer(),
    carb = col_integer()
  ))
}