Skip to content
Writing

Automation

Sample title — A Telegram bot that writes the monthly report

Replacing a copy-paste routine with a bot, a spreadsheet and a cron job — including the parts that went wrong.

Quvonchbek Saydullayev · [Date] · 1 min read

Sample article — placeholder text
On this page

The routine was simple and awful: open three spreadsheets, copy yesterday’s numbers into a fourth, format it, send it to a group chat. Twenty minutes a day, every day, and a mistake once a week.

The smallest thing that could work

A scheduled script that reads the sheets, writes a summary and posts it. No database, no dashboard, no admin panel — those come only if the numbers are ever wrong and need an audit trail.

Where it went wrong

The first version posted the report even when a sheet had not been updated. A report that is confidently wrong is worse than no report, so the bot now refuses to post and says which sheet is stale.

What I would do differently

Decide what “not enough data” means before writing the happy path.

Related

Contact

Have a useful idea? Let's build it.

Write to me about a project, a job or a question about an article. I reply to every message.

  • Email

    [email — to be provided]
  • Telegram

    [@handle — to be provided]
  • GitHub

    [github.com/… — to be provided]