Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Email Automation

Email Automation

Parse Inbound Gmail Purchase Orders with OpenAI into Google Sheets

Runs on each new Gmail message, extracts purchase order number, delivery date and SKU lines with OpenAI, and writes the structured order data to Google Sheets.

Import it free Sign in to open it

What it does

### Test the workflow with this email! #### How? 1. Send this email to the Gmail box you set up in your credentials. 2. Click on Test workflow ### Email Email Subject: Inbound Order PO45231 – Expected Delivery on 2025-03-27 Email Body: Dear LogiGreen Team, Please find below the details of the upcoming inbound order. Purchase Order: PO45231 Expected Delivery Date: 27/03/2025 Order Lines: SKU: HERM-SHOE-001 — Qty: 120 SKU: HERM-BAG-032 — Qty: 45 SKU: HERM-WATCH-105 — Qty: 30 SKU: HERM-SCARF-018 — Qty: 80 Let us know if you need any additional details. Best regards, Sophie Lambert Admin Assistant – Hermas Logistics 📞 +33 1 23 45 67 89 78 84 ✉️ sophie.lambert@hermas.com

The steps

  1. AI Agent
  2. OpenAI Chat Model
  3. Structured Output Parser
  4. Store Purchase Order Lines
  5. Email Received
  6. Is PO?
  7. Format Purchase Order Lines
  8. Error Handler

Similar automations

Documents, PDF & OCRProcess Purchase Orders from Outlook Excel Files with OpenAI16 stepsE-commerce & PaymentsSend Shopify Orders to Business Central Sales Orders31 stepsE-commerce & PaymentsSync Shopify Orders to Business Central Sales Orders131 stepsDocuments, PDF & OCRExtract Gmail Purchase Orders into Sheets with OpenAI10 steps