[Bug]: In upgraded instance - GSheets does not list the sheets in the query, though DS shows up as authorized

[btsgh]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

In upgraded environment - GSheets does not list the sheets in the query, though DS shows up as authorized

Steps To Reproduce

1. On an upgraded environment, open an existing application with gsheet authorized datasource and queries
2. On trying to run an existing gsheet query, it errors out with Missing required field 'Spreadsheet Url', and the spreadsheet dropdown is empty
3. When we browse to the Gsheet DS, it shows up as a authorized DS, and has no information whatsoever asking user to re-authorize. Expected behavior: There should be an error message on running the query informing user to authorize, and the DS page should have a message to indicate ds is not authorized.

URL - https://release-ee-https.appsmith.com/ Appname - Bug Verifications Page name - UQI DS Observed - Changmeds .

Public Sample App

No response

Environment

Release

Issue video log

No response

Version

Release

[sribalajig]

@btsgh what does "Upgraded environment" mean?

[Irongade]

@btsgh Please what do you mean by upgraded environment?

[btsgh]

We have an environment with an older version of Appsmith. It has a few applications. We upgrade it to the latest release version on which we are conducting regression. Now we try to work with gsheets on the application - @sribalajig @Irongade - sorry for the extremely delayed response on this - but hope this helps.

Meanwhile, I have been in touch with @sneha122 regularly about this issue, and after saving and authorizing the sheet once, the issue cannot be reproduced. Before closing out the issue, we are trying on last thing, I have loaded the environment with another gsheets app, and will test it one last time during the next regression, to take a call on closing it out. cc: @sneha122

[sneha122]

@btsgh one release promotion happened on May 22, 2023. Can we please try and check if this issue is still reproducible? If not can we please close it?

[btsgh]

@sneha122 That was the image that I tested it on - the next one will happen this week [I should have an environment tomorrow to test it on]. Can we wait a day or two and then close it?

[rohan-arthur]

@btsgh @sneha122 sorry to dig up an old issue but would you please confirm if this is still valid?

[sneha122]

As far as I remember, we saw this issue 1/2 times in upgraded environment on Aparna's Machine but didnt see it much later on @btsgh Please confirm