NetSuite and Mailhook: Wholesale Order Email Intake Template
When a wholesale customer emails a purchase order to your dedicated mailhook address, this Spojit template reads the line items and creates a matching sales order in NetSuite, so B2B orders skip manual entry.
What It Builds
A Mailhook trigger gives the workflow its own inbound email address. Every purchase order sent to it starts a run: a Connector node in Agent mode reads the customer, item SKUs, quantities, and prices from the email body, then a NetSuite Connector node creates a sales order from those values. A Send Email node confirms back to the sender.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that triggers when a wholesale customer emails a purchase order to a mailhook address. Read the customer, item SKUs, quantities, and unit prices from the email, create a matching sales order in NetSuite, and email the sender a confirmation with the NetSuite order number.
Connectors Used
- Mailhook trigger - your own inbound address that starts a run on every incoming purchase order.
- NetSuite - creates the sales order from the extracted line items.
- Send Email - sends the confirmation back to the wholesale customer.
Customize It
Change the prompt to match SKUs against a NetSuite item lookup, set a default warehouse or terms, route to a Human approval node for orders above a dollar threshold, or skip the confirmation email for known accounts. Adjust which fields you pull from the email to fit how your customers format their orders.
Tips
- Use Agent mode for the extraction step so it handles varied email formats; use Direct mode for the NetSuite create so the field mapping stays exact.
- If orders arrive as PDF attachments, add an Attachment node to fetch the file before extraction.
- Give the NetSuite connection permission to create sales orders for the right subsidiary before going live.