Invoice bookkeeping from chat: send a photo, get a row and an archived original

You send the invoice to a chat — the scenario reads the document, extracts vendor, number, date and amount, appends a row to the table, archives the original and confirms.

  • Bookkeeping happens from chat — nothing to open
  • Photos, scans and PDFs all work
  • The original document is archived in Databricks next to the record
  • You get an instant confirmation with the amount — proof it landed
Set it upScriptera

How it works

To connect Telegram and Microsoft SQL, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Receive Invoice in Telegram
  2. Then: Download Telegram Invoice File
  3. Then: Detect File Type
  4. Check: Route Supported File Types
  5. If yes: Extract Invoice Text with OCR.space
  6. Then: Extract Structured Invoice Data
  7. Then: Format Invoice Fields for Sheets
  8. Then: Save Invoice Data to Google Sheets
  9. Check: Merge Invoice Data with Original File
  10. Then: Upload Original Invoice to Google Drive
  11. Then: Prepare Confirmation Message Data
  12. Then: Write Telegram Confirmation Message
  13. Then: Send Confirmation to Telegram
  14. Then: Configure Workflow Variables
  15. Then: OpenAI Chat Model
  16. Then: Validate Invoice JSON Output

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

Similar scenarios