An AI assistant that knows your documents and answers in any channel

One assistant reads your sheets, files and knowledge base and answers questions right in your email, chat or messenger. When needed, it checks fresh facts with an outside search.

  • Answers from your documents, not generic filler
  • Works from any channel — email, chat, messenger
  • Loads your files into a search base by itself
  • Checks fresh facts with an outside search when needed
Google Sheets ToolMCP ServerDefault Data LoaderSupabase Vector StoreEmbeddings OpenAI
Connect mcp and runScriptera

How it works

To move data from Google Sheets to Google Drive automatically, use a ready-made scenario — no manual exports.

  1. Starts when: MCP Server Sheets
  2. Then: Google Sheets - Read Data
  3. Then: Google Sheets - Clear Data
  4. Then: Google Sheets - Add Data
  5. Then: Google Sheets - Create Sheet
  6. Then: Google Sheets - Update Data
  7. Then: Google Sheets - Delete Sheet
  8. Starts when: When clicking ‘Execute workflow’
  9. Then: Download file
  10. Then: Add to Supabase Vector DB
  11. Then: Default Data Loader1
  12. Then: Recursive Character Text Splitter1
  13. Then: Embeddings OpenAI1
  14. Starts when: When Executed by Another Workflow
  15. Check: Operation
  16. If yes: Download File1
  17. Check: FileType
  18. If yes: Extract from PDF
  19. Then: Get PDF Response
  20. If no: Extract from CSV
  21. Then: Get CSV Response
  22. If no: Analyse Image
  23. If no: Transcribe Audio
  24. Starts when: Google Drive MCP Server
  25. Then: Read File From GDrive
  26. Then: Search Files from Gdrive
  27. Then: Postgres Chat Memory1
  28. Then: Embeddings OpenAI2
  29. Then: Reranker Cohere1
  30. Then: Anthropic Chat Model1
  31. Then: structured data1
  32. Then: General knowledge1
  33. Then: Think1
  34. Then: Message a model in Perplexity1
  35. Then: search about any doc in google drive1
  36. Then: MCP Sheets
  37. Then: Knowledge Agent1
  38. Then: Reasoning model (recommended)
  39. Then: Calculator
  40. Then: Postgres Chat Memory
  41. Then: OpenAI Chat Model1
  42. Then: HTTP Request1
  43. Then: Linkedin Scraper
  44. Then: Create reports
  45. Then: Send a message
  46. Then: Create structured Reports
  47. Then: Markdown to HTML
  48. Then: OpenRouter Chat Model
  49. Then: Send a text message
  50. Then: Send message
  51. Then: Send a message1
  52. Then: Send a message2
  53. Starts when: Slack Trigger
  54. Then: Set message variable
  55. Then: MAIN AGENT
  56. Starts when: Telegram Trigger
  57. Starts when: Gmail Trigger
  58. Starts when: WhatsApp Trigger

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

Similar scenarios