Skip to main content
Lifetime license included with every purchase
FinanceBeginner✓ Release process: run on a live n8n instance

MileLog: Telegram Mileage Tracker for Tax Time

MileLog: Telegram Mileage Tracker for Tax Time ships as a ready-to-import n8n automation package: load the bundled workflow JSON, connect the credentials listed on this page, and activate it on self-hosted n8n or n8n Cloud.

Text one line to your own Telegram bot and every business drive becomes an IRS-rate deduction row in Google Sheets, with a tax-ready monthly summary emailed to you.

  • Log a business drive in five seconds by texting 'client A -> office' to your own Telegram bot
  • Pull the real driving distance from Google Maps instead of trusting a phone GPS that misses half a mile
  • Convert every trip to dollars at the mileage rate you set, and change that rate in one field each January
  • Name your regular stops once so the start point is always the address you meant, never the one a tracker guessed
  • Append each trip to a Google Sheet with date, route, purpose, distance, rate and deduction ready for an audit
  • Email yourself a tax-ready monthly summary with a purpose breakdown and running year-to-date deduction
  • Build a one-row-per-month Yearly Summary tab you can hand your accountant in April
TelegramGoogle Maps Distance MatrixGoogle SheetsSMTP
n8n / workflow / mileage-log-botActual workflow — not a mockup
Telegram Message — WebhookTelegram MessageWEBHOOKConfig — SetConfigSETParse Trip — CodeParse TripCODEValid Trip? — IFValid Trip?IFGet Driving Distance — HTTP RequestGet Driving Distan…HTTP REQUESTCompute Deduction — CodeCompute DeductionCODEDistance Found? — IFDistance Found?IFAppend Trip Row — Google SheetsAppend Trip RowGOOGLE SHEETSSend Confirmation — TelegramSend ConfirmationTELEGRAMMark Logged — CodeMark LoggedCODESend Help Reply — TelegramSend Help ReplyTELEGRAM
11 nodes · 11 connections · 1 trigger · 2 in-canvas notesExported from the workflow file you receive — scroll sideways to follow the full path.
One-time
$19
~10 min
setup time

