Library / AI Agents & Assistants
AI Agents & Assistants
Process Purchase Order Emails with GPT-4o and Google Sheets
When an email arrives in Gmail, an OpenAI agent checks whether it is a purchase order, extracts the order lines and stores them in Google Sheets.
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
- AI Agent
- OpenAI Chat Model
- Structured Output Parser
- Store Purchase Order Lines
- Email Received
- Is PO?
- Format Purchase Order Lines
Similar automations
Documents, PDF & OCRProcess Purchase Orders from Outlook Excel Files with OpenAI16 stepsDocuments, PDF & OCRExtract Gmail Purchase Orders into Sheets with OpenAI10 stepsDocuments, PDF & OCRExtract Purchase Orders from Outlook Excel with OpenAI20 stepsE-commerce & PaymentsEmail Digital Downloads After a PayPal Purchase9 steps