I tried using a google sheet from a shared google drive in appsmith, but it didn't work. I created a new datasource with Read / Write / Delete | Selected google sheets, authorized appsmith and selected this google sheet:
I received a toast saying 'Authorization was successful', but the datasource is empty - there are no sheets and no queries:
I then copied this same sheet to my private google drive and it worked.
Using a private drive is not acceptable for us though, because of company policy the sheet has to reside in a shared drive, so this is a problem for us.
Steps To Reproduce
Create a shared drive (requires google workspace)
Add a user to the drive with any permission level (it doesn't work even with the most privileged Manager role)
Create a sheet in the shared drive
Add a google sheet datasource in appsmith, select Read / Write / Delete | Selected google sheets
Select the sheet from the shared drive
it shows a success toast, but it doesn't work
Public Sample App
(no link, because reproduction requires google workspace)
ukasiu
commented
6 days ago
Is there an existing issue for this?
Description
I tried using a google sheet from a shared google drive in appsmith, but it didn't work. I created a new datasource with
Read / Write / Delete | Selected google sheets, authorized appsmith and selected this google sheet:I received a toast saying 'Authorization was successful', but the datasource is empty - there are no sheets and no queries:
I then copied this same sheet to my private google drive and it worked.
Using a private drive is not acceptable for us though, because of company policy the sheet has to reside in a shared drive, so this is a problem for us.
Steps To Reproduce
Managerrole)Read / Write / Delete | Selected google sheetsPublic Sample App
(no link, because reproduction requires google workspace)
Environment
Production
Severity
High (Blocker to building or releasing)
Issue video log
No response
Version
Self-hosted 1.34