Setup Service — optional live install and test. Choose your tier at checkout (not tied to this template's price).

Instant download after payment
Refund as per the Refund Policy for downloadable templates.
Email Support · 24h SLA
Lifetime updates
APIs required
TelegramGoogle Maps Distance MatrixGoogle SheetsSMTP
Already purchased?
Download MileLog: Telegram Mileage Tracker for Tax Time

Paste the license key from your receipt. It must match this template.

How it works

Workflow summary

2 coordinated workflows handle different parts of the automation.

MileLog Trip Logger

Required
  1. 1You text a one-line trip to your own Telegram bot, like 'client A -> office'
  2. 2The message is parsed into a start, a destination, a purpose and an optional round trip
  3. 3Short names such as 'office' or 'home' are swapped for the full addresses you saved once
  4. 4Google Maps returns the real driving distance for that route
  5. 5The distance is converted to a dollar deduction at the mileage rate you set
  6. 6The trip is appended to your Google Sheet with date, route, purpose, distance, rate and deduction
  7. 7The bot texts back a confirmation, and only then records the message so nothing is ever logged twice
  8. 8Anything it cannot read - a missing arrow, an unknown address - comes back as a readable reply instead of vanishing

MileLog Monthly Tax Summary

Optional
  1. 1Runs every morning in your timezone and waits for the day of the month you chose
  2. 2Reads every trip you logged from the mileage Google Sheet
  3. 3Totals the month that just closed: trips, distance and deduction, broken down by purpose
  4. 4Adds a running year-to-date deduction figure for the same sheet
  5. 5Emails you the tax-ready summary, flagging any rows with an unreadable date
  6. 6Appends one line per month to the Yearly Summary tab, so the annual export is ready in April
Daily Month-End Check — Schedule TriggerDaily Month-End Ch…SCHEDULE TRIGGERConfig — SetConfigSETFetch Trips — Google SheetsFetch TripsGOOGLE SHEETSBuild Monthly Summary — CodeBuild Monthly Summ…CODESummary Due? — IFSummary Due?IFEmail Tax Summary — Send EmailEmail Tax SummarySEND EMAILRecord Summary Sent — CodeRecord Summary SentCODESummary Sent? — IFSummary Sent?IFAppend Yearly Row — Google SheetsAppend Yearly RowGOOGLE SHEETS
9 nodes · 8 connections · 1 trigger · 2 in-canvas notesExported from the workflow file you receive — scroll sideways to follow the full path.
Deliverables

What's included with your purchase

Every checkout includes the same practical package so you are never hunting for missing files mid-setup.

  • 01Workflow JSON exports ready to import into your n8n workspace (self-hosted or n8n Cloud).
  • 02Step-by-step guide that walks credential creation, node-by-node checks, and activation.
  • 03Credential checklist for Telegram, Google Maps Distance Matrix, Google Sheets, SMTP. Email support@n8ntemplatestore.com if you get stuck — replies within 24 hours (SLA).
  • 04Perpetual (lifetime) use license Your one-time purchase includes an ongoing right to use this template package on n8n instances you control for your own automation — not for resale or public redistribution of the files as a product. Terms & conditions.
  • 05We keep the copyright Workflow JSON, guides, screenshots, and bundled assets stay our copyrighted works (or our licensors'). Payment grants the limited license in our Terms only — it does not transfer ownership.

Need a second opinion before buying? Compare the full catalog, browse more Finance templates, see how n8n compares to Zapier and Make, or read the support policies.

Setup

Three steps to a running n8n automation

01

Import the workflow into n8n

02

Paste your API keys into the credentials panel

03

Press ‘activate’ — you’ll get your first report tomorrow morning

Support

Need help setting up this n8n template?

Beginner-friendly guidance is included. Our support team will help you if you get stuck — email support@n8ntemplatestore.com or visit support.

Email support
Replies within 24 hours (SLA)
Contact
Setup Service4 tiers — your choice
Optional live session — we install, configure, and test on a screen share. Add Setup Serviceat checkout and pick any tier; pricing is not tied to this template's list price.
Book setup
FAQ

About this template

How long does it take to set up MileLog: Telegram Mileage Tracker for Tax Time?
Most people finish in minutes following the guide. If you’ve never used n8n before, budget an hour — the first workflow is always the slowest.
What if I get stuck?
Email support@n8ntemplatestore.com. Free basic support is included with every purchase, and you’ll get a reply from our team within 24 hours. If setup needs more than email, we can schedule a call.
Do I need to pay for Telegram?
API costs are separate and go directly to the provider — typically a few dollars a month at most for a solo business. Full breakdown is in the setup guide.
Can I customize the workflow?
Yes, completely. You own the .json — edit nodes, swap in your own prompts, re-wire the logic. Our support team can help you plan customizations over email.
What if it doesn’t work for me?
Refunds are issued only as described in our Refund Policy (https://n8ntemplatestore.com/refund-policy). Or add Setup Service at checkout for a live install and test session — pick any tier you prefer.

Related n8n workflow templates

New
FinanceBeginner

BillingBridge: Stripe Invoice → CRM Sync

Pre-built n8n workflow template that automates finance with Stripe. Live in about 10 minutes.

$15
~10 min setup
FinanceIntermediate

TipSplit: Tip-Pool Calculator & Payout Sheet

Pre-built n8n workflow template that automates finance with Google Sheets. Live in about 10 minutes.

$14
~10 min setup
FinanceIntermediate

InvoiceAudit: Vendor Price-Creep Watchdog

Pre-built n8n workflow template that automates finance with Gmail. Live in about 10 minutes.

$19
~10 min setup