An advisor over your data — from database and documents

The advisor decides itself where to find the answer — your database for numbers or your documents for text — and assembles a ready answer.

  • Answers from the database and the documents
  • Picks the right source itself
  • Keeps the data fresh on its own
  • A ready answer to a plain question
Google DriveDefault Data LoaderMySQLEmbeddings Google Gemini
Connect Pinecone and goScriptera

How it works

To connect Microsoft Excel 365 and Google Cloud Firestore, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Cron
  2. Then: MySQL -delete all data
  3. Then: Google Sheets - Read TechRadar
  4. Then: MySQL - insert all from sheets
  5. Then: Download Doc File From Google Drive
  6. Then: Pinecone - Vector Store for Embedding Content
  7. Then: Doc File Data Loader
  8. Then: Google Sheets - Tech Radar
  9. Then: Code - Transform table into rows
  10. Then: Google Docs - Update GDoc
  11. Starts when: Google Drive - Doc File Updated
  12. Then: Content - Recursive Character Text Splitter
  13. Then: Code - Simplify Mapping to Original Query
  14. Then: Execute Workflow - RAG Agent
  15. Then: AI Agent - Output Guardrail
  16. Starts when: API Response - Respond to Webhook
  17. Then: Codes - Simplify Mapping to Original Query
  18. Then: Execute Workflow - Sql Agent
  19. Then: LLM - Determine - Agent Input Router
  20. Check: Determine if is 'RAG'
  21. Starts when: When Executed by Another Workflow
  22. Then: AI Agent -DB Sql Agent
  23. Then: 1_Get DB Schema and Tables List
  24. Then: 2_Get Table Definition
  25. Then: 3_Execute actual query
  26. Then: Pinecone Vector Store (Retrieval)
  27. Then: 4_RagTool
  28. Then: AI Agent - RAG
  29. Then: Embeddings - Tech Radar Data Embedding
  30. Then: Retrieve Embeddings - Tech Radar Vector DB
  31. Then: AI Agent - Retrieval
  32. Then: AI Chat Model - Claude 3.5 Sonnet
  33. Then: AI Chat Model - QwQ 32b
  34. Then: AI Chatmodel - Deepseek 32B
  35. Then: AI Chat Model - llama3-8b
  36. Starts when: API Request - Webhook
  37. Then: User Conversation history

You can launch this Microsoft Excel 365 + Google Cloud Firestore integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios