Automatic Weekly Sales Report: From Sales Sheet to Telegram Message

How much time do you spend each week working out what you sold? That number could land on your phone by itself on Saturday morning.

An automatic weekly sales report means that at a fixed time each week the system reads your sales sheet, calculates a few key numbers and sends them on Telegram. n8n and a simple sheet can do it. Automation computes the numbers; what they mean and what to do next stays with you.

By Saman Ghahreman · Published: · 7 min read

AI agents, chatbots and automation

Automatic Weekly Sales Report: From Sales Sheet to Telegram Message

A shop owner sits down at the end of the week and counts what was sold from invoices and chats. It takes time, sometimes goes wrong, and gets forgotten if a few weeks slip by. With n8n automation the same report can be built automatically every week. This article shows how, and where you should not rely on it.

What is wrong with a manual report?

Three things: it takes time, it differs a little each time (once with shipping, once without) and it is the first thing dropped when you get busy. A report built the same way every week makes weeks comparable.

NumberWhy it mattersWhere it comes from
Total weekly salesThe size of the business at a glanceThe sales sheet or CRM
Number of ordersSeparates volume from order valueThe orders sheet
Average order valueShows how much a customer buysTotal sales divided by orders
New versus returning customersShows where growth comes fromA customer’s first-purchase date
The weekly report path
  1. Schedule

    It runs every week at a fixed time (say, Saturday morning).

  2. Read the data

    Last week’s sales are read from the sheet or CRM.

  3. Compute

    Total sales, order count, average and new customers.

  4. Build the message

    A short message comparing with the week before.

  5. Send

    The message lands in your Telegram or the team group.

How do you build the weekly report step by step with n8n?

  1. Create a sales sheet where each row is an order: date, amount, customer ID and status. If you have a CRM, use that; see a simple CRM for an online store.
  2. In n8n, build a workflow and set the Schedule Trigger node to a fixed time each week; n8n’s documentation explains this node.
  3. Read last week’s data from the sheet and use a calculation node to produce the four numbers above.
  4. Compare them with the previous week and build a short message: “this week’s sales X; compared with last week Y”.
  5. Send the message with a Telegram bot. The bot posts to your chat or the team group using the sendMessage method of the Bot API.
  6. Run the automatic report next to the manual one for two weeks and compare the numbers; trust it only when they match.

Where does AI fit in this report?

Do not leave the arithmetic to AI; code computes sums and averages more exactly. AI is useful only for writing a two- or three-line summary on top of ready numbers (“sales are up on last week, mostly from returning customers”). A good way is to read that summary yourself for a few weeks first and automate it only once it proves accurate. For the wider idea, read about intelligent automation.

What errors make an automatic report untrustworthy?

  • Incomplete data: if sales are entered late, the report looks low. Set a fixed rule for recording orders.
  • A vague definition: “sales” with or without shipping? With or without discounts? Define it once and keep it.
  • Time and time zone: the week boundary differs from the server clock. Set the run time and week boundary explicitly.
  • A silent failure: if the workflow breaks and no message arrives, you may think sales were zero. Also set up an error message.

Where should you not rely on an automatic report?

  • Financial decisions and official accounting: the report is a quick view, not a ledger.
  • A business with a few orders a week: one look at the sheet is enough and no automation is needed.
  • A number with no clear source: tidy the data first, then automate.
  • The reason behind sales: the report says how much you sold, not why. Analysing the cause is yours.

What is the first step?

  1. This week, work out the four numbers above by hand and note them.
  2. Tidy the sales sheet and fix the definitions.
  3. Keep the manual report for a month so you have a reference.
  4. Then automate the same thing in n8n and compare it with the manual one.

Frequently asked questions

How do you build an automatic weekly sales report?

Build a tidy sales sheet, then set up an n8n workflow with a weekly schedule that reads the data, computes a few key numbers and sends them through a Telegram bot. Compare it with the manual report for two weeks.

Do I need AI for a weekly report?

No. Code computes sums and averages more exactly. AI is useful only for writing a short summary on ready numbers, and it is best checked by your own reading first.

Why does an automatic report sometimes show a wrong number?

Usually because of incomplete data, a vague definition of “sales”, or the time and week boundary. Fix the definitions and set up an error message for workflow failures.

Does an automatic report replace an accountant?

No. The report is a quick view of sales; the ledger and official financial decisions stay with the accountant and you.

Sources

Tags: automatic sales report · reporting automation · n8n for business · weekly report on Telegram · sales automation

Get advice on AI Chatbots & Automation

One short consultation is enough to clarify the path, timeline and rough cost of your project.

My promise
If you have a problem you think AI might solve, write to me. I’ll tell you honestly whether it will; sometimes the answer is no, and hearing that early is cheaper.
Book a consultation