[Bug]: Other rows with alphanumeric values are not visible if first row value is a number on gsheet

[chandannkumar]

Is there an existing issue for this?

• I have searched the existing issues

Description

When first row of a column is number type then, other rows with alphanumeric values are not visible in appsmith gsheet query.
Only rows with number are visible in that column

Steps To Reproduce

1. Create a new Goggle sheet query
2. Add data in such a way that a column should have both number and alphanumeric values
3. Set the 1st record as number and rest with alphanumeric values
4. Fetch the Google sheet record in appsmith using query
5. Observe that only 1st row record is visible and rest are not

Public Sample App

No response

Environment

Production

Issue video log

https://www.loom.com/share/592e9d7eb7f94df89d794feb2015bde0

Version

Cloud/ Production

[sumitsum]

Related: #24166