January 22, 2026

Google Sheets + Slack: receipts turned into budget clarity

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Receipts pile up fast. Then you spend your Sunday night squinting at crumpled paper, trying to remember what “¥2,480 at that place” even was.

This hits busy households first, honestly. But freelancers who mix personal and business spending, and small teams with shared cards feel it too. This Slack budget updates automation turns a receipt photo into clean rows in Google Sheets and a budget snapshot in Slack, so you know where you stand without doing math in your head.

You’ll see what the workflow does, what you need, and how it translates into day-to-day clarity (not another spreadsheet you never open).

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets + Slack: receipts turned into budget clarity

Click to explore

flowchart LR

    subgraph sg0["Extract Receipt Fiel Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Receipt Upload Hook"]
        n1@{ icon: "mdi:database", form: "rounded", label: "Append Budget Sheet", pos: "b", h: 48 }
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Compute Monthly Totals"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Post Slack Update"]
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Normalize Receipt Data"]
        n6@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Model B", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "Extract Receipt Fields", pos: "b", h: 48 }
        n8@{ icon: "mdi:robot", form: "rounded", label: "Draft Budget Summary", pos: "b", h: 48 }
        n14@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Model C", pos: "b", h: 48 }
        n7 --> n5
        n8 --> n3
        n5 --> n1
        n1 --> n2
        n2 --> n8
        n0 --> n7
        n14 -.-> n8
        n6 -.-> n7
    end

    subgraph sg1["Compose Monthly Repo Flow"]
        direction LR
        n4@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Model A", pos: "b", h: 48 }
        n9@{ icon: "mdi:cog", form: "rounded", label: "Daily Schedule Trigger", pos: "b", h: 48 }
        n10@{ icon: "mdi:database", form: "rounded", label: "Fetch Budget Sheet Daily", pos: "b", h: 48 }
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Monthly Spend Analysis"]
        n12@{ icon: "mdi:robot", form: "rounded", label: "Compose Monthly Report", pos: "b", h: 48 }
        n13["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Send Monthly Slack"]
        n12 --> n13
        n11 --> n12
        n9 --> n10
        n4 -.-> n12
        n10 --> n11
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n7,n8,n12 ai
    class n6,n14,n4 aiModel
    class n1,n10 database
    class n0 api
    class n2,n5,n11 code
    classDef customIcon fill:none,stroke:none
    class n0,n2,n3,n5,n11,n13 customIcon

The Problem: Receipts Create Blind Spots in Your Budget

Most “budgeting” breaks down in the boring middle. You buy groceries, grab coffee, pick up something for the house, and the proof is a paper slip that disappears into a bag or a car cupholder. Even if you have the best intentions, manual logging turns into a weekly (or monthly) catch-up session, which means your budget is always out of date. The worst part is the uncertainty: you stop trusting your own numbers, so spending decisions become guesses, not choices.

It adds up fast. Here’s where it usually breaks down.

You postpone logging because it’s “just a few receipts,” then it becomes 40 minutes of cleanup later.
Totals get mistyped, and one wrong digit makes your month look better (or worse) than reality.
Line items are hard to capture consistently, so you cannot see patterns like repeat convenience-store runs.
Even when you track spending, you still don’t get a simple “remaining budget” message when it matters.

The Solution: Receipt Photos → Google Sheets Rows → Slack Budget Updates

This n8n workflow turns receipts into a living budget log. You send a receipt photo into a webhook (often from your phone), and an AI agent extracts the useful parts: date, store, items, total amount. The workflow normalizes that data so it lands as clean, consistent columns in Google Sheets, not messy text blobs. Right after the entry is added, it calculates your current month’s spend and your remaining budget, then posts a short update to Slack so you see the impact immediately. On a daily schedule, it also generates a monthly roll-up report with trends like top stores and daily average, then sends that to Slack as well.

The workflow starts with a receipt upload event, then uses OpenRouter chat models plus an AI agent to pull structured fields. After that, Google Sheets becomes your source of truth, and Slack becomes the place you actually notice the numbers.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Extracts receipt details (date, store, items, amount) from a photo upload.
Normalizes inconsistent receipt text into consistent fields for tracking.
Appends each receipt as a new row in your Google Sheets budget file.
Computes monthly totals and generates daily and monthly Slack messages automatically.

