On importing a gsheets json [with selected gsheet authorized], the run query on page load does not function as expected
Steps To Reproduce
Create a new workspace, a new app, with Google sheets datasource, set to selected google sheets, and authorize it with a google sheet say Test1.
Create a query to Fetch Many Sheet rows, and bind this query result to a table.
Create another dummy page as well.
Export this application.
Import the above json into a new workspace and a new app
While importing, choose selected gsheets and point it to a different GSheet, say test2, save and authorize.
After import, On accessing the page with the above table, it shows data from the original sheet test1
Even if we browse between page 1 and page 2, to see if Run query on page load works to refresh data each time the page is loaded, the data from original sheet only is shown
Ideally it should show the data from the new sheet, or it should error out till we choose the correct sheet from the query dropdown
Only after we go to the query and choose the new sheet, run it again, then the data in the table gets updated.
Is there an existing issue for this?
Description
On importing a gsheets json [with selected gsheet authorized], the run query on page load does not function as expected
Steps To Reproduce
Ideally it should show the data from the new sheet, or it should error out till we choose the correct sheet from the query dropdown
Only after we go to the query and choose the new sheet, run it again, then the data in the table gets updated.
https://github.com/appsmithorg/appsmith/assets/101863839/16cf2a38-2ae3-4a05-a1e1-e027ee3c112f
Public Sample App
No response
Environment
Production
Issue video log
No response
Version
Cloud