Open JustGottaCAT opened 8 months ago
the API has not been enabled for the client project
It's hard to say what's going wrong, but currently my money is on this ☝️
Is the Sheets API definitely enabled for your oauth client?
I'm having the exact same issue. How do I enable the sheets api in my oauth client?
My company has an internal Google domain and I'm attempting to read a Google spreadsheet from it. I keep getting permission errors when I try to use
gs4_auth()
orgs4_auth_configure()
.If I use![image](https://github.com/tidyverse/googlesheets4/assets/39129228/e7f652fb-4449-4eaa-afe7-70d43228faab)
gs4_auth()
I am taken to the authorization screen, choose "Yes", and then get this error:I allowed "Tidyverse API Packages" access via admin.google.com > Security > Access and data control > API Controls (for some reason there were 6 IDs). My company's domain is "Trusted and block-exempt".
gs4_auth()
still did not work.I also tried generating an API key and client ID for the Google Sheets API and used that:
But I get a permission error when I actually try to read in a sheet:
Eventually I would like this all done using encrypted service account credentials and would like to publish an Rmd with my code on our internal Posit Server, but I figure that is down the line if I can't even get the above to work.