workflows.fit
Back to n8n workflows
n8n templateFreeBy Anoop

Send scheduled financial digests to Telegram from Notion with multi-schedule alerts

Who’s it for Solo founders and spreadsheet gremlins who track everything in Notion and want crisp Telegram pings without opening a single page. What it does This workflow runs on daily, weekly, and monthly schedules, ...

CommunicationHITLProductivityDevelopmentCore NodesSchedule TriggerSetCode
Loading interactive preview...

Template notes

Who’s it for Solo founders and spreadsheet gremlins who track everything in Notion and want crisp Telegram pings without opening a single page.

What it does This workflow runs on daily, weekly, and monthly schedules, queries multiple Notion databases, summarizes key numbers, formats human‑readable messages, and sends them to Telegram.

Out of the box it sends: - Daily: Total Expenses Today (sum of Debit in Financial Transaction since start of day). - Weekly: Total Expenses This Week, Monthly Budget Left/Spent per budget item, Financial Obligations due (from Scheduler). - Month End (28th by default): Total Expenses This Month, Total Income This Month, Funds status. - Month Start: Liquidity snapshot — balances for Liquid and Semi Liquid assets (from Assets and Liabilities).

Messages are built via Code nodes (simple JS) and delivered to Telegram.

---

How it works (nodes & flow) - Schedule Triggers: Daily, Weekly, Monthly (start & end). - Notion queries (selected DBs): - Financial Transaction: filters on Created time, Type = Debit/Invoice. - Budget: Currently Applicable = true, Payment Schedule Type = Monthly, formula: Monthly Budget Left. - Income: month-to-date Created time filter. - Funds: reads Amount Left, Amount Spent, Amount Needed. - Scheduler: Next Date on or before now, Type = Financial, Repeat Type != off. - Assets and Liabilities: Liquidity = Liquid or Semi Liquid. - Summarize nodes: sum propertycost / propertybalance fields. - Set/Code nodes: reshape Notion properties (e.g., propertynextdate.start → next-date) and format text blocks like: - Total Expenses Today - Rs X - Monthly Budget Left - <list> - Invoices still to pay - <list> - Funds Info - spent/needed - Liquidity Balance - <list> - Telegram: sends the composed message to chatId.

> Tip: If your Notion property names differ, adjust the filters and Set node mappings accordingly.

---