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
1
vote
1 answer

Unable to authenticate googlesheets package for R studio

I'm trying to work in R studio and shiny with remote databases. For this purpose, I downloaded JennyBrian's package install.packages("googlesheets") library(googlesheets) When I try to initiate the program I have to authorize my google account…
Juan Acosta
  • 171
  • 1
  • 9
1
vote
1 answer

Non-interactive auto-refresh stale OAuth Token with Googlesheets package

I'm trying to automatically run an r script to download a private Google Sheet every hour. It always works fine when I'm interactively using R. It also works fine during the first hour after I automate the script with launchd. It stops working an…
Ron Guymon
  • 11
  • 3
1
vote
1 answer

Integer interpreted as date when added to Google Sheets by R + googlesheets

I am trying to add pairs of values (date, value) to Google Sheets via gs_add_row from googlesheets. This succeeds, except that both values show up as dates on Google Sheets. I checked the "value" beforehand to make sure it is as expected (eg. 50),…
adatum
  • 655
  • 9
  • 23
1
vote
0 answers

Adding data to Google Sheets without authentication (R + googlesheets)

Is it possible to add rows to an existing public Google Sheet without prompting for user authentication? I have the following function in a shiny app: update <- function(URL, date, value){ URL %>% gs_url() %>% gs_add_row(ws = 3,…
adatum
  • 655
  • 9
  • 23
1
vote
0 answers

Error while running Rscript using crontab: ELF file OS ABI invalid

I am running an Rscript using crontab. In that Rscript command, I am trying to load googlesheets package using library(googlesheets). Note, I have already installed googlesheets package is already installed. I am getting this error: Error in…
R Bud
  • 261
  • 1
  • 4
  • 16
1
vote
2 answers

Authenticating google sheets on AWS Ubuntu without browser

I'm running R Studio on an AWS "Ubuntu Server 12.04.2" and accessing R Studio via my browser. When I try to authenticate google auth API using the package googlesheets with the code: gs_auth(token = NULL, new_user = FALSE, key =…
Prateek Saxena
  • 71
  • 1
  • 9
1
vote
1 answer

Adding rows to a Google Sheet using the R Package googlesheets

I'm using the googlesheets package (CRAN version, but available here: https://github.com/jennybc/googlesheets) to read data from a Google Sheet in R, but would now like to add rows. Unfortunately, every time use gs_add_row for an existing sheet I…
Charlie Joey Hadley
  • 788
  • 8
  • 22
1
vote
1 answer

Read cell values without formatting into R with googlesheets

Would like to be able to read Google Sheets cell values into R with googlesheets package, but without any cell formatting applied (e.g. comma separators, percentage conversion, etc.). Have tried gs_read() without specifying a range, which uses…
Eric Goldsmith
  • 11
  • 3
0
votes
0 answers

Saving excelsheet as Googlesheet with same access rights to user & sharable link

hv uploaded an excelsheet on a Google drive and have shared to multiple users with shareable link for updation. Now tht i wants to restrict users to update on their specific cells only for tht I needed to save as Googlesheet.. but the new file is…
hawk
  • 21
  • 3
0
votes
1 answer

Take mail ID by pressing a button in googlesheet

Can someone suggest me a Google Script that will make a button that will get the mail ID of the person and put it into a specified Google sheet.
Sukhwinder Rahal
  • 3
  • 2
0
votes
0 answers

Getting JSON results in Google Sheets

I am struggling to get JSON results from a specific api url into google sheets in tabular format. I have used code from the below link to import JSON data into Google Spreadsheets by adding a…
Sabha
  • 621
  • 10
  • 32
0
votes
1 answer

Formula that needs to return information based on two criterias

I have reached a roadblock when it comes to a formula that we are currently working on for works purposes. What the formula needs to achieve is bring back information based on two cells' information. We have gotten it to work with one cell using …
Johan
  • 1
  • 2
0
votes
2 answers

Is there any option to obtain more than 500 results with gs_ls()?

I'm trying to set a spreadsheet by their title, but when I use gs_ls I only obtain the last 500 sheets updated. I had tried to obtain an spreadsheet object using gs_title, but I obtained an error message with the message "doesn't match sheet_title…
mortega
  • 1
  • 2
0
votes
0 answers

How to fix failure to import formula result from a Google sheet into R

I'm trying to import data from a Google spreadsheet, but I can't import the value in this case when the result is derived from a formula. I've had success with other formulas, but there is something different about this one which is causing me…
WageSlave
  • 1
  • 1
0
votes
0 answers

R googlesheets gs_ls() returns Content Type Error

I am trying our the R googlesheets package and I ran into an issue just trying to pull up the list of sheets. I ran the authentication process and I don't think its related to authentication issues. The error seems to be related with out the sheets…
James Holland
  • 1,102
  • 10
  • 17
1 2
3
4 5