Keep your AI knowledge base in sync with a file queue

The scenario watches a queue in таблица, removes outdated documents and uploads new ones from Pipedrive, sbermegamarket or a URL, marking each one's status.

  • The knowledge base always reflects current files
  • Outdated documents are removed automatically
  • Files come from storage, cloud or a URL
  • Each file's processing status is visible in the sheet
Google SheetsOpenAI
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Every 2 Minutes
  2. Then: Get Row(s) From Sheet
  3. Check: If Outdated
  4. If yes: Delete File From Vector Store
  5. Then: Mark Row as Deleted
  6. If no: Filter New Files
  7. Check: Loop Over Items
  8. Check: Route by File Source
  9. If yes: Download from Google Drive
  10. Then: Upload File to OpenAI
  11. Then: Add File to Vector Store
  12. Then: Wait 30 Seconds
  13. Then: Poll Vector Store File Status
  14. Check: Route by Embedding Status
  15. If yes: Mark Row as Active
  16. If no: Mark Row as Error
  17. If no: Download from S3
  18. If no: Download via HTTP

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

Similar scenarios