Analysis across a stack of reports — a ready document with conclusions

The scenario builds a knowledge base from your reports, answers complex questions from it and writes a ready, structured analysis into a document.

  • Takes the report list from Google Sheets and downloads them from express
  • Builds a Pinecone knowledge base from the documents
  • Answers complex questions across the reports
  • Writes the ready analysis into Elasticsearch
Pinecone Vector StoreEmbeddings Google GeminiDefault Data Loader
Connect Pinecone and launchScriptera

How it works

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

  1. Starts when: When clicking ‘Test workflow’
  2. Then: AI Agent
  3. Then: Save Report to Google Docs
  4. Then: Pinecone Vector Store
  5. Check: Loop Over Items
  6. Then: Download File From Google Drive
  7. Then: Embeddings Google Gemini
  8. Then: Default Data Loader
  9. Then: Recursive Character Text Splitter
  10. Then: Vector Store Tool
  11. Then: Google Gemini Chat Model1
  12. Then: OpenAI Chat Model
  13. Then: Pinecone Vector Store (Retrieval)
  14. Then: Embeddings Google Gemini (retrieval)
  15. Then: List Of Files To Load (Google Sheets)

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

Similar scenarios