Orders from your inbox — with a stock check and purchase requests

The scenario reads the order from an email in Microsoft Outlook, has the AI break it down, logs it in таблица, checks stock and creates either a purchase request or a work order, notifying Google Chat.

  • The order is parsed from the attachment for you
  • Stock is checked automatically
  • A shortage instantly becomes a purchase request
  • The team sees the summary in Google Chat
Google Sheets
Set it up for yourselfScriptera

How it works

To get Microsoft Outlook notifications in Google Chat, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Gmail Trigger
  2. Then: Extract from File
  3. Then: Extract Invoice Record
  4. Then: Sales Order Creation
  5. Then: Stock & Shortage Check
  6. Check: If Negative
  7. If yes: Create Purchase Requisition
  8. Then: Send a message
  9. If no: Create Work Order
  10. Then: Send Order Summary
  11. Then: Structured Output Parser
  12. Then: OpenAI Chat Model

You can launch this Microsoft Outlook + Google Chat integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios