Stack Overflow
Stack Overflow

Questions tagged [googlesheets4]

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.

82 questions
0
votes
1 answer

Trying to write from R to Google Sheets, can't get credentials

For the past 6+ months I read and wrote from R to Google Sheets without any issues, with the googlesheets4 package. Yesterday, all of a sudden, I started to get the 'Can't get Google credentials' error and I can't seem to find a solution to it. I've…
Anca
  • 9
  • 2
0
votes
1 answer

Is it possible to stream data from google sheets into R?

Is it possible to get real-time data from google sheets into R? Basically, I have a google sheet and I want to get data from it and display it in a shinyApp. But when the data in the google sheet changes/updates, it should also get updated in the…
Mayur Shende
  • 13
  • 2
0
votes
0 answers

Error in curl::curl_fetch_memory: could not resolve host: sheets.googleapis.com

I am having a problem with googlesheets4 on my shiny app. Every time I update the sheet with new data, it causes an error with the app on our server. Here is the error log. error log showing the error with host sheets.googleapis.com:
naba
  • 1
  • 1
0
votes
0 answers

*** caught segfault *** address 0x38, cause 'memory not mapped' when using googlesheets4::gs4_auth

I have problem when calling googlesheets4::gs4_auth() using json path googlesheets4::gs4_auth(path = auth_jspath) This is error log: *** caught segfault *** address 0x38, cause 'memory not mapped'. Warning: stack imbalance in 'lazyLoadDBfetch', 33…
Linh
  • 147
  • 7
0
votes
1 answer

How to catch timeout error and retry when writing large data to Google Sheets using googlesheets4 in R

I've got an R script that reads data from a DB and writes it to a Google spreadsheet (the script reads several tables, each written to a different sheet of the spreadsheet). It works fine, but the problem I'm having is that since some of the tables…
Sebastian Schurmann
  • 21
  • 1
0
votes
1 answer

write_sheet() error: Don't know how to make an instance of `CellData` from something of class 'data.frame'

I queried this from our mongoDB data2 <- table$find( query = '{"disabled" : true}', fields = '{"general.name" : true, "_id": true') View(data) looks as I would expect it but when I try to use the googlesheets4::write_sheet(data = data2, ss = "a…
ihavenoclueofwhatimdoing
  • 33
  • 7
0
votes
1 answer

How to read data from dropdown list in googlesheets4?

There is a spreadsheet that has a dropdown of values Fruits Colors Apple Blue Pear Red Whenever I try to use read_sheet, all these values come up as NA. How do I solve this?
Adrian Fletcher
  • 86
  • 8
0
votes
1 answer

Gargle non-interactive service account token authentication not working

I'm using the googlesheets4 package, which uses gargle for authentication. I have a scheduled script that runs regularly, so I need to set up non-interactive authentication. I tried following all the instructions I've found for setting up a service…
Lev Pevzner
  • 81
  • 1
  • 6
0
votes
2 answers

R googlesheets4 pass token as parameter to read_sheet

I can read a sheet only if the sheet is already authorised, If not, every subsequent line of code is ignored, as the code execution keeps asking for the token. Is there a way to pass the token index into the read_sheet command, or some way to…
Chris Elliott
  • 1
0
votes
0 answers

Having >1 Reactive Dataframes in Rshiny from GoogleSheets (solved)

I've been thinking about this problem for a long time and can't seem to figure it out! What I've built is a RShiny App that captures REACTIVE (real-time) data from googlesheets using the library(googlesheets4) and populate a datatable. What Works I…
Javier
  • 730
  • 4
  • 17
0
votes
1 answer

Download spedific tab of google sheet in R

I'm trying to download a specific tab from a google sheet to R, after trying gsheet package I only get the first tab, no matter how I change the sheetid. I also try the library googlesheets4 to identify the sheet id but I got empty result, what did…
ponyhd
  • 491
  • 1
  • 4
  • 19
0
votes
1 answer

Importing date columns as lists from googledoc via googlesheets4 in R

I am trying to read this googledoc via googlesheets4. The file contains 3 columns: id, as character start_date / end_date: this columns contain both dates (in the format 2020-01-31) and text strings (namely strings being in_stock and in_use) I…
chopin_is_the_best
  • 1,951
  • 2
  • 23
  • 39
0
votes
0 answers

drive_find() or sheets_find doesn't get a shared google sheet in r

I am using googlesheets4 package in R. My colleague shared a google sheet with me with full access. But I cannot get it with either drive_find() or sheets_find but I do get other shared files. I don't know why.. Here's my code in…
Gwen Yang
  • 126
  • 9
0
votes
1 answer

Accessing the spreadsheet using access token in R using googlesheets4

I'm trying to access the sheet using oAuth 2.0 in R. I have generated the access token. I am not clear of how to retrieve the data from the above mentioned sheet. I have tried to access the data using this piece of code sampleData <-…
Nevedha Ayyanar
  • 845
  • 9
  • 27
0
votes
0 answers

What are methods for automatic labeling of data downloaded from Google Sheets / Google Surveys?

Retrieving data collected using Google spreadsheets is quite convenient, but if I want to use the R package for example to create a database from this, there is a problem with nominal categories (not-numbers data). I usually…
kwadratens
  • 187
  • 15
1 2 3 4
5
6