gsheet2text function

Download Google sheet as text.

Downloads a Google sheet as text, using just the url. The Google sheet must have 'share by link' turned on.

gsheet2text(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)

Details

sheetid is the index of the sheet to be downloaded. If you use the direct sheet URL, rather than the share by link, this will automatically be extracted. Otherwise, the first sheet will be downloaded by default.

Examples

url <- 'docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo'
a <- gsheet2text(url)
b <- read.csv(text=a)

See Also

gsheet2text to download as a table