Skip to content
OQVIAN

Automating order emails into stock and sheet updates

If someone on your team reads each order email and types it into a sheet and a stock system, that work can be automated. A workflow reads the email, pulls out the items, updates stock and the order sheet, and replies to the customer. Orders it cannot read clearly go to a person.

5 min read

By hand today

  • Open the email and find the items and quantities.
  • Check stock, then type the order into the sheet.
  • Update the stock count.
  • Write a confirmation to the customer.

As a workflow

  • A new email in the orders inbox starts the workflow.
  • Items, quantities and customer details are pulled out of the email. Fixed-format emails use rules; free-text emails use an AI step.
  • Stock is checked and reduced, and the order is added to the sheet.
  • The customer gets a confirmation, or a note that an item is short.
  • Anything unclear goes to a review queue instead of guessing.

Where it goes wrong, and how to stop it

The common failures are duplicate orders when an email is processed twice, and wrong quantities from a badly written email. Give each email an ID so it is only processed once, and send anything below a confidence threshold to a person.

Try it first

The demo on our Automate page runs this kind of workflow in your browser.

Run the demo