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 workbook 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 Excel workbook. 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 workbook.
Pull all saved Melo searches and extract every unique city mentioned in their location filters into a deduplicated list in a new 'Covered Cities' worksheet, then compare against the cities in Sheet1 column A and flag missing ones in column C
What You Get
- A new "Covered Cities" worksheet with every unique city extracted from your saved searches' location filters, deduplicated.
- Column C in Sheet1 flagged for any target city not found in the covered set.
- The comparison runs against actual Melo data, not your memory of what you set up.
- Cities that appear in multi-location searches are correctly extracted and deduplicated.
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 Sheet1 column A against the Melo city list — normalize both sets by removing accent characters before matching, then write the matched Melo city name in column B and 'gap' in column C for any city that could not be matched even after normalization
You need the gaps extracted into a separate worksheet for the team to action
Fetch all my Melo saved searches and compare their location filters against the city list in Sheet1 column A — write a Covered-Cities worksheet with only the matched cities and their Melo city ID, then write a Gaps worksheet 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 Sheet1 column A flagged as 'gap' in column C, fetch the Melo listing count for that city and write it in column D, then sort the gap rows by column D 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 Sheet1 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 workbook to a ready-to-execute search backlog in minutes.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook 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.