Sports grounds and pools near my schools for PE

Sports grounds and pools near each school, to rent for PE.

MediumMonthlyAI

Education & trainingEducationSports

Use this template

What it does

Every year: sports complexes, swimming pools and football pitches within 3 km of each school in your table, the best-rated first, as places to rent for physical education.

In one sentence: Monthly on the 1st at 08:00, take your table, find sports complexes, swimming pools and soccer fields nearby, remove duplicates, clean up their categories, then add row in Google Sheets and email the list to you.

Why it is useful

Many schools have no pool or pitch. Renting one close by makes PE possible.

Who it is for

Education & training. Schools, nurseries, universities and training companies planning campuses, enrolment and partners. Every use case for education & training

Best use cases

  • A school group
  • A school district
  • A PE programme

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. Our schoolsYour 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. Sports places nearbyxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
  4. Each place onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
  5. Sort by kindxMap AI · Place classifierAssigns clean categories and merges duplicate places.
  6. Update the PE venues 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.

How to set it up

More for Education & training