[Bug]: Google Sheet - Switching between datasources does not fetch the updated list of spread sheets and sheet names

[pranavkanade]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

Both the data sources show the same list of spreadsheets. Although, the list corresponds to Design_Data and not to the Product_data datasource.

Steps To Reproduce

1. Create two google sheet data sources
2. Create an API
3. When you go on to select the spreadsheet you'll see the list
4. Change the datasource
5. You'll see the same list and not the updated list corresponding to the new datasource

Public Sample App

No response

Version

cloud - v1.8.4

[prapullac]

Observed the Internal server error on Authorisation hence moving it into Blocked state

[prapullac]

Working as expected on the DP