google sheets not found, database not found

Hi all, I am using the custom functions within AI assistant but for some reasons despite the fact that I am properly authenticated with google it cannot find the google sheets (it did find it once, but it stopped) I have tried all the urls and permissions but it says it can't find the sheet. Same for the Buildship database, I have created a table and when I use get database I enter the collection name but it returns not found. Is the system down or something? thanks a lot for your help.

Solution

Hi @Stepan_Molchan, it is working for other user's as well. thedigitalpro - Hi everyone. Is anyone else hav.... Did logged out form the OAuth node, right? Could you please try on incognito or clearing cache too? As we tested from different accounts and is working fine.

Jump to solution

Robin_Sorakami_SakeOP•6/7/24, 12:41 PM

Here are some screenshots, thanks a lot!

PatriarkCL•6/19/24, 10:43 PM

@Gaurav Chadha same issue for me, can you help us?

Stepan_Molchan•6/20/24, 5:57 AM

Hi guys, I have the same issue with Google Docs

Gaurav Chadha•6/20/24, 6:15 AM

Hi @Stepan_Molchan, we are taking a look at this issue, will update with a fix soon.

GGaurav Chadha Hi @Stepan_Molchan, we are taking a look at this issue, will update with a fix s...

Stepan_Molchan•6/20/24, 6:20 AM

Good news, thank you. If you don't mind I'll tag you in another ticket - one more common problem

Gaurav Chadha•6/20/24, 6:21 AM

cool, sure.

Gaurav Chadha•6/20/24, 7:20 AM

Hey all, for now if you create a sheet using BuildShip (Create Sheet/Docs) node after authenticating it then it should work fine.

Note: We are working along with Google to get the issue resolved to allow access to manually created files too and it will take some time. Thanks you all for your patience.

Gaurav Chadha•6/20/24, 12:28 PM

Hey all, @Stepan_Molchan @PatriarkCL @Robin_Sorakami_Sake, We have made an update to fix this, can you logout and login from the OAuth node again and give it a try again.

GGaurav Chadha Hey all, @Stepan_Molchan @PatriarkCL @Robin_Sorakami_Sake, We have made an updat...

Stepan_Molchan•6/20/24, 6:43 PM

Gave it a try, logged out/in, even tried log in different account, but still have the same error

Solution

Gaurav Chadha•6/21/24, 7:47 AM

PatriarkCL•6/21/24, 4:38 PM

Thanks a lot @Gaurav Chadha , now i try to test the node and keep loading the test :/

Gaurav Chadha•6/21/24, 4:39 PM

Run a full workflow test it should work then, we are tracking the individual node testing issue

PatriarkCL•6/21/24, 4:45 PM

ok, am tested from widget assistant and the data then shiow me is from gtp file, not from gsheet file

PatriarkCL•7/3/24, 6:41 PM

@Gaurav Chadha sorry man, it's not working for me yet, am tryed from incognit windows and nothing, do you have any idea?

PatriarkCL•7/3/24, 6:46 PM

The problem is Get Sheet node

PPatriarkCL @Gaurav Chadha sorry man, it's not working for me yet, am tryed from incognit wi...

Gaurav Chadha•7/3/24, 8:08 PM

What error is it giving, now? Did you tried out with full worklow test?google sheets not found, database not found.

GGaurav Chadha What error is it giving, now? Did you tried out with full worklow test?https://...

PatriarkCL•7/3/24, 9:44 PM

"Cannot read properties of undefined (reading 'map')", yes tried out full workflow

PPatriarkCL "Cannot read properties of undefined (reading 'map')", yes tried out full workfl...

Gaurav Chadha•7/4/24, 7:33 AM

@PatriarkCL can you please submit your it via in-app support this doesn't seems related to the original issue of permission, it is something with the missing/incorrect values. https://docs.buildship.com/support-messages

Support Messages – BuildShip

A unified resource to start building your backend with low-code. Dive into triggers, nodes, and step-by-step guidance to jumpstart your workflow creation.