We have this enabled already but still having this problem
Make sure you have all 3 variables set
Hello @CptPlastic and @MasterIBM, sorry to make an old post coming back, but im having the same issue
- Picker API enabled
- Sheet API enabled
- All 3 variables filled (and valid, because i also use the Google Auth with success)
I successfuly add the account, but when i need to select the sheet, i got the "The API developer key is invalid."
Did you try regenerating your key
Yes, generated 3 differents keys
Mine expired before and I ended up seeing this.
Hmm Iโm not sitting in front of my computer but when I am Iโll look at how my setup is and screenshot it for you.
Itโs been awhile since I had to touch that part of my configuration
Where do you see this ? Im on the credentials page but my key isnt restricted to anything
Then should be good to go
Yep i got everything right on that file, but still the error message
If you have all three permissions set it should work. Are you selfhosting the latest version of the main branch?
One other thing i thought of was the URL you have set is that an Actual domain? I know the have to be FQDN to work right with googles API
The key isnt even restricted for now
whats it say when you click manage
That it's enabled and usable by the key that i use on typebot
should work if thats the key and your domain is fully qualified
Google Sheets API
Google Picker API
Google Drive API
you might check to make sure all those are enabled
can you do me a fav and screenshot your .env file you can scrub the keys I just want to see something
hmm looks fine spaces are odd but should not matter
where do you host this at?
and are you able to console into the container?
If you mean checking the logs, there is nothing on it
no i mean like console into the running container and go to this path
root@92c249e7-5c52-40a4-af02-5f4c24d4ed8c:/app/code/builder/apps/builder#
node_modules package.json public server.js src
go in it look for _ENV.json
window.__ENV = {"NEXT_PUBLIC_GOOGLE_API_KEY":"XXX","NEXT_PUBLIC_VIEWER_URL":"https://candidature.XXX.io"}
but it shows your key right
the only thing I can think of is google bnlocking you for some reason
im on the same version also
Well, the Oauth work well, i can connect through google on the builder
So i don't think that google did blocked me
so when you select new account for the sheets block do you see
than it says something like
com already has some access
See the 4 services that nsnmindlabs.com has some access to.
Mmh no it simply validate the connexion and redirect me on the builder
thats where the hickup is then
that key is not passing any permissions
at least it would appear that way
Well, as you can see here, when i go to the google profile; i can see that my app do have the permissions for it on my account
Its not in english so its hard for me to read
It says "Your app has somes right on your google account"
I feel like this is something silly with the way your auth is setup
And then specify the google dreive read edit and delete, and the same thing for google sheet
- View your profile information
- View, modify, create and delete all your Google Sheets spreadsheets
- View, modify, create and delete only the specific Google Drive files you use with this application
but when you select a sheet its invalid
you have a google sheet in your googledrive right
im at a loss then without actually logging in and seeing your set up im not sure what else to try
If you are available i can screenshare you, but i don't want to take any more of your time
it should just simply work from what you shown
ok ready whenever you are
Oh there is no vocal channels here
Thanks again for your time on this