I need help with writing_sheet in {googlesheets4}

I have looked over a lot of forums, but I'm still quite confused about this.

In the googlesheets4 package, gs4_deauth() may be used to deauthenticate, which is useful in the case that your only goal is to read info from a public google sheet. It avoids the need for the browser to pop up and require you to login to your google account.

However, my goal is to write information to my public google sheet (which allows anyone to be editor). This is not allowed unless authenticated.

Can anyone walk me through how to obtain whatever is necessary to do this? I've been struggling with API key vs Oauth2 vs service account, putting things in .json files, pasting in client_id, missing refresh tokens etc, etc, etc....

I Just want to (over)write mtcars on my current public google sheet.

This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.