An AI knowledge base from a spreadsheet of questions and answers

The scenario takes rows from a spreadsheet, cleans them, and lays them into a base so an AI can search by meaning and answer from your data.

  • Takes questions and answers from a sheet
  • Prepares them for meaning-based search
  • Files them into a knowledge base
  • An AI finds and answers from them
OpenAI
Set it up for meScriptera

How it works

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

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Get rows from sheet
  3. Check: Merge import Data
  4. Then: Remove HTML
  5. Check: Loop Over Items
  6. Check: Switch
  7. If yes: Code "Question"
  8. Then: Embeddings OpenAI Question
  9. Check: Merge
  10. Then: Merge fields for database insert
  11. Then: Write row to database
  12. If no: Code "Answer"
  13. Then: Embeddings OpenAI Answer
  14. Then: Retrieve existing rows
  15. Then: Build table in Supabase

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

Similar scenarios