Most people get about 2 hours back each month by skipping manual entry.
Your budget stops lagging behind, because it updates right after you spend.
Fewer “surprise” end-of-month moments when the card statement lands.
Clearer decisions in the moment (you know what’s left before you buy).
A simple spending narrative every month: top stores, averages, and patterns.

Example: What This Looks Like

Say you collect 20 receipts a week. Manually logging each one takes maybe 3 minutes between typing the store, date, and total, plus fixing mistakes, so you lose about an hour weekly. With this workflow, you upload the photo (about 1 minute), then the AI parses and posts the Slack budget update while you move on. You still get a spreadsheet record, but you don’t have to babysit it.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for storing clean receipt rows
Slack to receive daily and monthly budget updates
OpenRouter API key (get it from your OpenRouter dashboard)

Skill level: Intermediate. You’ll connect accounts, set permissions, and adjust one budget value in a code node.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

Receipt upload kicks it off. You send a receipt photo to the workflow’s webhook endpoint. That single action is the “capture moment” so the receipt doesn’t vanish into the void.

The AI extracts and cleans your data. An AI agent pulls out key fields (date, store, items, amount) using OpenRouter chat models, then a normalization step makes the format consistent so your Sheet stays tidy.

Google Sheets becomes your ledger. Each receipt is appended as a new row under the columns you set up (“Date”, “Store”, “Items”, “Amount”). If you’ve ever tried doing this from memory, you already know why this matters.

Slack shows you the current story. After the row is added, the workflow computes month-to-date spending and remaining budget, then posts a summary to your chosen Slack channel. Separately, a daily cron trigger reads the month’s sheet data, runs deeper analysis, and sends a monthly-style report to Slack.

You can easily modify the monthly budget amount to match your household, or swap Slack for another notification channel based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Webhook Trigger

Set up the incoming webhook that receives receipt text and kicks off the receipt parsing flow.

Add the Receipt Upload Hook node and open its settings.
Set HTTP Method to POST.
Set Path to receipt Text.
Copy the generated webhook URL and use it in your receipt upload source (e.g., OCR app or webhook client).

⚠️ Common Pitfall: The incoming payload must include the text at $json.body[''].text because Extract Receipt Fields reads from that path.

Step 2: Connect Google Sheets

Configure the budget spreadsheet for both the receipt append flow and the daily analysis flow.

Open Append Budget Sheet and select your spreadsheet.
Set Document to [YOUR_ID] and Sheet to Budget.
Ensure the column mappings are set to {{ $json["Date"] }}, {{ $json["Items"] }}, {{ $json["Store"] }}, and {{ $json["Amount"] }}.
Open Fetch Budget Sheet Daily and select the same Document [YOUR_ID] and Sheet Budget.
Credential Required: Connect your Google Sheets credentials in both Append Budget Sheet and Fetch Budget Sheet Daily (this workflow has no credentials configured yet).

⚠️ Common Pitfall: If your sheet columns don’t match Date, Items, Store, and Amount, the append operation will fail or write blank data.

Step 3: Set Up Receipt Processing and Normalization

Use the AI agent to extract receipt fields, then normalize them into structured items for the spreadsheet.

Open Extract Receipt Fields and set Text to {{ $json.body[''].text }}.
Review the system prompt in Extract Receipt Fields to ensure it matches your receipt format.
Open Normalize Receipt Data to confirm it parses $json.output into Date, Store, Items, and Amount fields.
Credential Required: Connect your OpenRouter credentials in OpenRouter Model B (used by Extract Receipt Fields as the language model).

Tip: If your OCR returns multiple items, the system prompt in Extract Receipt Fields is already set to return an array, and Normalize Receipt Data will handle it.

Step 4: Configure Budget Calculations and Slack Updates

Calculate monthly totals and send a summary to Slack after each receipt is saved.

Open Compute Monthly Totals and edit the line const budget = 30000; to your monthly budget amount.
Verify Draft Budget Summary uses {{ $json["message"] }} as input text.
Set Post Slack Update to send Text as {{ $json.output }} and select your target channel.
Credential Required: Connect your Slack OAuth2 credentials in Post Slack Update (not configured yet).
Credential Required: Connect your OpenRouter credentials in OpenRouter Model C (used by Draft Budget Summary as the language model).

Step 5: Configure the Daily Monthly Report Flow

Run a daily schedule that analyzes month-to-date spending and sends a Slack report.

