[Bug]: On importing a gsheets json [with selected gsheet authorized], the run query on page load does not function as expected

[btsgh]

Is there an existing issue for this?

• I have searched the existing issues

Description

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.

Screen.Recording.2024-01-08.at.6.51.20.PM.mov

Public Sample App

No response

Environment

Production

Issue video log

No response

Version

Cloud

[rohan-arthur]

marking it as (at least) medium effort since import app flow has historically been a problematic area causing regressions.