Sort invoices from your inbox into a sheet and folders

The scenario catches invoice emails, unpacks the archives, extracts the data with AI, files documents in storage, and numbers in a sheet.

  • Catches invoices from your inbox and unpacks archives itself
  • AI pulls the number, date, amount and type
  • Files go to storage, data to a sheet
  • No manual unzipping or retyping
Set it upScriptera

How it works

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

  1. Starts when: On Email receipt
  2. Then: Get Filename and mimeType
  3. Check: Filter ZIP files only
  4. Then: Unzip Invoice
  5. Check: Loop Over Items
  6. Then: Get filename and mimeType on extracted docs
  7. Check: Split XML and PDF
  8. If yes: Create initial PDF
  9. Check: Merge both flows
  10. Then: Update PDF with actual name
  11. Then: Get Current Date
  12. Then: Create or update row
  13. If yes: Extract PDF Data
  14. Check: Append both Docs
  15. Then: Aggregate all Data into 1 list
  16. Then: Extract Data from PDF and XML
  17. If no: Extract XML Data
  18. Then: Convert to JSON
  19. Then: OpenAI Chat Model
  20. Then: Calculator
  21. Then: Structured Output Parser

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

Similar scenarios