Inbox sorted by topic with a voice summary

The scenario reads every incoming email, works out its topic against a list it maintains itself, logs the email into a table and sends a short voice summary.

  • Reads and sorts every email
  • Keeps and grows the topic list itself
  • Logs the sorted result into a table
  • Sends a voice summary to your messenger
GmailGoogle SheetsTelegramDefault Data LoaderEmbeddings OpenAI
Connect Gmail and runScriptera

How it works

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

  1. Starts when: Gmail Trigger
  2. Then: Fetch full Gmail message
  3. Then: Normalize email fields
  4. Then: Analyze email with RAG agent
  5. Then: Parse AI analysis result
  6. Then: Store processed email
  7. Check: Check for new taxonomy items
  8. If yes: Load taxonomy dataset
  9. Then: Get next taxonomy ID
  10. Then: Append new taxonomy entry
  11. Then: Notify admin about taxonomy update
  12. Then: Generate audio summary
  13. Then: Send audio summary to Telegram
  14. Then: Get row(s) in sheet
  15. Then: Vector store — taxonomy index
  16. Then: OpenAI Chat Model
  17. Starts when: When clicking ‘Execute workflow’
  18. Then: Vector store retriever (RAG tool)
  19. Then: Prepare taxonomy documents
  20. Then: Create embeddings (OpenAI)

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

Similar scenarios