Hotels and campgrounds for contractors near remote sites
Places to stay near each remote site, for shutdown contractors.
What it does
Before each shutdown: hotels and campgrounds within 50 km of each site in your table, the best-rated first, in a sheet for the contractor housing team.
In one sentence: Monthly on the 1st at 08:00, take your table, find hotels, campgrounds and motels nearby, remove duplicates, then add row in Google Sheets and email the list to you.
Why it is useful
Shutdowns bring hundreds of contractors at once. Housing is booked fast from a ready list.
Who it is for
Mining, oil & gas. Mining companies, oil and gas operators and their suppliers keeping remote sites safe, supplied and on good terms with their neighbours. Every use case for mining, oil & gas
Best use cases
- A mine shutdown planner
- An oil and gas contractor
- A workforce accommodation company
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 45 minutes each time; it runs about 1 time a month, so it saves about 1 hours a month (an estimate). It is easy: 6 blocks.
The flow, block by block
- On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
- Our sitesYour 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.
- Places to stay 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.
- Each place onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
- Update the housing sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
- 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
- The xMap Flows browser extension: what is around this business: On a company’s website or a place on a map, one click shows its market and the AI employees to hire for it.
- Build your first flow in ten minutes: From a blank page to a flow that emails you a ranked list every morning.
- What xMap remembers about your company: Your city, industry and what you sell, filled in for you and always yours to change.
- Ask the map a question: How many of a kind of place, how many people for each, and where the gaps are, answered on the spot.
- How to score candidate store sites: Compare sites on residents, competitors and neighbours, with an AI score and a reason.
- Location intelligence: Using where things are, and what is around them, to make business decisions.
- POI data (points of interest): Records of places such as shops, clinics and offices, with their category, position and details.
More for Mining, oil & gas
- Mining companies graded as equipment buyers: Mines and quarries graded as equipment buyers, with procurement.
- Quarries and concrete plants as customers: Quarries and concrete plants scored as equipment customers.
- Local businesses for our supplier development programme: Local businesses graded as suppliers for the supplier development programme.
- Gas companies and industrial gas suppliers for B2B sales: Gas companies scored as distribution partners, with the commercial manager.
- ESG section: people, services and land around each site: People, services and land around each site, as an ESG section.
- Heat at remote sites: work and rest cycles: Tomorrow’s heat at each remote site, with a work-rest cycle.