Chory Lab Free Ordering App

A free and secure ordering app, made by one overwhelmed PI for other overwhelmed PIs.

Ordered
Shipped
Delivered
Received

This is a completely free and customizable ordering app for research labs, from one overwhelmed PI to another.

Most universities have an internal ordering system, but it is built for all of procurement, not for your lab. These systems can be finicky and hard to connect to anything else, and often not everyone has access (or should see everything in them). Some labs give every student access, which gets messy. Others leave ordering to one person, often a student, and too much of the burden falls on their shoulders.

So I'm sharing the code I've built over the last few years to help. It gives your group one place to request, approve and track everything you buy, including the extra steps your university requires. Your catalog, budgets and chemical safety records live there too, and you can add more, since the code is yours (I hope you will!).

There is no one-size-fits-all way to run a lab's ordering, so this will always be free and yours to build on. Once you have your copy, the code is yours forever to change and improve. No take-backs. You can modify it to fit your needs even if you have never programmed.

And if you love spreadsheets, this is not taking them away. The app runs on top of a single Google Sheet, so your spreadsheet is right there whenever you miss it.

It is very easy to set up and costs nothing to run. Here is how easy.

Request access

Free for academic and non-profit groups. It runs entirely inside your own Google account and sends nothing back to me.

Made for.

  • Research labs of all sizes From a brand-new lab of two to a big group with a lab manager. It handles grants, approvals, safety records and a catalog that learns from what you buy. Trainees can order on their own, with a mentor double-checking or approving their purchases.
  • Teaching labs and lab courses You can split the class into teams or run it student-by-student, and give each team its own budget, with a TA or instructor approving. We're testing it this year in our Biotech Design course.
  • Student teams Undergraduate and master's design teams, clubs, and competition teams like our Duke iGEM team.
  • Primarily undergraduate institutions and non-profits Commercial ordering software usually charges per person, which adds up fast for a small department and is especially infeasible for a large class. This one is free no matter how many people use it.
Ordered items in our lab

If you can copy a spreadsheet, you can install this.

There is nothing to download and no coding. No Terminal, no GitHub, no Python, no Jupyter. Everything happens in your browser, in Google Sheets, and most of it is clicking a button and pasting.

  1. Click Make a copy

    Once you are approved, the link in your email opens this page. One click copies the whole app into your own Google account, including the code, a vendor list and a starting catalog.

    landing-make-copy.png
  2. Open Apps Script

    In your new copy, click Extensions, then Apps Script. This is the only time you will need to look behind the curtain.

    extensions-apps-script.png
  3. Click Run

    The setup function is already picked for you. Click Run, allow the permissions, and setup builds your tabs, folders and reminders on its own.

    run-setup-app.png
  4. Paste in what you already have

    Bring your old orders and catalog with you. Paste rows straight from your old spreadsheet, or upload the file your old program exports, and preview everything before it is saved.

    catalog-import-other.png

After that, you click Deploy to get your app's link, and you turn on sign-in by copying two codes from a Google page into the app's Settings. The full setup guide comes with your approval email and walks through every click with screenshots.

How it works.

Secure access through Google

Everyone must sign in with a Google account, and nobody can access the page until you approve them and choose their role, which will vary from lab to lab:

  • Requesters order what they need.
  • Admins place the orders.
  • Approvers sign off on anything over your dollar limit.
  • TAs approve for their class.
  • Trainees, like undergraduates, order on their own, and their mentor gets an email to double-check anything over $100.

You can adjust the approval limits in Settings.

Emails and Slack

  • Approval emails for new users and order limits with a one-click Approve button.
  • Daily digests of what still needs to be done via email/admin slack channels.
  • Direct emails to people in your group.
  • Slack posts for new requests, with progress shown as emoji reactions on the original message.

Setting up Slack and the Gmail filters that route vendor emails to the app takes about 15 to 20 minutes, and the setup instructions walk through it step by step.

One-click approval email
A request in Slack

Every order in one place

Every request goes through the same steps, and everyone can see where every order stands, so nobody has to ask "did that ever get ordered?" in the group chat.

  • If it is over your limit, an approver signs off.
  • Then an admin places the order.
  • Whoever physically opens the box and puts it away marks it received.

