Rating scorecard for my clinics

What it does

Every Sunday: each of your clinics found on the map with its rating and number of reviews, rated by xMap AI against your other clinics, the weakest first, emailed and kept in a sheet.

In one sentence: Mondays 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 email the list to you and add row in Google Sheets.

Why it is useful

A clinic whose rating slips is losing patients to the next one. This flow puts every clinic's rating and number of reviews side by side each week, so the quality team knows where to look.

Who it is for

Healthcare & pharma. Clinic groups, pharma companies and medical suppliers planning coverage, finding partners and watching their network. Every use case for healthcare & pharma

Best use cases

• A clinic group's quality team
• A dental chain's operations manager
• A hospital patient experience office

What each run gives you

• A scorecard by email
• A Google Sheet over time

The time it saves

Mondays at 08:00. Doing the same work by hand takes about 120 minutes each time; it runs about 4 times a month, so it saves about 8 hours a month (an estimate). It is medium: 7 blocks.

The flow, block by block

1. Every MondayTrigger · ScheduleStarts the flow on a timetable.
2. My clinicsYour 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. Find each clinicxMap data · Map business scanFinds businesses on online maps live: name, category, rating, address, phone, website and whether it is open.
4. How patients rate each clinic, with xMap AIxMap AI · xMap LLMTell the AI what to do in plain words.
5. 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. Email me the listAction · EmailSends one email per run with all the items, or one email per item.
7. Keep the scorecard in a sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online

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.