Query Notion personal finance data via Telegram or WhatsApp

Input: natural-language query from Telegram/WhatsApp → Process: n8n Agent calls Notion tools to filter and summarize → Output: financial summary sent to your phone

Who

Individuals who track personal finances in Notion and want quick answers via chat

You get

Send natural-language questions like "Total expenses for August 2025" and receive summarized answers from Notion directly in Telegram or WhatsApp

You need

n8n · telegram · whatsapp · notion

Steps

1. Prepare credentials and template

   Complete the following preparations per the source template: 1) Duplicate the Personal Finance System template into your Notion workspace. 2) Create a Telegram bot via @BotFather, save the Bot Token, and obtain the Chat ID via getUpdates or the n8n trigger. 3) Sign up on OpenRouter and create an API Key. 4) Create a Notion internal integration, grant it read access to the Personal Finance System page, and save the Integration Token. 5) Create a WhatsApp Business app in Meta Developers, then obtain the WABA ID, Phone Number ID, and Permanent Access Token. Store credentials in n8n Credentials or environment variables.

2. Configure the Telegram trigger

   Add a Telegram Trigger node in n8n, select the message update type, and bind your Telegram Bot Token credential. Start the workflow and send a test message to your bot; confirm the node captures message.text and chat.id.

3. Configure the Accountant Agent and tools

   Add an Agent node (Accountant Agent), connect an OpenRouter Chat Model node (model: anthropic/claude-3.5-sonnet) and a Simple Memory node (sessionKey=1, contextWindowLength=10). Wire these three tools as ai_tool into the Agent: 1) Get Databases Tool (notionTool, resource=database, operation=getAll); 2) Get Notion Database Properties Tool (httpRequestTool, GET /v1/databases/{database_id}, using notionApi credential); 3) Query Notion Database Pages Tool (httpRequestTool, POST /v1/databases/{database_id}/query, using notionApi credential). In the Agent’s Options → System Message, paste the source systemMessage (see prompts below). In the Agent’s Text field, use the user-message template.

   Execution prompt · Source text。Accountant Agent node Text field (user input template)

   Copy prompt

   =Query: {{ $json.message.text}}
   Current Date {{ $now }}

   Execution prompt · Source text。Accountant Agent node Options → System Message field

   Copy prompt

   =# Overview
   You are a Accountant Agent who can retrieve and summarize information from all my notion databases relating to my personal finance using the 3 tools.
   
   # Tools
   1) Get Databases Tool - Get list of all databases with name and id.
   2) Get Notion Database Properties Tool - Get all the properties from a database based on database id.
   3) Query Notion Database Pages Tool - Get the list of rows based on database id and filters created based on input
   
   # Instructions
   1) Use the "Get Databases Tool" to get the list of databases from you notion account and return the database id based on selected database based on name similarity with input.
   2) Use the "Get Notion Database Properties Tool" to get the properties of the databases based on databaseId selected
   3) Based on the properties obtained from previous step and user input create a notion filter json.
   4) Use the "Query Notion Database Pages Tool", with the notion filter json on the database id obtained before to get the data you requested from notion database.
   
   # Examples
   
   1) Always use the **Financial Transactions** database when user input mentions expenses or transactions.  
      - `Amount` → property for the money value  
      - `Date` → property for the transaction date  
      - `Type` (or similar) → filter where value = "Expense"
   
   2) When the user asks “this month”, build a Notion filter JSON:
   ```json
   {
     "and": [
       { "property": "Type", "select": { "equals": "Expense" } },
       { "property": "Date", "date": { "on_or_after": "YYYY-MM-01" } },
       { "property": "Date", "date": { "on_or_before": "YYYY-MM-31" } }
     ]
   }
   ```
   
   3) Sum all the `Amount` values from the filtered rows and return the total.
   
   # Notes
   - Expenses → **Financial Transaction Database**  
   - Budget → **Budget Database**  
   - Funds (yearly plan to spend on big things or irregular expenditure) → **Funds Database**
   - Income -> **Income Database**
   - Assets and Liabilities -> **Assets and Liabilities**

4. Configure reply channels

   Add two output nodes and connect them to the Agent’s main output: 1) Telegram node (Send a text message), set chatId to your actual Chat ID, text to {{ $json.output }}, and disable appendAttribution; 2) WhatsApp node (Send message), set phoneNumberId, recipientPhoneNumber, and textBody to {{ $json.output }}, and bind the whatsAppApi credential. Both nodes run in parallel so the user receives the reply on both channels.

You are setting up an n8n personal finance assistant. First confirm the prerequisites: Notion template duplicated, Telegram Bot Token and Chat ID obtained, OpenRouter API Key created, Notion Integration Token authorized, WhatsApp Business credentials configured. Then import the workflow.json or build nodes manually: Telegram Trigger → Accountant Agent (Claude-3.5-Sonnet via OpenRouter + Simple Memory + 3 Notion tools) → Telegram Send + WhatsApp Send. The Agent’s System Message and user prompt must use the source text verbatim; do not modify tool names or database mappings.