A catalog that learns from what you buy

Every item your lab orders goes into the catalog, so nobody has to hunt for the link someone sent two years ago.

  • Full details, including each item's picture, product link, catalog number, pack size and price per unit.
  • Reorder in a few clicks by starting to type the item's name.
  • For something new, paste the product link and the app fills in what it can.

Because everything lives in one Google Sheet, you can import your past order history, fix anything by hand, and take your data with you at any time.

Placing a request
The catalog

Know when you are running low

When your lab orders the same thing more than once, the app learns how often you go through it. Once it has a few orders to go on, it starts to predict when you are probably running low, and the item shows up under Likely due with a one-click Re-order.

That means you can stop running out of gloves and tips without anyone counting what is on the shelf. Yes, there is a box for how many you have in stock, and yes, everyone will forget to update it. That is fine. The predictions only look at when you order, so they keep working anyway.

Items the app thinks you are running low on

Want to see everything it can do? The user manual walks through every feature and setting.

Chemical safety, included.

Chemical safety is part of running a lab, not an afterthought, so we build it into ordering.

  • Automatic lookup. When someone orders a chemical, the app looks it up in PubChem, so the CAS number, hazard statements and pictograms fill in automatically.
  • Safety data sheets. You can attach the SDS to each chemical, so it is one click away for everyone in the lab.
  • Storage. Each chemical's record also shows where it is stored.
Chemical records
Hover a hazard symbol, or click View SDS

Your safety officer will be delighted, possibly for the first time.

Lab analytics.

See who's contributing to the process, and where funds are going

The owner's Analytics tab shows spending by grant, vendor, category and person. It also shows the work nobody sees: who receives and puts packages away, and who keeps restocking the common items everyone uses.

If one person is carrying a disproportionate share, that is worth knowing. It might mean redistributing tasks, setting up a rotation, or making the case for a lab manager. I also find it to be helpful to share this information in the lab for transparency, but stress that it is without judgement.

Who receives orders
Monthly spending

Make it yours.

Admins and owners can change almost everything from the settings tab. Click your name in the top right corner of the app and choose Settings. Owners can see every setting, and admins can see the ordering rules. Nobody should need to touch any code.

Your colors, your process

  • Colors. Pick your own color palette with a live preview. Carolina blue is only a few clicks away.
  • Name and logo. Upload your lab or school logo, and set your lab name and subtitle.
  • Purchasing. I built the app for universities with complicated procurement departments, so it supports purchasing forms, internal codes and standing orders. Every one of those features can be switched off if you want something simple. You can also import PDF templates and set up form autofilling.
  • Classes. Turn on groups and budgets, then split students into teams or give each student a budget of their own.
Name and logo
Colors

Not just for Duke.

The app works at any institution (yes, even UNC). It does not connect to your university's ordering system, so you will still have to place orders there the way you always have. What it does is make it much easier to keep track (as a group) of the parts of the process that are unique to your school, like purchase order numbers, carts, goods receipts, standing orders, purchasing forms and budget codes. You set these up in Settings, and anything your school does not use can be switched off.

I also completely understand that you may not want a Duke blue app, so the colors and logo are yours to change too.

Duke Biomedical Engineering

However, if you are at Duke, please request access with your Duke email and I will add all of the Duke-specific things we have, like our purchasing forms, Buy@Duke settings, GL codes.

Additional features.

These are the small features that add up when you are the one running the lab.

  • Storage locations and boxes. Record where each item was put away, down to the box and slot (drag and drop features included).
  • Default grants. Give each person a default grant ID, so their requests are charged to the right grant automatically.
  • Stock items. Group the different brands of the same thing, like tips, gloves or conicals, and reorder in one click.
  • Item ratings. Lab members can rate items and leave notes, so you know which antibody actually worked.
  • Reused justifications. Reordering something fills in the justification from the last time it was ordered to help with audit tracking.
  • Duplicate check. A regular sweep flags when two people have requested the same thing.
  • Price comparisons. Record what other vendors charge for the same catalog number.
  • Vendor logins and discount codes. Kept in one place, behind a password.
  • Shipping locations. Save your building and room addresses, with a default.
  • Standing purchase orders. Track them with their dates and limits.
  • Custom DNA orders. Oligos, gene fragments and sequencing, with your own pricing.
  • Bulk orders and past orders. Order many items from one vendor at once, and import your old order history.
  • Invitations. Invite people straight into a role instead of waiting for them to request access.
  • Weekly reminders. Each person gets a nudge about their own orders that need attention.
  • Flags and comments. Report a problem with an order, and the conversation stays on that order.
  • Equipment/Vendor logins. Keep logins for instruments and lab computers with everything else.
  • Download your data. You can export everything at any time, it's always in Google Sheets.

