An assistant knowledge base that stays in step with your documents

The scenario watches a folder in Google Drive: new and changed files enter the assistant's knowledge in Supabase, while stale and deleted material is cleared out.

  • Edit a file and the knowledge updates
  • Delete a file and its answers disappear
  • Every chunk carries its document's context
  • The assistant answers from current documents
Google DriveSupabaseSupabase Vector StoreEmbeddings OpenAIDefault Data LoaderSupabase
Set it upScriptera

How it works

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

  1. Starts when: When chat message received
  2. Then: AI Agent
  3. Then: Simple Memory
  4. Then: OpenAI Chat Model
  5. Then: Google Drive
  6. Then: Extract from File
  7. Then: Set Text
  8. Then: Generate Hash
  9. Then: Search Record Manager
  10. Check: Switch
  11. If yes: Create Row in Record Manager
  12. Then: Basic LLM Chain
  13. Then: Set Text for Chunking
  14. Then: Call My Sub-workflow
  15. Check: Loop Over Items
  16. If no: Delete Previous Vectors
  17. Then: Aggregate
  18. Then: Update Record Manager
  19. Then: Structured Output Parser
  20. Then: OpenAI Chat Model1
  21. Check: Loop Over Items1
  22. Then: Search Record Manager1
  23. Check: If1
  24. If yes: Delete Previous Vectors1
  25. Then: Aggregate1
  26. Then: Delete Record from Record Manager1
  27. Then: Google Drive2
  28. Starts when: Watch GD Trash
  29. Starts when: Watch GD RAG Files
  30. Starts when: When Executed by Another Workflow
  31. Then: Embedding
  32. Then: Edge Function
  33. Then: Query Vector Store
  34. Then: Supabase Vector Store1
  35. Check: Loop Over Items2
  36. Then: Aggregate2
  37. Then: Add Context
  38. Then: Set Up Chunks for Embedding
  39. Then: Wait
  40. Then: Embeddings OpenAI1
  41. Then: Default Data Loader
  42. Then: Recursive Character Text Splitter
  43. Then: Recursive Splitter2
  44. Then: Split Out
  45. Then: Metadata
  46. Then: OpenAI Chat Model2

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

Similar scenarios