Stack Overflow
Stack Overflow

Questions tagged [r-googlesheets]

Use this tag for questions related to the R googlesheets-package.

Access and manage Google spreadsheets from R with googlesheets.

References

65 questions
3
votes
4 answers

How to upload a R data frame into a google drive ?

I am using googledrive package from CRAN. But, function - drive_upload lets you upload a local file and not a data frame. Can anybody help with this?
pranav
  • 1,041
  • 1
  • 10
  • 11
3
votes
2 answers

Remote server authentication to read Googlesheets from R script not using service accounts?

I'm automating a process in R that pulls, pushes, analyses & stores data in a certain way and all in all, juggles data between Googlesheets, Postgresql, and salesforce. Till now, I had it running in my system but I will need to run the scripts from…
Deepak
  • 653
  • 1
  • 7
  • 12
3
votes
0 answers

Trying to access files from Google Drive folders using R

I am a beginner in R and I am trying to access google sheets on Google drive using R. Package googlesheets is one way of accessing the google sheets, but with this I am only able to download, edit or upload files to the 'My Drive' folder on google…
R Bud
  • 261
  • 1
  • 4
  • 16
3
votes
1 answer

About "gsheet" package in R

I have some questions about gsheet package, version 0.2.1. Here is my code in shiny. urlA <- "https://docs.google.com/spreadsheets/d/1lVVGg2iRLtOaizrkaJHtPCyEnQiKAnJPyNj1kSSPXvY/edit?usp=sharing" p_A <- gsheet2tbl(urlA) Error message: Error in…
Chen Jin Yan
  • 109
  • 11
2
votes
3 answers

How to authenticate with googlesheets package in a head less environment(EC2 instance)?

Normally when I use googlesheets package on my desktop R studio, it puts me through a browser based authentication, where I select my Google account for authentication and it gets approved.I use the gs_ls() function for authentication. Now I am…
Arpit Solanki
  • 113
  • 1
  • 6
2
votes
1 answer

How to change Google Accounts using library(googlesheets)?

I experience some problems. I use a R-Script on one machine successfully. The same script used on a different computer causes problems: # Here I register the sheet browser <- gs_title("Funnel Daily") browser<-gs_edit_cells(ws="Classic Browser",…
Googme
  • 914
  • 7
  • 27
2
votes
2 answers

googlesheets R authentication error

I used to have the googlesheets package in R pulling data off my drive account just fine, but recently when I start up I can't access the data. I've tried using the gs_auth(new_user=TRUE) to reset, but when I get taken to the web browser, I accept…
tlyons253
  • 83
  • 8
1
vote
1 answer

Error with googlesheets package in R - unable to load curl

I'm trying to update a google sheet in R using the googlesheets package, but: whenever I try gs_title('Name_of_the_sheet'), I get an error saying 'Error in loadNamespace(name) : there is no package called ‘curl’'. Of course, I tried installing the…
Pechi
  • 151
  • 1
  • 6
1
vote
1 answer

authenticate user using R googlesheets timeout

I want to authenticate a user using R googlesheet. I tried using: library(magrittr) library(googlesheets) suppressMessages(gs_auth(token = "...\\Documents\\googlesheets_token.rds", verbose = FALSE)) but I obtain the next message: Error in…
xanonimoxp
  • 29
  • 3
1
vote
0 answers

R: Introducing Automation in Shiny App

I want to know the way to build a Shiny App which automatically runs functions in a scheduled time. I read this but it doesn't seem relevant to my case. I created a function to update a google sheet, using the package googlesheet. Now the app ui…
Makoto Miyazaki
  • 1,743
  • 2
  • 23
  • 39
1
vote
1 answer

R script to insert images into Google Sheets

Is there a way to insert images, in this case ggplot2 charts, into a Google Sheet, using an R script? Maybe using the googlesheets package? I see how to add an image to an Excel spreadsheet and I can add an image to a Google Sheet in my browser via…
Sam Firke
  • 21,571
  • 9
  • 87
  • 105
1
vote
0 answers

googlesheet gs_new() too slow

I've got a data.table DT with 270 observations of 21 variables. Using GoogleSheet API to write this data.table to Google drive. it takes about ten minutes for the file to be written. Is this normal?? I've tried everything and looked everywhere to…
Ankhnesmerira
  • 1,386
  • 15
  • 29
1
vote
1 answer

Failing HTTP request to Google Sheets API using googleAuthR, httr, and jsonlite

I'm attempting to request data from a google spreadsheet using the googleAuthR. I need to use this library instead of Jenny Bryan's googlesheets because the request is part of a shiny app with multiple user authentication. When the request range…
why
  • 61
  • 1
  • 1
  • 4
1
vote
0 answers

writing data from R to Googlesheets

I'm trying to write a data frame consisting 1100 rows and 5 columns from R to GoogleSheets using library(googlesheets) but it is taking forever to do so and sometimes returns Error in function_list[[k]](value) : Bad Gateway (HTTP 502). How to solve…
Shubhangi Sharma
  • 117
  • 1
  • 7
1
vote
0 answers

Fast data writing to google spreadsheet from R

I'm trying to write some data back to google spreadsheet from R Object (data frame to be specific), having around 42 columns and 1700 rows but looks like it is taking forever to write data back to google spreadsheet. Is the currently config is not…
Abhishek
  • 11
  • 2
1
2
3 4 5