A knowledge base from your cloud files — with answers

The scenario parses each new file in your cloud and stores it in a searchable base the chat answers questions from.

  • Files become a knowledge base
  • Handles PDFs, spreadsheets, documents
  • Answers questions from chat
  • Updates itself on each new file
Default Data LoaderEmbeddings OpenAIGoogle DriveSupabaseSupabase Vector StorePostgres
Set it upScriptera

How it works

To connect Default Data Loader and Embeddings OpenAI, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: When Drive File Created
  2. Check: Loop Over Drive Files
  3. Then: Set File Metadata Fields
  4. Then: Delete Old Doc Rows in Supabase
  5. Then: Delete Old Data Rows in Supabase
  6. Then: Insert Document Metadata to DB
  7. Then: Download File from Drive
  8. Check: Route by File Type
  9. If yes: Extract Text from PDF
  10. Then: Insert Embeddings to Vectorstore
  11. If no: Extract Data from Excel
  12. Then: Aggregate Tabular Data
  13. Then: Summarize Tabular Data
  14. Then: Build Schema and Data
  15. Then: Update Document Schema in DB
  16. Then: Insert Table Rows to DB
  17. If no: Extract Data from CSV
  18. If no: Extract Text from Document
  19. Then: Load Document Data
  20. Then: OpenAI Embeddings
  21. Starts when: When Drive File Updated
  22. Then: Split Text into Chunks
  23. Then: Create Document Metadata Table
  24. Then: Create Document Rows Table
  25. Then: Create Docs Table and Match Fn
  26. Starts when: When Chat Message Received

You can launch this Default Data Loader + Embeddings OpenAI integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios