How customers rate body shops in our repair network

What it does

Every quarter: the body shops in your repair network (your table), found on the map and judged by xMap AI from their rating and reviews, the weakest first, for the network manager.

In one sentence: Monthly on the 1st at 08:00, take your table, look each one up on online maps, score and rank them with xMap AI, sort them by review_score, then add row in Google Sheets and email the list to you.

Why it is useful

A weak body shop hurts the insurer’s reputation. The network manager reviews the weakest first.

Who it is for

Insurance. Insurers, brokers and agents preparing for storms, building distribution, checking claims and growing commercial and health books. Every use case for insurance

Best use cases

• An insurer’s repair network manager
• A claims management company
• A fleet insurer

What each run gives you

• A Google Sheet

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 60 minutes each time; it runs about 1 time a month, so it saves about 1 hours a month (an estimate). It is medium: 7 blocks.

The flow, block by block

1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
2. Repair network body shopsYour data · My dataBrings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
3. Each shop on the mapxMap data · Map business scanFinds businesses on online maps live: name, category, rating, address, phone, website and whether it is open.
4. Rate how customers see them, with xMap AIxMap AI · xMap LLMTell the AI what to do in plain words.
5. The weakest firstLogic · Sort and limitPuts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.
6. Update the network quality sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
7. Email me the resultsAction · EmailSends one email per run with all the items, or one email per item.

Every block can be changed after you use the template: the city, the type of place, the score, where the results go.

Use it now

Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.