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.