CHATBOTS

Warehouse Stock and Bin Lookup Bot in Teams

A Microsoft Teams chatbot that answers floor workers' plain-language questions about where a SKU lives and how many units are on hand.

CategoryChatbots
Enginesim
Difficultybeginner
Triggerchat
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWorker asks about a SKU in TeamsMicrosoft Teams
  • ActionParse message into SKU or search termOpenAI
  • ActionLook up matching records in AirtableAirtableAirtable
  • LogicBranch on exact match, multiple, or none
  • OutputReply with bin, aisle, and quantity in TeamsMicrosoft Teams

What it does

Lets anyone on the warehouse floor type a SKU, part name, or product code into a Microsoft Teams chat and instantly get back the bin location, aisle, and current on-hand quantity. No app to install, no scanner gun to find a free one — just ask the bot.

When to use it

Use it when pickers, receivers, or shift leads constantly interrupt the inventory desk with "where is X / how many do we have" questions. It turns Airtable into a self-serve answer line so the floor keeps moving and the desk stops fielding pages.

How it works

  1. 1A worker messages the bot in Teams with a SKU or product name.
  2. 2An OpenAI step parses the message into a clean SKU or search term, tolerating typos and partial names.
  3. 3The flow queries the Airtable inventory base for matching records, pulling bin, aisle, zone, and quantity.
  4. 4A logic step decides: exact match, several candidates, or nothing found.
  5. 5The bot replies in Teams with the location and on-hand count, or a short pick-list of close matches to choose from.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Microsoft TeamsChannels, chats, files.
  2. 2
    Connect AirtableBases, tables, views, automations.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.