The Scenario
Someone on your team built a 50-city target list for a PropTech expansion into secondary French markets. It lives in column A of your Excel workbook — commune names, no IDs, no Melo metadata. The brief was to launch Melo saved searches for each city by end of the month. You inherited the list two days ago when that person took a new role elsewhere.
You have no idea which of these 50 cities already have saved searches in Melo and which are completely uncovered. Starting from scratch would mean opening Melo and checking each commune by hand.
The bad version:
- Open the Melo saved searches interface and read through your existing searches, writing down which cities are mentioned in each one's location filter.
- Go back to your target list and manually compare the two sets — city by city, with the Melo tab open in one window and your sheet in the other.
- Discover halfway through that one saved search covers three cities with a radius filter, so you are not sure if it counts as covering each of them individually or not.
You are supposed to be building the missing searches, not doing the audit that tells you what is missing. And the month is not getting longer.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Melo, fetches your saved searches and the full city index, and can run the comparison against your target list directly in the sheet.
Fetch all Melo cities and all my saved searches, then for each city name in column A of this sheet, check whether any saved search covers that city and write 'covered' or 'gap' in column B
What You Get
- Column B populated for every row in your target list — "covered" where a matching saved search exists, "gap" where nothing covers that city.
- The comparison runs against actual Melo data, not your memory of what you set up.
- Cities that appear in multi-location saved searches are correctly flagged as covered.
- Gaps are immediately scannable — you can sort column B to pull all uncovered cities to the top and start building searches from there.
What If the Data Is Not Quite Ready
The city names in your target list have different spellings or accents than Melo uses
Compare the cities in column A of this sheet against the Melo city list — normalize both sets by removing accent characters before matching, then write the matched Melo city name in column C and 'gap' in column B for any city that could not be matched even after normalization
You need the coverage result in a separate tab with the gaps extracted
Fetch all my Melo saved searches and compare their location filters against the city list in Sheet1 column A — write a Covered-Cities tab with only the matched cities and their Melo city ID, then write a Gaps tab with the unmatched cities so I can use it as the input for creating new searches
You want to weight the gaps by how many properties Melo has listed in each city
For every city in column A flagged as 'gap' in column B, fetch the Melo listing count for that city and write it in column C, then sort the gap rows by column C descending so I prioritize creating searches for the highest-volume markets first
Pull the full audit, normalize city names, flag gaps, sort by listing volume, and add a summary count — all in one shot
Fetch all Melo cities and all my saved searches, compare them against the city list in column A with accent-normalized matching, write 'covered' or 'gap' in column B, fetch listing counts for gap cities and write them in column C, sort gap rows by column C descending, and put a summary in cell E1 showing total cities, covered count, and gap count
Running the full audit and prioritization in one prompt means you go from an inherited spreadsheet to a ready-to-execute search backlog in minutes.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you are tracking a French real estate market expansion — ask SheetXAI to audit your Melo search coverage and you will know exactly where the gaps are before you build a single new search. Also see how to export all your saved Melo searches or the Melo integration hub for more tasks.