Open Daily Schedule Trigger and set your preferred daily schedule (e.g., every morning).
Ensure Fetch Budget Sheet Daily reads from the same Document [YOUR_ID] and Sheet Budget.
Review Monthly Spend Analysis for the month aggregation logic and top 3 breakdowns.
Open Compose Monthly Report and keep the Text field expression as {{`Create a report from this month's (${ $json["month"] }) household budget data. ...`}}.
Set Send Monthly Slack to send Text as {{ $json.output }} to your Slack channel.
Credential Required: Connect your OpenRouter credentials in OpenRouter Model A (used by Compose Monthly Report as the language model).
Credential Required: Connect your Slack OAuth2 credentials in Send Monthly Slack (not configured yet).

Tip: The daily report uses the latest row’s month to define the reporting period, so ensure your dates are consistently formatted.

Step 6: Test and Activate Your Workflow

Verify both the receipt intake flow and the daily reporting flow, then activate the workflow.

Click Execute Workflow on Receipt Upload Hook and send a test POST request with a text payload to confirm Extract Receipt Fields and Normalize Receipt Data run.
Confirm that Append Budget Sheet writes a new row and Post Slack Update posts a budget summary.
Manually run Daily Schedule Trigger to ensure Fetch Budget Sheet Daily → Monthly Spend Analysis → Compose Monthly Report → Send Monthly Slack completes.
When both paths succeed, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets sharing is the silent killer. If rows never append, check the Sheet is shared with the service account email from your n8n Google Sheets credentials and that it has Editor access.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
OpenRouter prompts and system messages start generic. Add your preferred language, currency format, and “what to include” in the AI nodes early or you’ll keep rewriting Slack messages.

Frequently Asked Questions

How long does it take to set up this Slack budget updates automation?

About 30 minutes if your Google Sheets and Slack access are ready.

Do I need coding skills to automate Slack budget updates?

No. You will connect accounts and change a single monthly budget value in the workflow.

Is n8n free to use for this Slack budget updates workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenRouter API usage costs, which depend on the model you choose and how many receipts you process.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Slack budget updates workflow for different categories (like groceries vs. dining)?

Yes, but you’ll want to add one extra extraction field. Update the “Extract Receipt Fields” AI agent to return a “Category” value, then append that to Google Sheets by extending the “Append Budget Sheet” mapping. Common customizations include category rules by store name, a separate “Business vs Personal” column, and routing high-value purchases to a different Slack channel.

Why is my Google Sheets connection failing in this workflow?

Most of the time it’s permissions. Make sure the exact sheet is shared with the service account email used by your n8n Google Sheets credentials, and that it has Editor access. If the sheet name changed, re-select it in the “Append Budget Sheet” and “Fetch Budget Sheet Daily” nodes. Also check you didn’t hit Google API limits if you’re testing a lot in a short window.

How many receipts can this Slack budget updates automation handle?

A typical setup can handle hundreds of receipts a month without drama.

Is this Slack budget updates automation better than using Zapier or Make?

Often, yes, because this workflow needs a few things that get awkward in simpler tools: AI extraction, data cleanup, calculations, and two different triggers (webhook plus daily cron). n8n also gives you more control over how the monthly analysis is computed, and self-hosting means you’re not paying per tiny step when volume grows. Zapier or Make can still be fine if you only want “upload receipt → send message” with no spreadsheet history. If you want both the ledger and the reporting, n8n is usually the cleaner fit. Talk to an automation expert if you want help choosing.

