Port activity snapshot

What it does

Every day: the ships in a port area (live AIS), grouped by type and whether they are moving, a short activity note from xMap AI, saved to a sheet.

In one sentence: Every day at 12:00, in the area drawn on the map, watch the ships, write a report with xMap AI, then add row in Google Sheets and email the list to you.

Why it is useful

Port activity tracks trade before official figures. A daily snapshot builds a series you can use.

Who it is for

Investors, analysts & consultants. Investors, analysts and consultants who need location numbers they can trust, on a schedule. Every use case for investors & consultants

Best use cases

• A commodity analyst
• A shipping investor
• A trade economist

What each run gives you

• A note by email
• A data sheet

The time it saves

Every day at 12:00. Doing the same work by hand takes about 20 minutes each time; it runs about 30 times a month, so it saves about 10 hours a month (an estimate). It is easy: 6 blocks.

The flow, block by block

1. Every day at noonTrigger · ScheduleStarts the flow on a timetable.
2. Rotterdam port areaWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
3. Ships in the portxMap data · Ships (AIS)Ships at sea or in port right now, from AIS (the signal ships send with their position, speed and heading; live from AISStream): every vessel heard in the Area of interest before this block, or around a point.
4. Write the activity notexMap AI · xMap LLMTell the AI what to do in plain words.
5. Save the snapshotApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
6. Email me the listAction · 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.