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
0
votes
0 answers

httpuv fails to start oauth server when running batch file via Task Scheduler

I have a batch file that kicks off an R script: "C:\Program Files\R\R-3.3.1\bin\x64\Rscript.exe" "C:\Folder\Script.R" Within this R script, I use the gs_auth function to grab my auth token and use it in the R session. I can successfully run my R…
Scott
  • 446
  • 4
  • 16
0
votes
0 answers

Authentication Error - googlesheet package - R

I am trying to use googlesheets package by initiating as below: install.packages("googlesheets") library(googlesheets) gs_auth() which gives me the following message: Click "ok" button in two steps for authorization . **Waiting for authentication…
rane
  • 901
  • 4
  • 12
  • 24
0
votes
1 answer

Check if a worksheet exists

How can you check if a certain worksheet with title exist in your spreadsheet, using the googlesheets package?
Cing
  • 806
  • 1
  • 11
  • 29
0
votes
0 answers

how to upload multiple dataframes in one gs_edit_cells command

I am sure others using the googlesheets package would encounter this question some time or the other. Since googlesheets gs_edit_cells() is known to be very slow, is there a way to upload multiple data frames on to multiple anchor points in the same…
Lazarus Thurston
  • 1,197
  • 15
  • 33
0
votes
1 answer

Read European formatted csv with googlesheets package

I have trouble finding ways to import files efficiently that are formatted European style (a , comma for decimals and . dot for thousands 12.300,35) from google sheets via the library(googlesheets) package. R will automatically read the commas as…
Tdebeus
  • 1,519
  • 5
  • 21
  • 43
0
votes
1 answer

How to add the current date into a google worksheet name with R?

I am using R, and trying to create a google worksheet with today's date in the worksheet title. Here is my code so far...I don't know what I missing or if this is doable. Any suggestions or help would be appreciated. library(googlesheets) …
AENick
  • 301
  • 1
  • 2
  • 8
0
votes
0 answers

Retrieve data from Google Drive file which is not shared by link in R

I would like to import a file to R from Google Drive. I am trying this with gsheet::gsheet2text, but unable to retrieve information because it is not shared by link. How can I log in to get the data through R?
Yoshiki
  • 33
  • 5
0
votes
1 answer

Trouble uploading a googlesheet from my remote server using the googlesheets package in R

I have been using the googlesheets package to download sheets from googlesheets and modify them. I then want to update the sheets and push them back to the web. I can do this fine from my local computer using the following…
colin
  • 2,606
  • 4
  • 27
  • 57
0
votes
1 answer

R not recognising worksheet number 2 to add rows

I am trying to add data to the second worksheet of an existing Google Sheet, but the R googlesheet package does not seem to recognise that there are more than one worksheets already in the spreadsheet. Here are the interactive commands along with…
Lazarus Thurston
  • 1,197
  • 15
  • 33
0
votes
0 answers

Display a mandatory name and email box in shiny app

I have been building a Shiny app that displays some information gathered from the web. Im using shinydashboard to create the app. I would like to have a startup box that is either a login page or a Name and Email input box that anyone that wants to…
Filipe Rigueiro
  • 57
  • 11
0
votes
1 answer

gspread data does not appear in Google Sheet

I'm trying to write sensor data to a google sheet. I was able to write to this same sheet a year or so ago but I am active on this project again and can't get it to work. I believe the Oauth has changed and I've updated my code for that change. In…
JonRob
  • 43
  • 1
  • 6
0
votes
1 answer

Save Shiny output to Googlesheets

I have a shiny app which produces output I'd like to save to a Googlesheet. The app produces values based on user inputs and I've created a working mock-up (as abbreviated as I could) to replicate the error as seen in the code snippet box…
user8038130
0
votes
0 answers

Reset Shiny widgets with Shinyjs and googlesheets

My app takes user input and stores it in google sheets.I'd like to have an action button that resets all sidebar-panel ui inputs when button is clicked. I gave it a try with shinyjs just like this post but I get the grey screen every time I press…
W148SMH
  • 152
  • 1
  • 11
0
votes
2 answers

Shinyapps disconnecting from server, possibly exceeding memory limit with excel file

I created a shinyapp that displays output data from a 10,000-trial Monte Carlo simulation. The simulation is of an entire football season with 238 teams, tracking seven variables for each team in each trial (16.66+ million data points). The data…
L. Hansen
  • 33
  • 5
0
votes
1 answer

google sheets IF AND statements not working

Hi im trying to execute a AND IF statement inside an existing IF statement but its not reading the value from cell O:O Here is the code - screenshot of the sheet included Any ideas on what im doing…
KingGofG
  • 25
  • 1
  • 7
1 2 3
4
5