[Bug]: Google sheets datasource not working with shared drives

[Akatroj]

Is there an existing issue for this?

• I have searched the existing issues

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

1. Create a shared drive (requires google workspace)
2. Add a user to the drive with any permission level (it doesn't work even with the most privileged Manager role)
3. Create a sheet in the shared drive
4. Add a google sheet datasource in appsmith, select Read / Write / Delete | Selected google sheets
5. Select the sheet from the shared drive
6. it shows a success toast, but it doesn't work

Public 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

[ukasiu]

Any progress on this one?

[sonali-humanedge]

@Nikhil-Nandagopal @carinanfonseca @rohan-arthur What is the status for this issue?

[rohan-arthur]

@sonali-humanedge @ukasiu , this is still a limitation with the google sheets integration, and we have not currently planned it on our roadmap.
I will check with the team and update here on plans for a fix.

[sonali-humanedge]

@rohan-arthur The alternative that was suggested was to copy the sheet to a personal drive. However, the data in question is the company's IP and cannot be moved to any user's personal drive.
I request to prioritise the issue. Also please mention in the documentation about this limitation. This would have been an important information to know before integrating appsmith.

[sonali-humanedge]

Hey @rohan-arthur any progress on this issue?

[christianauz]

Hello team,
I am facing this issue, The data source page remains empty, and doesn’t show individual sheets or data previews. This doesn’t happen when the file is in ‘My Drive’.
I can run queries by manually entering the spreadsheet URL in JS code in 'Queries', but adding the URLs in code, for different environments (dev, prod, stage) complicates keeping files separate across instances and same git code repository.