I have a relatively big (60,000 rows) dataset on Google Sheets that I use to feed a Shiny App. I've been using the googlesheets package, which does the job just fine, as it reads the dataset very quickly after loading the Shiny App. However, since googlesheets will stop working in a few weeks, I'm trying to update my app to use googlesheets4. It works just fine with smaller datasets (under 2,000 rows, for example), but I takes a really long time to read the large one. This causes my Shiny App, which is hosted on shinyapps.io, to not load and give and error. What's the best way to deal with this? I'm using the function read_sheet("sheet_id"), by the way.
Thanks in advance!