Show points on a map based on column of a google spreadsheet

Hello,

I'm trying to develop an app and I would like to show a map with points.

I got a google spreadsheet with one column for "Longitude" and one column for "Latitude", each represent one point.

My spreadsheet is connected to retool. But I'm struggling to show my points on the map, I've tried the name_spreadsheet.data, but nothing is showing off.

Thanks in advance for your help !

The points data should be formatted as an array of objects, and it should include the keys "latitude" and "longitude" (lower case only, no trailing spaces)

If you have capital Ls on your keys (Longitude instead of longitude), or some other syntax issue, you'll need to use JS to refactor your data. Here's an example where I'm removing a trailing space on latitude and making it lower case: