Access Google Sheets using the Sheets API V4
googlesheets4 provides an R interface to Google Sheets via the Sheets API v4. It is a reboot of an earlier package called googlesheets.
Questions tagged [googlesheets4]
82 questions
0
votes
0 answers
subsetting errors in R tbl and dataframe when importing sheet from google drive
I have a dataset in R which I am importing from googledrive using the googlesheets4 package
dat <- read_sheet("url")
which appears to import correctly. Inspecting the class shows that it's a tbl_df
> class(dat)
[1] "tbl_df" "tbl" …
becbot
- 151
- 1
- 2
- 9
0
votes
1 answer
How to delete rows of my googlesheets using R
I am using the googlesheets4 package to access my Googlesheets.
I can retrieve the data from my file named Youtube and the sheet named Youtube_Links but I would like to delete some rows, for example rows 16 to 18 for all columns.
I have seen…
ML_Enthousiast
- 1,147
- 1
- 15
- 39
0
votes
1 answer
Trying to Optimize Speed of R Shiny App Load Time -- Slow googlesheets4 pull
I'm currently working on an R Shiny App that utilizes googlesheets4 to pull in a large dataset from GoogleSheets upon app launch. Loading in this dataset to my app takes ~2 minutes, which stalls my entire app's load time.
The only visual in my app…
hlag
- 21
- 3
0
votes
0 answers
Import a dataframe with googlesheets4 in a Rmarkdown file
How can I read a sheet from google sheets and use it in RMarkdown, without having to answer the authorization question?
url <- "https://docs.google.com/spreadsheets/d/1tAeMng_wLlZfDfeeLzgV8h7vGqWmFhqQv1AAXf60HtU/edit?usp=sharing"
df <-…
Juanchi
- 1,147
- 2
- 18
- 36
0
votes
1 answer
R can't access googlesheets4, despite API enabled
I use R to connect to Google Analytics and I can sign in, but when trying to connect to Google Sheets it doesn't let me sign in. I tried the following code:
library(googlesheets4)
gs_auth()
And it takes me to the user authentication page, but the…
Alexis
- 2,104
- 2
- 19
- 40
0
votes
0 answers
How do I read A Google spreadsheet from my Google Drive into R?
I am trying to read a spreadsheet from my Google Drive into R without downloading it locally. Based on advice from other questions on this forum, I have been using the googledrive and googlesheets4 packages. I ran the following code:
>…
dkro
- 193
- 1
- 8
0
votes
2 answers
How can I login to googlesheets using R and an existing JSON key?
I am trying to upload my csv files to my google drive/sheets.
Working code: a window pop-up, I login into my google account, then code works perfectly, file is uploaded.
library(googledrive)
library(googlesheets4)
dff <- drive_upload('dff.csv',…
Arkadi w
- 129
- 22