Build a mileage log from your calendar
Each business trip with its date, purpose, route and distance, and the total claim at your rate.
- You start it: When you start it
What it does
The task
Read my Google Calendar events for month that have a location away from my office at office address. Skip events marked private or online. For each event, get the driving distance from the office and back in Google Maps. Put each trip in the Google Sheet sheet url with the date, the purpose from the event title, the route and the distance. Add the total distance and multiply it by the rate rate.
- It works in Google Calendar, Google Maps and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- It runs once, when you start it.
What you give it
| Blank | What to give | Example |
|---|---|---|
| month | The month to log | October 2026 |
| office address | Your office address | Am Wall 120, 28195 Bremen |
| sheet url | The Google Sheet for your mileage log | https://docs.google.com/spreadsheets/d/1Mileage2026 |
| rate | Your rate per kilometer or mile | 0.30 EUR per km |
What you get back
An example run with the example values above. Your run uses your own data.
October 2026: 9 trips, 412 km
| Date | Purpose | Route | km |
|---|---|---|---|
| 2 Oct | Site visit, Halden Group | Office to Halden Group, Hamburg, and back | 238 |
| 8 Oct | Workshop, Brightleaf | Office to Brightleaf, Oldenburg, and back | 96 |
| 15 Oct | Supplier meeting, Printwell | Office to Printwell, Delmenhorst, and back | 32 |
... 6 more trips, 46 km
Total: 412 km x 0.30 EUR = 123.60 EUR
Saved to "Mileage 2026", tab October.
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 4 blanks
Type month, office address, sheet url and rate. Tab moves to the next blank.
- 03
Run it
Run sends it to the agent. Follow each step in the panel, and stop it at any time.
From the terminal
cuiar exec "Read my Google Calendar events for October 2026 that have a location away from my office at Am Wall 120, 28195 Bremen. Skip events marked private or online. For each event, get the driving distance from the office and back in Google Maps. Put each trip in the Google Sheet https://docs.google.com/spreadsheets/d/1Mileage2026 with the date, the purpose from the event title, the route and the distance. Add the total distance and multiply it by the rate 0.30 EUR per km."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool run_task to run my "Build a mileage log from your calendar" template with month = October 2026; office address = Am Wall 120, 28195 Bremen; sheet url = https://docs.google.com/spreadsheets/d/1Mileage2026; rate = 0.30 EUR per km.Setup for other agents: AI agents.
The tool call
{
"name": "run_task",
"arguments": {
"task": "Read my Google Calendar events for October 2026 that have a location away from my office at Am Wall 120, 28195 Bremen. Skip events marked private or online. For each event, get the driving distance from the office and back in Google Maps. Put each trip in the Google Sheet https://docs.google.com/spreadsheets/d/1Mileage2026 with the date, the purpose from the event title, the route and the distance. Add the total distance and multiply it by the rate 0.30 EUR per km."
}
}Related templates
All finance templatesOps
Review your recurring meetings
Each repeating meeting with its cost in hours, its declines and its agenda, and advice to keep, shorten or cancel.
You start it: When you start it- Google Calendar
- Google Sheets
Data
List local businesses with their contacts
Name, address, phone, website, rating and e-mail for each business.
You start it: When you start it- Google Maps
- Google Sheets
Data
Check and complete business addresses in a sheet
Each business address checked on the map, with the postcode, the coordinates and a status for each row.
You start it: When you start it- Google Maps
- Google Sheets
Data
Count hours for each client from your calendar
Every meeting matched to a client, with total hours for each client and each week, in a sheet.
You start it: When you start it- Google Calendar
- Google Sheets
PersonalAsks first
Ask local tradespeople for quotes
Well-rated local businesses get one clear quote request each, after you approve the list and the text.
You start it: When you start it- Google Maps
- Yelp
- Any web form
- +1 more: Google Sheets
Personal
Compare schools near my home
Walking time, inspection grade, results, places and admission rules for each school, in one sheet.
You start it: When you start it- Any government site
- Google Maps
- Google Sheets