← ClaudeAtlas

create-approved-purchase-orders-from-supplier-approval-emailslisted

Build a Zap on Zapier that reads supplier or approver replies to purchase order alert emails, finds the matching PO in a Zapier Tables register, creates the purchase order in QuickBooks Online, and replies in the same thread. Use when a procurement or finance team approves POs by email and wants approved orders created in the accounting system without retyping them.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Create approved purchase orders from supplier approval emails The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/create-approved-purchase-orders-from-supplier-approval-emails. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** a new Outlook email matching the PO alert search arrives in the inbox (`microsoft-outlook`, `new_email_search`). The search is set to the PO alert emails only, for example a subject containing "PO approval". 2. **AI by Zapier** reads the email and returns the status (approved, denied or changed), the PO number, the approver's name and, for a change, the revised material list. A denied reply, or one with no PO number, stops here. 3. **Zapier Tables** looks up the PO number in the PO register. If no row matches, the run stops and procurement gets an email. 4. **QuickBooks Online** finds the vendor named on the PO row. If there is no vendor, the run stops and procurement gets an email. Otherwise it creates an open purchase order with the PO number, the run date, the amount and the description. A changed status puts the revised materials into the description. 5. **Zapier Tables** marks the PO row as approved (or changed). 6. **Microsoft Outlook** replies in the original thread, naming the approver, the PO number and where to send receipts. Nothing is created in QuickBooks without a matching register row and a matching vendor. ## Ask the user Each `REPLACE_…` value is set per person