Working-age people near each site, for local hiring
Working-age people near each site, for the local content report.
What it does
Every year: the working-age people living within 8 km of each site in your table, summed up by xMap AI as the local hiring section of the local content report.
In one sentence: Monthly on the 1st at 08:00, take your table, count who lives around, work out new fields, write a report with xMap AI, then create file from text in Google Drive and email the list to you.
Why it is useful
Governments ask how many local people a mine can hire. The numbers around each site answer it.
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 mining company’s HR team
- A local content officer
- An oil and gas operator
What each run gives you
- A report in Google Drive
The time it saves
Monthly on the 1st at 08:00. Doing the same work by hand takes about 180 minutes each time; it runs about 1 time a month, so it saves about 3 hours a month (an estimate). It is medium: 7 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.
- Who lives aroundxMap data · DemographicsWho lives in an area: the number of residents, men and women, and nine age groups, from xMap’s population grid (hexagons of about 0.1 km², about 100 countries).
- Working-age peopleLogic · Calculated fieldAdds fields worked out from the others: a number, a text or a yes/no.
- Write the local hiring sectionxMap AI · xMap LLMTell the AI what to do in plain words.
- Save it to Google DriveApp · Google DriveCloud storage and file backup
- 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
- Build your first flow in ten minutes: From a blank page to a flow that emails you a ranked list every morning.
- 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.
- Enrich a list once: A CSV of addresses or companies back with phone, website, rating and an AI score.
- Count what is around each of your places: Competitors, footfall magnets or services within a distance of each site.
- 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.
- Site selection: Choosing where to open a store, branch, clinic or facility.
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.