The Scenario
You are a property manager overseeing forty properties. A new vendor needs a static satellite map image for each property to embed in a PDF report. Your data is in an Excel workbook: latitude in column B, longitude in column C. The vendor asked for image URLs. They need them by noon.
You have never used the Mapbox Static Images API.
The bad version:
- Read the API documentation, learn the URL path structure: style, coordinates, zoom, dimensions.
- Build a URL string for one property, test it in a browser.
- Write a formula across forty rows to construct URLs from the coordinate columns.
- Discover row twelve has swapped lat and lon — the image shows the middle of the Atlantic Ocean.
The vendor's deadline is three hours away.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the coordinates, constructs Mapbox Static Images API URLs with the right parameters, and writes valid URLs directly into column D.
For each row with latitude in column B and longitude in column C, generate a Mapbox static satellite map image at zoom 15 and write the image URL into column D.
What You Get
- Column D with a valid Mapbox Static Images URL for each property at satellite style, zoom 15, 600x400 pixels.
- Any row with out-of-range coordinates gets INVALID COORDS in column D.
- URLs are ready to paste into the vendor's template without further formatting.
What If the Data Is Not Quite Ready
Urban properties should use street map style, rural ones satellite
For each row, generate a Mapbox static map image URL using satellite style if column E is RURAL or street style if column E is URBAN, both at zoom 15. Write the URL into column D.
Eight rows have addresses instead of coordinates
For any row where columns B and C are empty but column A has an address, geocode the address using Mapbox and fill in latitude and longitude in columns B and C. Then generate a Mapbox static satellite image URL at zoom 15 for all rows and write it into column D.
The vendor changed the required image size to 400x300
For each row with latitude in column B and longitude in column C, generate a 400x300 Mapbox static satellite map image URL at zoom 15 and write the URL into column D.
Full pipeline: validate coordinates, geocode missing ones, generate image URLs, and flag swapped coordinates
First, check all rows for obviously swapped coordinates — latitude values greater than 90 likely mean coordinates are switched. Flag those rows in column F as COORDS SWAPPED. For rows with empty columns B and C, geocode from column A using Mapbox and fill in coordinates. Then generate a Mapbox static satellite image URL at zoom 15 for each row and write into column D. For COORDS SWAPPED rows, write SKIP in column D.
One prompt handles coordinate validation, fallback geocoding, URL generation, and skip-flagging.
Try It
Get the 7-day free trial of SheetXAI and open your property workbook — bring the lat/lon columns and ask SheetXAI to generate Mapbox static image URLs. The isochrone article covers catchment area analysis for those same properties. The Mapbox hub has the full list of geographic tasks.