Scanned invoices into a table, with an email summary

The scenario recognises scanned invoices from a folder, pulls amounts and details into a table and emails a summary of the processed invoices.

  • Invoice data is recognised from the scan
  • Amounts and details land in a table
  • Works with both scans and photos
  • A summary of invoices arrives by email
Google DriveMailgun

How it works

To connect AWS DynamoDB and Google Drive, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: When clicking 'Execute workflow'
  2. Then: Fetch 50 docs
  3. Then: Download file
  4. Check: Loop Over Items
  5. Then: Prepare a table
  6. Then: Mailgun
  7. Then: Set file identity
  8. Then: Save base64
  9. Check: Switch Mime Type
  10. If yes: Analyze Image
  11. Then: Edit Fields
  12. Then: Information Extractor
  13. Then: Append row in sheet
  14. If no: Extract from File
  15. Check: Identify CamScanner
  16. If yes: Re-set base64
  17. Then: Convert to File
  18. Then: OpenAI Chat Model
  19. Starts when: Check for new invoices

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