[Bug]: Google Sheets Fetch Rows method returns empty string when cell value contains valid JSON object

[GreenFlux]

Is there an existing issue for this?

• I have searched the existing issues

Description

When using the Google Sheets Fetch Many: Sheet Rows method, the API returns an empty string for cells that contain a valid JSON object.

Steps To Reproduce

1. Set up a Fetch Many: Sheet Rows API and enter some plain text data in the sheet. Verify all rows are returning data correctly.
2. Enter a JSON Object in one cells of the sheet. e.g.{"label": "Blue","value": "BLUE"}
3. Rerun the query and note the empty string returned instead of the JSON object.
4. Add quotes around the JSON object in the cell and run API again. Note the value is now returned normally.

Public Sample App

https://app.appsmith.com/app/gsheets-json-bug/page1-62ed20cbb2f8027edfbee6aa

Version

Appsmith v1.7.11-SNAPSHOT (Cloud)