I’m new to Bubble, and here’s what I’m trying to do: I have a Google Sheet with ~1500 rows of data, each row representing one map location that I want to show on a map in my Bubble app. The Sheet will get updated constantly, so I want Bubble to query the Sheet each time it loads (not do manual uploads).
I was successfully able to set up Bubble to extract data from the Google Sheet via the API connector:
For reference, I am doing a GET to:
https://spreadsheets.google.com/feeds/list/{spreadsheet-id}/1/public/values
My Sheet has address data already pre-populated with latitude and longitude. Here’s an example sheet with just two rows of data:
What I can’t figure out is how to access either the address or the lat/long from the Sheet in the map.
Here’s how I’ve set up the API connector:
Here’s how I’ve set up my map:
The map displays no pins (defaults to NYC). What’s weird is that when I create a repeating group to show that I am actually extracting data from the API call, I am able to easily pull out the Sheet column labelled “title”, but one formatted address comes out as “Antarctica” and the other one is blank.
I’ve tried the calculated address approach talked about in other posts, and haven’t been able to make that work from data extracted directly via the API Connector.
I appreciate any advice… thanks.