Invenstory

Stock and sales tracking for small businesses, built inside the owner's own n8n. A mobile-first PWA where an LLM builds n8n workflows for you (e.g. "my stock is in Google Sheets"), n8n ingests and analyses the data, and a fixed dashboard shows KPIs, insights and one-tap action items.

  • No backend of ours, no accounts. Static files plus one stateless proxy function (functions/mcp.ts).
  • n8n data tables are the only store. The browser keeps only secrets and config.
  • Safety gate: workflows the LLM builds can never send messages or emails; that is enforced in code, not by prompt.

Status: v1.0.0-rc.1 (release candidate). See docs/STATUS.md for what is verified and what is not.

What's done and what still needs work

Done (v1.0.0-rc.1): every phase of the plan is implemented, and these were exercised against a real n8n Cloud instance:

  • install of the 9 tables and core workflows, plus in-place upgrades
  • the dashboard and its API
  • chat: onboarding, building, testing and publishing Google Sheets sync workflows, running a registered action
  • the safety gate on everything the agent builds

63 unit tests run in CI.

Still to verify or improve:

  1. Live runs of analysis, push notifications (incl. a phone with the PWA installed), a second device or teammate, an OpenAI-compatible provider, and a production deploy on Cloudflare Pages.
  2. Shared data for teammates: the install lives in one user's personal n8n project; it should be able to use a team project.
  3. n8n execution budget: hourly syncs and dashboard reads count against the plan's quota.
  4. A quick-entry box ("sold 2 mugs") so stock changes don't need a full chat turn.
  5. Chat saves have no retry queue; very long sessions get expensive.
  6. Planned later: ElevenLabs voice, PCA views.

Problem Statement Alleviate the technical difficulty, inefficiency/inconvenience, and human-prone errors/inaccuracies of trying to set up and maintain inventory/stock management & sales tracking automation (more detail) New User Journey Go to weblink (app site) Session cookie (or create account) Login to LLM provider (eg. Claude) Login to n8n Onboarding: login and setting up connectors Have LLM setup workflows in n8n Redirect to dashboard Run first analysis & automatic update List insights & action items Display chat interaction (prompt) Allow interactivity & options for data/info displays Ask Claude follow up questions on that feedback (to continue in that same session context) Ask Claude to update workflows, or add new n8n workflows Suggestions based on your connections and voice chat with the LLM Updated view of dashboard (loop back to 5.)

Inspiration inspired by difficulties of using tech

What it does

How we built it

Challenges we ran into

Accomplishments that we're proud of

What we learned

What's next for Investory

Built With

  • elevenlabs
  • n8n
  • ollama
  • openrouter
Share this project:

Updates

Submission history