Thank you for downloading the AI Multimodal Expense Tracker. To unlock the full potential of this workflow (especially the Smart Reporting feature), you need to complete 2 simple setup steps.

Step 1: Google Sheet Setup

  1. Click here to copy the Template: [GOOGLE SHEET TEMPLATE LINK HERE]
  2. Make sure the file permissions are set so n8n can access it (usually standard OAuth2 access is enough).
  3. Copy the Spreadsheet ID from the URL (the text string between /d/ and /edit). You will need this for the workflow Config.

Step 2: n8n Data Table Setup (Required)

This workflow uses n8n Data Tables to store a temporary "token". This allows the bot to wait for 30 minutes after your last expense before sending a Daily Report, ensuring you aren't spammed with notifications if you are logging multiple items in a row.

1. Create the Table

  1. Go to your n8n Dashboard.
  2. Click on Data Tables (in the left sidebar) -> New Data Table.
  3. Name the table: ReportTokens.

2. Add Columns

You must add exactly 3 Columns with these specific names and types:

Column Name Data Type Description
chat_id String (Text) Stores your Telegram Chat ID
report_token String (Text) Stores the unique reporting token
updated_at String (Text) Timestamp of the last activity

(Make sure "String" is selected, not Number or Date)

3. Connect to Workflow

  1. Once created, go back to the AI Expense Tracker workflow canvas.
  2. Locate the nodes related to Data Tables (usually named ReportTokens, Data table → Get row, etc.).
  3. In each of these nodes, select your newly created ReportTokens table from the dropdown list.

Step 3: Final Configuration