...and probably a dozen things I have forgotten. Since the code is yours, you can add whatever is still missing.

Wish it did one more thing?

Have you ever wanted a feature that no ordering app has, because it only makes sense for your lab? Since the code is yours, you can add it. You describe what you want in plain English, and Claude or ChatGPT writes the change and tells you exactly what to click. The setup guide includes my guidelines for vibe coding safely and a starter file that teaches Claude how the app works, so you can start making changes in your first session.

A few ideas that will look different from lab to lab:

  • Mouse colony tracker. Cages, strains, breeding pairs and weaning dates, next to the orders for chow and bedding.
  • Equipment map. A floor plan of your lab where you click a freezer, shelf or instrument to see what is stored there.
  • Instrument booking. A sign-up calendar for the confocal, the plate reader or the one good centrifuge.
  • Maintenance reminders. Pipette calibration, biosafety cabinet certification and CO2 tank swaps, with an email when each is due.
  • Plasmid and cell line registry. Each construct with its map, sequencing results and freezer location.
  • Antibody log. Which lot worked, at what dilution, and in whose hands.
  • Buffer recipes. Your lab's recipes, with a button that orders whatever you are out of.
  • Onboarding checklist. Trainings, keys, accounts and safety forms for each new lab member.
  • Core facility charges. Upload the monthly sequencing or mass spec bill and charge each line to the right grant.
  • Field samples. Collection sites, dates and storage for ecology and plant labs.

Why I made this.

To all the new PIs out there: starting a lab is hard, and running one day-to-day is harder. We all want to (have to) be responsible with our funding... we try not to waste reagents, not to order the same thing twice, and want to know what we have and where it is. It is also a lot for new PIs to manage all of this in between writing grants and sleeping (sometimes).

TBH, all institutional ordering systems are terrible by design because different kinds of labs need different systems, and one institutional system rarely fits any of them well. Understandably, not everyone can have access and often a lot of the work ends up landing on one person. Invisible work can eat up students' time that should go to research, and sometimes orders quietly get lost. If everyone places direct orders on their own, there is little accountability, and then five people buy the same antibody ten times and blow through your entire R01.

Every group solves this differently. Some use a shared spreadsheet, some use Airtable, and some pay for a service whose features and prices keep changing (never downward). I wanted something that works well, that anyone can change, and that a small lab or a single undergraduate course could afford, which in this case means free.

When I started my lab, I had seen and set up a lot of different systems at my various institutions… none of which were perfect. Early on, a few wrenches got thrown into my plan and my spreadsheet was getting unwieldy. I also wanted better communication so that we could easily track things down when needed, and since my lab already used Slack, this seemed like a good place to start. Nothing really seemed to meet our needs, so I decided to just solve the problem myself.

In parallel, I also teach a senior design course, Biotech Design (BME 406) at Duke, where an important part of the course is teaching students to plan experiments responsibly (each team has a budget for its own supplies). A lot of that ordering work falls on our amazing teaching lab staff, so we also needed a better system that would work with student groups. Paying a per-seat price is not really an option for a class of 40+ students or for managing a teaching budget, so I made something that can do that too.

I fundamentally believe that learning to appreciate the cost of doing science matters, especially for students who want to start their own labs or companies one day, at a time when funding is so hard to come by. When students see what things cost and can plan experiments around a budget, they become more thoughtful about how they spend, and I hope that those habits follow them into every lab they join. That experience is especially important for undergraduates, so this is meant just as much for teaching labs, iGEM teams, and other undergraduate projects as it is for research labs. And let's be honest… Many of us also trained in well-funded labs where nobody ever looked at a price, so the first year as a PI comes with a bucket of ice water: that HHMI discount did not come with you, and oligos cost real money. Nobody teaches you what it means to spend, so I wanted a tool that makes it easier for you and your trainees to see.

