Invoices from email — read, checked and filed

The scenario reads an invoice from the email, checks the data against a reference, logs it into a sheet with recalculated totals and files the document into folders.

  • Invoice read from the attachment
  • Data cross-checked against a reference
  • A row in the sheet and recalculated totals
  • File sorted into folders
Set it upScriptera

How it works

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

  1. Starts when: Schedule Trigger
  2. Then: Date & Time
  3. Then: Today's Date
  4. Then: Gmail Trigger
  5. Then: Date From Email Subject
  6. Then: Read Message
  7. Then: Search Month Folder
  8. Check: Month Folder Found?
  9. If yes: Create Month Folder
  10. Then: Search Day Folder
  11. Check: Day Folder Found?
  12. If yes: Get Parent Folder ID
  13. Then: Create Day Folder
  14. Then: Get Day Folder ID
  15. Check: Merge
  16. Then: Get Attachments
  17. Then: Upload Invoices
  18. Then: Extract from File
  19. Check: Loop Over Items
  20. Then: Notify
  21. Then: Text Extractor
  22. Then: Post-Processing
  23. Check: If
  24. If yes: Send Raw Text Again
  25. If no: Split Out
  26. Then: Generate Unique Key
  27. Then: Send Invoice Data
  28. Then: Fetch Master Data
  29. Then: Validation
  30. Then: Update Results
  31. Then: Get last Index
  32. Then: Update Totals
  33. Then: Wait
  34. Then: OpenRouter Chat Model

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

Similar scenarios