Manufacturing

Email Order to Procurement Automation

Reads purchase orders that arrive by email, extracts them with AI, creates a sales order, checks stock and, if there's a shortage, raises a purchase requisition and a work order.

The Email Order to Procurement Automation workflow on the n8n canvas, with its 13 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Manufacturing
Nodes
13
Apps
Email, OpenAI, Slack
Price
Free
Download JSON
On this page

How it works

  1. A Gmail trigger picks up an order email with its attachment.
  2. The document is extracted into structured data.
  3. A sales order is created and stock is checked.
  4. Shortages create a purchase requisition and a work order.
  5. A summary is posted to Slack and emailed.

Use cases

  • Manufacturers
  • B2B suppliers
  • Make-to-order businesses

What you need

This workflow connects to these apps.

  • Email
  • OpenAI
  • Slack

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Gmail account
  • Google Sheets account
  • OpenAI account
  • Slack account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Order tracking → Customer orderGoogle SheetsOrder idSKUCustomer NameEmailPhoneItem NameQuantityPriceTotal
Order tracking → Product inventoryGoogle SheetsItem Name
Order tracking → Purchase RequisitionGoogle SheetsRequest Dateitem nameSKU / Item CodeCurrent QuantityQuantity RequestedPriority
Order tracking → Work Order CreateGoogle Sheetsorder idSKUitem nameCustomer nameQuantity to ProducePlanned Due Date

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
Gmail TriggergmailTrigger
Extract from FileextractFromFile
Structured Output ParseroutputParserStructured
OpenAI Chat ModellmChatOpenAi
Send a messagegmail
Extract Invoice Recordagent
Sales Order CreationgoogleSheets
Stock & Shortage CheckgoogleSheets
If Negativeif
Create Purchase RequisitiongoogleSheets
Create Work OrdergoogleSheets
Send Order Summaryslack

Frequently asked questions

Reads purchase orders that arrive by email, extracts them with AI, creates a sales order, checks stock and, if there's a shortage, raises a purchase requisition and a work order. It's a 13-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Gmail, Google Sheets, OpenAI, and Slack. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 4 tables in Google Sheets. Create them with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the Low-Stock Purchase Order Automation workflow

    Manufacturing12 nodes

    Low-Stock Purchase Order Automation

    Finds products below their reorder level every day, generates purchase orders, emails suppliers and keeps a PO log in Google Sheets.

  • n8n canvas of the AI Crop Advisory for Farmers workflow

    Agriculture27 nodes

    AI Crop Advisory for Farmers

    Gives farmers practical, AI-generated crop advice based on their soil, crop and live weather. Advice is delivered instantly on sign-up and refreshed daily over WhatsApp.

  • n8n canvas of the AI Email Classifier & Slack Router workflow

    AI Automation11 nodes

    AI Email Classifier & Slack Router

    Reads incoming emails, has AI classify each one (support, sales, billing, HR and so on) and notifies the right team on Slack straight away.