googlesheets4 | Google Spreadsheets R API ( reboot of the googlesheets | REST library

Have a small dashboard. When the submit button is clicked there is no error, but there's also nothing written to the file.

The code looks like this:

We are currently using google sheets for a research project on crowd forecasts for Covid-19 case and death numbers.

Google Sheets is used for convenience, but we are often running into quota limit issues - even though the number of users we have should be well below what Google allows.

I attempted to create a somewhat reproducible example by setting up a new google account and creating a sheet from which to read.

The first thing I tried (without making any changes to the google account) is this:

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 account token and using that to authenticate, but still can't seem to get it to work.

I created a service account token and stored it in a JSON file. I then used the following command:

I've got googlesheets4 working in a shinyapps.io with the following code:

I am a beginner of Shiny dashboard and I have a problem that bothered me a long time.
My final target is to assign data to a variable called "myData", but I give the users options to upload data either from local file or online file (in my case GoogleSheet).
Below is a simplified version of my app. To achieve the target, I did:

1. Under the "data" tab, I create a selection box "input_option", so that the users can choose either uploading local data (="local") or data from a online persistent database (="online);
2. I use "eventReactive" to source the data conditional on the value of "input_option";
3. If the user chooses to upload the data from an online database, the data will be displayed in the dashboard body;
4. If the user chooses to upload data from a local file, in the dashboard body, it will show the "fileInput" box to guide the user choose the local file. Then the data will also be displayed underneath in the dashboard body.

However, the problems are:

1. In either way, the data cannot be displayed in the dashboard body. I don't even know if the data has been successfully sourced;
2. When I choose to upload online data and then close the app, the R console does not pause but keeping running.

Could any friends or experts help me with the problems? I really really appreciate your help!

I'm currently on a project aiming to generate some formatted report from R to google sheet.

Now I'm using googlesheets4 package and able to write data into google sheet from R. But is there a way to do some formatting work? like bold, italic, add $ sign or conditional formatting and etc.

Here is the example spread sheet I made.

https://docs.google.com/spreadsheets/d/1vp-w5muArvMxHKx4NL-39NMkAHRJCtldXLkUmJqKK2E/edit?usp=sharing

the output I want is like this(in sheet2), having $ in spend col, keep integer in kpi cols and conditional formatting on upsell cols

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 I do wrong? is there other way to complete this simple task? Thanks!

I am trying to read this googledoc via googlesheets4.

The file contains 3 columns:

1. id, as character
2. 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 made this googlesheet available to read with anybody with the link.

I read the dataframes as follows:

I know there are a few other similar questions floating around SO (e.g., here and here), but I thought I'd try again, as the others have not gotten many answers.

I have a Shiny app that allows its users to provide input through the app, but these users need to skip the authentication step. In the previous version of googlesheets I made the sheet public (to anyone with the link) and avoided some of the authentication process. In updating to googlesheets4 I've run into permissions issues with deploying the updated app to shinyapps.io. Here is the summary of what I've tried, and what results I've gotten. Any pointers would be much appreciated.

First, based on the recommendations in this gargle article I created a service account, downloaded a JSON service account token (with format "project-name-12345678abc1.json"), and have saved it (for now) in the parent app folder, under the assumption that it needs to be uploaded with the app bundle. Then I enabled the Google Sheets API.

I've put the following commands in the front of the app, ahead of anything substantial:

1. gs4_deauth(), since the google sheet is public to anyone with the link and therefore might not require a token.

2. Following this article, gs4_auth(path = "project-name-12345678abc1.json"). I've also added the scopes argument (as below), and use_oob=TRUE.

3. credentials_service_account(scopes = "https://www.googleapis.com/auth/spreadsheets", path = "project-name-12345678abc1.json").

4. credentials_app_default(path = "project-name-12345678abc1.json")

Results

Most combinations give me errors saying "Can't get Google credentials" and then advising that I look at the non-interactive article on the gargle site. The one exception is Attempt 3, which provides the following error message instead - strangely promising:

Warning: Error in : Client error: (403) PERMISSION_DENIED

• Client does not have sufficient permission. This can happen because the OAuth token does not have the right scopes, the client doesn't have permission, or the API has not been enabled for the client project.

Any ideas on what I might be missing? The app works fine locally.

Any help is appreciated. Thanks!