Data from email attachments — straight into a table

The scenario reads attachments in почта — spreadsheets, PDFs, images — extracts the data with AI, and lays it out as rows in Stackby.

  • Works with spreadsheets, PDFs and images
  • AI 'sees' pictures and extracts the data
  • Ready rows straight into Stackby
  • Processed emails get a label
Gmail
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Schedule Trigger
  2. Then: Gmail - Get Emails
  3. Then: Domain Filter
  4. Check: Filter Valid Emails
  5. Then: Gmail - Get Attachments
  6. Then: Detect File Types
  7. Check: IF - Has Excel?
  8. If yes: Extract from Excel
  9. Then: Parse Excel Data
  10. Check: Merge All Paths
  11. Then: Parse All Results
  12. Check: Filter Valid Data
  13. Then: Save to Google Sheets
  14. Then: Get Gmail Labels
  15. Then: Check Labels
  16. Check: IF - Need Labels?
  17. If yes: Prepare Label Creation
  18. Check: Filter Labels to Create
  19. Then: Create Gmail Label
  20. Then: Get New Label IDs
  21. Then: Merge Label IDs
  22. Then: Prepare Label Application
  23. Check: Has Emails?
  24. Then: Apply Gmail Labels
  25. If no: Pass Existing Labels
  26. Then: Extract Email IDs
  27. If no: IF - Has PPTX/PDF?
  28. If yes: ConvertAPI to PNG
  29. Then: Prepare for S3 Upload
  30. Then: S3 Upload (PPTX)
  31. Then: Collect S3 URLs
  32. Then: Prepare GPT Request (PPTX)
  33. Then: GPT Vision Analysis
  34. If no: IF - Has Image?
  35. If yes: Prepare Image Metadata
  36. Then: S3 Upload (Image)
  37. Then: Prepare GPT Request (Image)
  38. Then: GPT Image Analysis
  39. If no: Prepare GPT Request (Text)
  40. Then: GPT Text Analysis

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

Similar scenarios