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

Question

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 shinyApp.

Thank you

score 0 · Answer 1 · answered Oct 19 '21 at 12:43

0

You should be able

to poll the data using google-sheets-api or
push the changes from Google sheets using installed onEdit/onChange trigger in apps script(assuming you have a http end point to receive the push)

answered Oct 19 '21 at 12:43

TheMaster

45,448
6
62
85

I am new to this and never used the google sheets API. Can you give some details and an example in R? – Mayur Shende Oct 20 '21 at 01:28
@MayurShende No. I don't know R. I know the api and apps script. – TheMaster Oct 20 '21 at 06:23
@MayurShende Checkout https://github.com/tidyverse/googlesheets4 and tag https://stackoverflow.com/questions/tagged/googlesheets4 for samples – TheMaster Oct 20 '21 at 06:29

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

1 Answers1