CHATBOTS
Multi-Warehouse Stock Finder Across Airtable and Postgres
Answers "who has this part" by checking the Airtable floor base for the local site and a Postgres ERP table for sister warehouses.
How it runs
The automated pipeline, trigger to output.
- TriggerWorker asks for a SKU in TeamsMicrosoft Teams
- ActionNormalize request into canonical SKUOpenAI
- ActionCheck local stock in AirtableAirtable
- LogicBranch if local stock is short
- ActionQuery ERP for other sites in PostgresPostgres
- OutputReply with local plus nearest site stockMicrosoft Teams
What it does
When a part is out at the local site, this bot doesn't just say "none." It also queries the central Postgres ERP for on-hand quantities at other warehouses and tells the worker which sister site has it and how many, all in one Teams reply.
When to use it
Use it in a multi-site operation where a stockout locally doesn't mean a stockout company-wide. It saves a phone tree of calls between warehouses and helps the floor decide whether to transfer, backorder, or substitute.
How it works
- 1A worker asks for a SKU in Teams.
- 2An OpenAI step normalizes the request into a canonical SKU.
- 3The flow checks the local Airtable inventory base first for bin and quantity.
- 4A logic step decides: if local stock covers the need, reply now; if short, continue.
- 5The flow queries the Postgres ERP for that SKU's quantity-on-hand at every other site.
- 6The bot replies in Teams with local availability plus the nearest sister warehouse holding stock.
Set it up
What you configure once, before turning it on.
- 1Connect Microsoft TeamsChannels, chats, files.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect AirtableBases, tables, views, automations.
- 4Connect PostgresAny Postgres URL — query, write, migrate.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Chatbots workflows
Discord Onboarding Completion to CRM Sync
The moment a member finishes Discord onboarding, captures their submitted profile answers, creates or updates a contact in HubSpot.
Discord FAQ-Gated Role Concierge
Greets each new Discord member in a private onboarding thread, walks them through required FAQ steps one at a time.
Discord FAQ Free-Text Answer Grader
When a member submits a free-text answer in their onboarding thread, an agent grades it against the canonical FAQ knowledge base, replies with targeted feedback.
Discord verify-button onboarding via web form webhook
Receives a completed external verification form by webhook, matches it to the Discord account, grants the verified role, and confirms back to the member in Discord.
Discord intro-gated role granting concierge
Watches your #introductions channel, uses AI to confirm a new member's intro is genuine and complete, then auto-assigns the verified Member role and welcomes them.
Daily Discord Digest of Repeated WAF False-Positive Reports
Each morning, scans logged Discord WAF reports in Postgres, groups them by the Cloudflare rule that keeps firing.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.