Hospitals near heliports, for air ambulance partnerships

Hospitals near each heliport, with the medical director.

MediumMonthly

Airports, airlines & aviationAviationHealth

Use this template

What it does

Every year: hospitals within 30 km of each heliport in your region, the largest first, with the medical director from Apollo, for the air ambulance service’s partnerships team.

In one sentence: Monthly on the 1st at 08:00, in Zurich, find heliports in the area, find hospitals nearby, remove duplicates, find the Medical Director and Head of Emergency with Apollo, then create contact in HubSpot and email the list to you.

Why it is useful

An air ambulance service works with hospitals it can land near. The medical director is the partner.

Who it is for

Airports, airlines & aviation. Airports, airlines, flight schools, maintenance and aviation services planning routes, partners and passengers’ journeys. Every use case for airports & aviation

Best use cases

  • An air ambulance service
  • A medical evacuation company
  • A health ministry

What each run gives you

  • New leads in HubSpot

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: 8 blocks.

The flow, block by block

  1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
  2. Our regionWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
  3. HeliportsxMap 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. Hospitals 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.
  5. Each hospital onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
  6. Medical director from ApolloYour data · ApolloThe people to talk to at each company, and the company’s details, from your own Apollo account (apollo.io): decision makers by job title with their LinkedIn and work email; or the company’s size, industry, revenue and LinkedIn page; or a person from their email.
  7. Add them to HubSpotApp · HubSpotPowerful CRM that offers tools for sales, customer service, and marketing automation.
  8. 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 Airports, airlines & aviation