Where growers need a cold store

What it does

Every month: each of your growers, the cold stores and warehouses within 25 km, the fewest first, road incidents on the way, scored by xMap AI for a new packhouse, approved, a report, emailed and mapped.

In one sentence: Monthly on the 1st at 08:00, take your table, count the cold storage facilities and warehouses within 25 km of each, sort them by nearby_count, find road closures, roadworks and other incidents, count who lives around, score and rank them with xMap AI, keep those where fit score ≥ 60, wait for approval, write a report with xMap AI, then email the list to you and show them on a map.

Why it is useful

Produce lost for lack of cold storage is money lost. This flow shows where growers are far from any cold store, with roads and workforce.

Who it is for

Agriculture & food supply. Growers, agri suppliers and food supply teams watching fields and weather and finding buyers and dealers. Every use case for agriculture & food supply

Best use cases

• A cold chain investor
• A food exporter
• An agriculture ministry

What each run gives you

• A report
• An email
• A map

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 300 minutes each time; it runs about 1 time a month, so it saves about 5 hours a month (an estimate). It is advanced: 12 blocks.

The flow, block by block

1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
2. Our growersYour 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. Cold stores 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. Fewest cold stores 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.
5. Road incidents on the wayxMap data · Traffic incidentsRoad closures, roadworks and other incidents on online maps right now, with where they are.
6. 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).
7. Rate each grower area with xMap AIxMap AI · xMap LLMTell the AI what to do in plain words.
8. Fit score ≥ 60Logic · FilterKeeps only the items that match a rule.
9. Approve the areasLogic · ApprovalStops the run until someone says yes.
10. Write the cold chain reportxMap AI · xMap LLMTell the AI what to do in plain words.
11. Email me the listAction · EmailSends one email per run with all the items, or one email per item.
12. Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.

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.