In general, the Grid expects a valid JSON. It does not matter if the JSON is coming from Google Sheet, local storage or any other API.
Regards,
Stefan
Progress Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items