The Scenario
A real estate analyst at a boutique agency is putting together a client-facing property report for 30 listings. The sheet has addresses and coordinates. The client specifically asked for a visual map thumbnail next to each property so they can orient themselves without clicking through to a separate map tool. The analyst has never worked with a static map API. It is Thursday afternoon and the report goes out Friday morning.
The bad version:
- Read through Geoapify's static map API documentation to find the right endpoint format, understand the zoom, width, height, and marker pin parameters, and manually construct a URL string for each of 30 properties.
- Paste each URL into a browser to verify it renders correctly, discover that three properties have their coordinates transposed and the map points to the ocean, fix those rows, and rebuild the URLs.
- Copy all 30 URLs into the report spreadsheet in column D and then manually insert each one as a hyperlink or IMAGE formula.
The report template is waiting. The analyst's Friday morning is already packed.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet. It reads the coordinates, constructs the Geoapify static map image URL for each location with the parameters you specify, and writes the URL into the correct column.
For each lat/lon in this sheet, generate a Geoapify static map image centered on that location with a marker pin and write the image URL into column D
What You Get
- Column D receives a valid Geoapify static map URL for each property row.
- Each URL includes a centered marker pin at the property coordinates.
- The URLs are ready to use as IMAGE formula arguments in the sheet or to embed directly in a Google Slides or Docs export.
What If the Data Is Not Quite Ready
The coordinates are in a single column formatted as "lat,lon" instead of two separate columns
Split the coordinate string in column C into lat and lon, then generate a Geoapify static map URL for each property at 400x300 resolution with a marker pin and write the URL into column D
The map size should vary based on a column in the sheet
For each row in the Listings tab, generate a Geoapify static map URL using the coordinates in columns C and D — use the width and height from columns E and F, add a marker pin, and write the URL into column G
Some properties should display a different zoom level based on the property type
Generate Geoapify static map URLs for all properties in the Listings tab using lat/lon in columns C and D — use zoom level 16 for rows where Type is Residential and zoom level 14 for rows where Type is Commercial, and write the URL into column E
Geocode addresses, generate map URLs at two zoom levels, and add IMAGE formulas for the report
For any row in the Listings tab where columns C and D are blank, geocode the address in column B with Geoapify to get coordinates. Then generate two static map URLs per property: one at zoom 15 for the neighborhood view and one at zoom 18 for the street-level view. Write the zoom-15 URL into column E and the zoom-18 URL into column F. Add an IMAGE formula in column G that embeds the zoom-15 map.
One instruction handles the geocoding fallback, dual-zoom URL generation, and formula insertion together.
Try It
Get the 7-day free trial of SheetXAI and open any property sheet, field site list, or event venue tracker with coordinate data and ask it to generate the map thumbnails. See the related spoke on finding nearby points of interest, or return to the Geoapify hub.