Anyways, I decided after beta testing in my lab that it was finally time to share this. To be very honest, while I will keep improving our lab's version, I am sharing this one as a starting point rather than something I plan to keep updating. With tools like Claude, it is now easy to change it yourself, and I hope you make it your own, like we have. (I also included some tips for anyone who finds this intimidating and wants to learn to make their own changes easily. Disclaimer: I am NOT a programmer.)

Get it.

For a school team, the teacher or adult advisor should send the request. For a lab, please have a PI send the request.

Request access
  1. Request access

    Fill in the short form with your institutional email, the Google account you will copy the app with, your PI or instructor, and a link to your group's page.

  2. Confirm your academic email

    I will send a confirmation link to your academic/institution address.

  3. Get approved

    I will review each request myself, approve your access, and email you the step-by-step setup instructions.

  4. Copy and set up

    From the install guide you'll just need to copy a spreadsheet, run one setup function, and publish it for your group as a web app. It takes about 30 minutes, and the instructions explain every click (I really tried to make it so a non-human primate could do it).

Questions.

Will my copy get updates?

No, and that is on purpose. Your copy is independent, so nothing changes without you. You have all of the code, so it is yours to keep and change.

Can people outside my group see our orders?

No. Only people you approve can use or see the app, and only you and the editors you choose can open the spreadsheet. Files people attach are stored in Google Drive folders within the main account.

Do I need a Google Workspace account?

No. A free Gmail account works. A shared lab Gmail account is best, so the app does not depend on one person.

Is it Duke-specific?

No. Institution names, purchasing systems, codes and forms all come from Settings. Copies made for groups outside Duke contain no Duke data.

Support

This is a tool from one research lab, shared as is, so I cannot promise support or new features. If you get stuck, the troubleshooting section of the setup instructions is the best place to start. Claude can also solve a lot of these problems for you.

Optional feedback survey

The request page also has a short, optional, anonymous survey about your group and how you order now, so I can understand who uses the app and make it better. Nothing from inside your copy of the app is or can ever be collected.

Terms, in short

Copyright © 2026 The Chory Lab, Duke University. It is free for academic and non-profit groups. You are free to use it in your group and change it however you like. That is the point, and I hope you improve it. Please do not share copies or the template link outside your group; anyone else can request their own access. Full terms of use.

What does it cost to run?

The app itself is free and has no subscription. One optional extra costs a little: the ChatGPT API, which reads messy order numbers and product pages, costs our lab a few cents a month. Saving vendor emails as PDFs for your records is built in and free, and Slack works on a free workspace.

How do I use it?

The user manual walks through every page and setting, with screenshots, for lab members, admins and owners.

Open the user manual

Permissions and privacy.

When you set it up, Google will show a permission screen and call the app "unverified". That just means Google has not reviewed this app. It is your own copy, running in your own account, and nobody else, including me, can run it or see its code or its data.

PermissionWhy
Your spreadsheetsReads and writes the app's own spreadsheet, and any other sheet you choose to link.
Your Google Drive filesCreates the app's folder and saves files people attach. It only works inside its own folder and files you point it at.
Your email addressSo the app knows who is signed in.
Background tasksSends notifications and digests on a schedule.
External servicesOnly the ones you turn on: Slack, ChatGPT or Claude, PubChem, and vendor pages when you add an item from a link.
Send email as youOrder notifications and digests. These notifications will come from this email account.
Read your emailOnly for the optional email intake, if you turn it on. It looks for vendor emails sent to the addresses you set up, and never sends, changes or deletes email.

The people in your group are asked for much less: when they sign in, the app sees only their name and email address.

What it tracks

Your copy keeps track of orders, the people in your group, the files they upload, and a log of every change with who made it and when. All of it lives in your spreadsheet and your Drive, and you can read, export or delete any of it.

What I see

Nothing from your copy. There is no usage tracking and no connection back to me. The only information I hold is what you put on the request form, kept privately and used to approve access, count how many groups use the app, and email you about updates if you ask.

Last updated 7 November 2026. Copyright © 2026 The Chory Lab, Duke University. Free to use and change for your own group (terms).