Operations · Inventory
Medical Store Inventory Management
A chat assistant that answers stock, manufacturer and prescription questions from an Airtable inventory.
The problem
Pharmacy staff are asked all day whether a medicine is in stock, which brand it is and whether it needs a prescription. Checking a register or a spreadsheet each time is slow.
The solution
A chat assistant that answers from the store's inventory in Airtable. Ask for the stock of a medicine, or which medicines are in a category, and it replies with the quantity, the manufacturer and whether a prescription is needed. The workflow also has a tool to update a record.
How it works
- A staff member asks in the chatFor example: stock quantity of Augmentin 625mg.
- The AI agent reads the questionA Google Gemini model with chat memory works out what is being asked.
- It searches the inventoryThe agent searches the records in Airtable.
- It answers with the detailsStock quantity, generic name, manufacturer and a prescription note.
- It can update a recordA second Airtable tool lets the agent change a record.
See it working
What the demo shows
- “Stock quantity of Augmentin 625mg” answered with 200 tablets.
- “Which tablets are available in the Antibiotics category?” answered with the generic name, stock quantity, manufacturer and a note that it needs a prescription.
- The run log showing the Gemini model, the memory and the Airtable search all completing.
A good fit for
- Pharmacies and medical stores
- Small shops with a product list and many stock questions
- Warehouses and offices that track items in a table
Want something like this for your business?
Tell me what slows your team down. I will tell you whether it can be automated and how it would work.
mujtaba078123@gmail.com · Karachi, Pakistan (UTC+5)