Once this is running, your budget updates itself in the background. You get the clarity, and your receipts stop being a monthly mystery.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "7f3fb84a1a7cf11cb499b3739e335ea543a50bc24f7b21e5e1d674c5b82d45f0"
},
"name": "Automated Receipt Budget Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-10970",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
30,
30
],
"parameters": {
"color": 7,
"width": 925,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "d9e934b1-3ddb-4312-8556-03e0bc75f001",
"name": "Receipt Upload Hook",
"type": "n8n-nodes-base.webhook",
"position": [
820,
398
],
"webhookId": "8d328615-3aeb-42ec-990a-1263815468b2",
"parameters": {
"path": "receipt Text",
"options": [],
"httpMethod": "POST"
},
"typeVersion": 2.1
},
{
"id": "be58ef74-b716-4f12-875d-aa09572f9b3c",
"name": "Append Budget Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
170,
406
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $json[\"Date\"] }}",
"Items": "={{ $json[\"Items\"] }}",
"Store": "={{ $json[\"Store\"] }}",
"Amount": "={{ $json[\"Amount\"] }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Store",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Store",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Items",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Items",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Amount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Amount",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Data"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Budget"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Budget"
}
},
"typeVersion": 4.7
},
{
"id": "51956fcd-1422-4e1c-88fb-ea7a5f921fb2",
"name": "Compute Monthly Totals",
"type": "n8n-nodes-base.code",
"position": [
35,
388
],
"parameters": {
"jsCode": "// Get all rows from the previous Google Sheets (Read) node\nconst items = $items();\n\n// If the sheet is empty, do nothing\nif (items.length === 0) {\n  return [{\n    json: {\n      message: 'No household budget data yet.'\n    }\n  }];\n}\n\n// Function to convert date strings \"YYYY/MM/DD\" or \"YYYY-MM-DD\" to Date objects\nfunction parseDate(str) {\n  if (!str) return null;\n  const parts = str.split(/[\\/\\-]/).map(Number);\n  if (parts.length < 3) return null;\n  const [y, m, d] = parts;\n  return new Date(y, m - 1, d);\n}\n\n// Assume the last row is the newly added record and aggregate by its month\nconst lastRow = items[items.length - 1].json;\nconst lastDateStr = lastRow['Date'];\nconst targetDate = parseDate(lastDateStr) || new Date();\n\n// Target Year-Month (e.g., \"2025-04\")\nconst targetYm = `${targetDate.getFullYear()}-${('0' + (targetDate.getMonth() + 1)).slice(-2)}`;\n\n// Calculate total for the current month\nlet total = 0;\nfor (const { json: row } of items) {\n  const ds = row['Date'];\n  const d = parseDate(ds);\n  if (!d) continue;\n\n  const ym = `${d.getFullYear()}-${('0' + (d.getMonth() + 1)).slice(-2)}`;\n  if (ym === targetYm) {\n    const price = Number(row['Amount'] || 0);\n    if (!isNaN(price)) {\n      total += price;\n    }\n  }\n}\n\n// \u2605 Monthly budget (change this to your desired amount)\nconst budget = 30000;\n\nconst remaining = budget - total;\n\n// Assemble message for Slack\nconst lines = [\n  `\ud83d\udcca Household Budget for ${targetYm}`,\n  `Budget: ${budget.toLocaleString()} JPY`,\n  `Total Spent: ${total.toLocaleString()} JPY`,\n  `Remaining Budget: ${remaining.toLocaleString()} JPY`,\n];\n\nif (remaining < 0) {\n  lines.push(`\u26a0\ufe0f You have exceeded your budget by ${Math.abs(remaining).toLocaleString()} JPY.`);\n}\n\nreturn [{\n  json: {\n    month: targetYm,\n    budget: budget,\n    totalSpent: total,\n    remainingBudget: remaining,\n    message: lines.join('\\n')\n  }\n}];\n"
},
"typeVersion": 2
},
{
"id": "8a6fa2ef-887e-4695-94d3-7275b5dd2410",
"name": "Post Slack Update",
"type": "n8n-nodes-base.slack",
"position": [
418,
560
],
"webhookId": "a82d6c2e-b15c-4795-b7ec-75b5296a487b",
"parameters": {
"text": "={{ $json.output }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": ""
},
"otherOptions": [],
"authentication": "oAuth2"
},
"typeVersion": 2.3
},
{
"id": "843ef5f2-cba2-4629-bde0-f19355739d93",
"name": "OpenRouter Model A",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
660,
270
],
"parameters": {
"options": []
},
"typeVersion": 1
},
{
"id": "c0ea41d0-15e8-461f-8162-f6762444f75b",
"name": "Normalize Receipt Data",
"type": "n8n-nodes-base.code",
"position": [
385,
362
],
"parameters": {
"jsCode": "// Assuming AI Agent output is in $json.output\nlet raw = $json.output;\n\n// Convert to JSON if it's a string\nif (typeof raw === 'string') {\n  raw = raw.trim();\n\n  // Remove ```json ~ ``` if present\n  raw = raw.replace(/^```(?:json)?/i, '').replace(/```$/i, '').trim();\n\n  try {\n    raw = JSON.parse(raw);\n  } catch (error) {\n    throw new Error('Could not parse AI Agent output as JSON: ' + error.message + '\\nraw=' + raw);\n  }\n}\n\n// Ensure it's an array, even if only one item\nconst data = Array.isArray(raw) ? raw : [raw];\n\n// Format into n8n's items array structure\nconst items = data.map(entry => {\n  return {\n    json: {\n      Date: entry['Date'],\n      Store: entry['Store'],\n      Items: entry['Items'],\n      Amount: entry['Amount']\n    }\n  };\n});\n\nreturn items;\n"
},
"typeVersion": 2
},
{
"id": "fe796bfc-a632-4d8c-9ba3-2c76b768655d",
"name": "OpenRouter Model B",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
592,
572
],
"parameters": {
"options": []
},
"typeVersion": 1
},
{
"id": "a204a1cb-3cb6-4ea0-8e79-cbd6b301cd30",
"name": "Extract Receipt Fields",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
585,
402
],
"parameters": {
"text": "={{ $json.body[''].text }}",
"options": {
"systemMessage": "You are an expert in receipt analysis. From the following text, accurately extract the date, store name, purchased items, and amount, and output them in the following format:\n\n[\n  {\n    \"Date\": \"YYYY/MM/DD\",\n    \"Store\": \"Store Name\",\n    \"Items\": \"Item Name\",\n    \"Amount\": Amount\n  }\n]\n\nIf there are multiple items, return multiple objects. Do not include any extra comments or sentences, return only JSON. Group items with the same date into a single entry."
},
"promptType": "define"
},
"typeVersion": 3
},
{
"id": "8515213f-2fe5-4334-bc8c-7f6b6739c85d",
"name": "Draft Budget Summary",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
202,
574
],
"parameters": {
"text": "={{ $json[\"message\"] }}",
"options": {
"systemMessage": "You are a specialist in drafting polished content for Slack. Summarize the total amount spent and the remaining budget. Example:\nCurrent spending: 1000 JPY\nRemaining budget this month: 10000 JPY"
},
"promptType": "define"
},
"typeVersion": 3
},
{
"id": "78cafaa5-7ef7-4441-affb-ca5494ce10eb",
"name": "Daily Schedule Trigger",
"type": "n8n-nodes-base.cron",
"position": [
30,
140
],
"parameters": [],
"typeVersion": 1
},
{
"id": "4baa9d88-2664-4dbf-b59c-d673c743564b",
"name": "Fetch Budget Sheet Daily",
"type": "n8n-nodes-base.googleSheets",
"position": [
210,
155
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Budget"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Budget"
}
},
"typeVersion": 4.7
},
{
"id": "a1e12212-03c5-4f11-bf73-4191b7a52c41",
"name": "Monthly Spend Analysis",
"type": "n8n-nodes-base.code",
"position": [
445,
130
],
"parameters": {
"jsCode": "// All rows from the sheet\nconst items = $items();\nif (items.length === 0) {\n  return [{\n    json: {\n      message: 'No household budget data yet.'\n    }\n  }];\n}\n\n// Date parsing function\nfunction parseDate(str) {\n  if (!str) return null;\n  const parts = str.split(/[\\/\\-]/).map(Number);\n  if (parts.length < 3) return null;\n  const [y, m, d] = parts;\n  return new Date(y, m - 1, d);\n}\n\n// The month of the latest row's date will be the target month\nconst lastRow = items[items.length - 1].json;\nconst lastDate = parseDate(lastRow['Date']) || new Date();\nconst targetYm = `${lastDate.getFullYear()}-${('0' + (lastDate.getMonth() + 1)).slice(-2)}`;\n\n// For aggregation\nlet total = 0;\nconst byStore = {};  // Per store\nconst byItem = {};   // Per item\nconst byDate = {};   // Per date\n\nfor (const { json: row } of items) {\n  const d = parseDate(row['Date']);\n  if (!d) continue;\n\n  const ym = `${d.getFullYear()}-${('0' + (d.getMonth() + 1)).slice(-2)}`;\n  if (ym !== targetYm) continue; // Skip if not current month\n\n  const price = Number(row['Amount'] || 0);\n  if (isNaN(price)) continue;\n\n  const dateKey = row['Date'];\n  const store = row['Store'] || 'Unknown Store';\n  const item = row['Items'] || 'Unknown Item';\n\n  total += price;\n\n  byDate[dateKey] = (byDate[dateKey] || 0) + price;\n  byStore[store] = (byStore[store] || 0) + price;\n  byItem[item] = (byItem[item] || 0) + price;\n}\n\n// Daily average\nconst days = Object.keys(byDate).length || 1;\nconst avgPerDay = Math.round(total / days);\n\n// Top N ranking function\nfunction topN(map, n) {\n  return Object.entries(map)\n    .sort((a, b) => b[1] - a[1])\n    .slice(0, n)\n    .map(([key, value]) => ({\n      name: key,\n      amount: value\n    }));\n}\n\nconst topStores = topN(byStore, 3);\nconst topItems = topN(byItem, 3);\nconst topDays = topN(byDate, 3);\n\nreturn [{\n  json: {\n    month: targetYm,\n    monthlyTotal: total,\n    dailyAverage: avgPerDay,\n    top3Stores: topStores,\n    top3Items: topItems,\n    top3SpendingDays: topDays\n  }\n}];"
},
"typeVersion": 2
},
{
"id": "ca04ca63-5377-4f27-bc2f-87cfecee94d1",
"name": "Compose Monthly Report",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
680,
148
],
"parameters": {
"text": "={{`Create a report from this month's (${ $json[\"month\"] }) household budget data.\n\n- Total monthly expenditure: ${$json[\"monthlyTotal\"]} JPY\n- Daily average: ${$json[\"dailyAverage\"]} JPY\n- Top 3 stores by spending: ${JSON.stringify($json[\"top3Stores\"])}\n- Top 3 items by spending: ${JSON.stringify($json[\"top3Items\"])}\n- Top 3 days with most spending: ${JSON.stringify($json[\"top3SpendingDays\"])}\n\nSummarize this month's trends and provide simple advice in English, using bullet points and short comments. Keep it to a readable length and use a polite, informal tone.`}}",
"options": {
"systemMessage": "You are an assistant that analyzes household budget data and writes clear English reports. Based on the given numbers, describe the trends and offer simple advice. Keep it to a readable length and use a polite, informal tone."
},
"promptType": "define"
},
"typeVersion": 3
},
{
"id": "6d340421-5082-4dc2-98e8-8aadb85acbc9",
"name": "Send Monthly Slack",
"type": "n8n-nodes-base.slack",
"position": [
855,
162
],
"webhookId": "a82d6c2e-b15c-4795-b7ec-75b5296a487b",
"parameters": {
"text": "={{ $json.output }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": ""
},
"otherOptions": [],
"authentication": "oAuth2"
},
"typeVersion": 2.3
},
{
"id": "1e37b78a-f1ce-46e6-94c2-3efd52f140b1",
"name": "OpenRouter Model C",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
192,
740
],
"parameters": {
"options": []
},
"typeVersion": 1
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Extract Receipt Fields": {
"main": [
[
{
"node": "Normalize Receipt Data",
"type": "main",
"index": 0
}
]
]
},
"Draft Budget Summary": {
"main": [
[
{
"node": "Post Slack Update",
"type": "main",
"index": 0
}
]
]
},
"Compose Monthly Report": {
"main": [
[
{
"node": "Send Monthly Slack",
"type": "main",
"index": 0
}
]
]
},
"Monthly Spend Analysis": {
"main": [
[
{
"node": "Compose Monthly Report",
"type": "main",
"index": 0
}
]
]
},
"Normalize Receipt Data": {
"main": [
[
{
"node": "Append Budget Sheet",
"type": "main",
"index": 0
}
]
]
},
"Append Budget Sheet": {
"main": [
[
{
"node": "Compute Monthly Totals",
"type": "main",
"index": 0
}
]
]
},
"Compute Monthly Totals": {
"main": [
[
{
"node": "Draft Budget Summary",
"type": "main",
"index": 0
}
]
]
},
"Daily Schedule Trigger": {
"main": [
[
{
"node": "Fetch Budget Sheet Daily",
"type": "main",
"index": 0
}
]
]
},
"Receipt Upload Hook": {
"main": [
[
{
"node": "Extract Receipt Fields",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Model C": {
"ai_languageModel": [
[
{
"node": "Draft Budget Summary",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenRouter Model A": {
"ai_languageModel": [
[
{
"node": "Compose Monthly Report",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenRouter Model B": {
"ai_languageModel": [
[
{
"node": "Extract Receipt Fields",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Fetch Budget Sheet Daily": {
"main": [
[
{
"node": "Monthly Spend Analysis",
"type": "main",
"index": 0
}
]
]
}
}
}