I have built a retool app with google sheets as database and it works well in preview mode.
But it doesn't works when I am accessing it using Public URL.
The Query don't fetch data as you can see in the image below.
The data isn't fetched and "No options" are shown
Also, this warning message is shown where I open the "Share Dialog Box"
I have shared access to the google sheets to the gmail acc through which I trying fill form via public link
UPDATE:
I created a new google sheet resource(I am using the same google sheets with the same permissions)
But now when I open the share dialog box I am seeing the following:
Given that I just generated a new resource, I don't understand why the feature is suddenly excluded from my plan.
How should I go about in this case?
Any help is appreciated.