Build an AI assistant that searches your files and the live web

Answers team questions using your internal documents and real-time web research, all in one chat assistant.

How the work actually flows

It branches. Exactly one path is taken; runs once per one per drive document.

Pattern: Exclusive Choice (4) · Simple Merge (5) · Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig>"file added or updated"]:::trig s0[["index drive documents"]]:::mi s1[("search indexed knowledge base")]:::store s2["check if web research needed"]:::task s3["combine answer from sources"]:::task trig --> s0 s0 --> s1 s1 --> s2 gx{"× is web research needed"}:::gate s2 --> gx p00["skip web search"]:::task gx -->|"internal answer sufficient"| p00 p10["search the web"]:::task gx -->|"needs live research"| p10 p11["summarize findings"]:::task p10 --> p11 jn{"○ combine answer"}:::gate p00 --> jn p11 --> jn jn --> s3 out[/"chat answer combining sources"/]:::out pay{{"faster answers without searching multiple systems"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepRuns once per itemA record or sheetOne path onlyPaths rejoinResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
AI Agents & Autonomous SystemsAI Chatbots & AssistantsKnowledge Base & RAGDocument Processing & OCRFile & Cloud Storage
Connects
Google DriveGoogle GeminiPineconeGoogle Sheets
Featured in

The problem it solves

Your team's knowledge is scattered across files in Google Drive, and finding the right answer means digging through documents or searching the web separately. When information changes or someone new joins, getting them up to speed takes real effort.

Who it fits

An operations, research, or knowledge management team that needs quick answers from both internal files and the web.

How it works

  1. New or updated files in your Google Drive folder are automatically read and indexed
  2. Each document is broken into sections and converted into a searchable knowledge base
  3. When someone asks a question in chat, the system searches your indexed documents for relevant answers
  4. If needed, it also researches the question live on the web and summarizes what it finds
  5. You receive a clear answer that combines your internal knowledge and current information
What you get

Answers that combine your files and the web

Your team gets a chat assistant that searches your internal documents and the live web together to answer questions with current, combined information.

What you get

A direct chat answer drawing on both your indexed company documents and live web research.

What you need

A Google Workspace account, a Google Gemini API key, and a Pinecone account.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Back to the AI Playbook