Invoices from email — into a sheet on their own

The scenario checks your inbox, tells invoices from ordinary mail, pulls the supplier, number, amount and due date, and enters them into a sheet.

  • Invoice data into Google Sheets with no manual entry
  • Tells an invoice from an ordinary email itself
  • Pulls the supplier, number, amount and due date
  • Runs on a schedule, without you
Microsoft Outlook

How it works

To move data from Google Sheets to Microsoft Outlook automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Schedule Trigger
  2. Then: Get Recent Messages
  3. Then: Markdown
  4. Then: Message Classifier
  5. Check: For Each Message
  6. Then: Microsoft Excel 365
  7. Then: Download Attachments
  8. Then: Split Attachments
  9. Then: Extract from File
  10. Then: Invoice Classifier With Gemini 2.0
  11. Check: Filter Invoices
  12. Check: Has Invoice?
  13. If yes: File-Based OCR with Gemini 2.0
  14. Then: Parse Output
  15. Then: Wait
  16. Then: Empty Response
  17. Then: Model

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