Feed new Google Drive documents into your AI chatbot automatically

Any new file dropped into Google Drive is automatically read and added to your chatbot's searchable knowledge.

How the work actually flows

It branches. Exactly one path is taken; runs once per each text chunk.

Pattern: Exclusive Choice (4) · Simple Merge (5) · Multiple Instances without Synchronization (12)

flowchart TD trig>"new file added to drive"]:::trig s0["detect file type"]:::task s1["extract text content"]:::task s2[["chunk and tag text"]]:::mi s3[("add to knowledge base")]:::store trig --> s0 s1 -->|"one per each text chunk"| s2 s2 --> s3 gx{"× which file type detected"}:::gate s0 --> gx p00["extract pdf text"]:::task gx -->|"pdf file"| p00 p10["extract office text"]:::task gx -->|"word or excel file"| p10 p20["extract doc text"]:::task gx -->|"google doc"| p20 jn{"○ text ready to chunk"}:::gate p00 --> jn p10 --> jn p20 --> jn jn --> s1 out[/"updated searchable knowledge base"/]:::out pay{{"chatbot answers stay current"}}:::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 Chatbots & AssistantsKnowledge Base & RAGDocument Processing & OCRSpreadsheet & Database OpsFile & Cloud Storage
Connects
Google DriveSupabaseOpenAI

The problem it solves

Your AI chatbot is only as good as the information it can search, but manually uploading and reformatting every new PDF, spreadsheet, or Word document to feed it is tedious and easy to forget. Important documents end up sitting in a folder the chatbot never sees.

Who it fits

A business running an internal or customer-facing AI chatbot that needs to stay current with new documents.

How it works

  1. A new file lands in a designated Google Drive folder
  2. The system detects the file type, whether PDF, Word, Excel, or Google Doc
  3. The text is extracted and broken into manageable chunks
  4. Each chunk is tagged with details like the file name and creation date
  5. The content becomes part of your chatbot's searchable knowledge base
What you get

Documents your chatbot can answer questions from

Every new file you save to Drive becomes something your chatbot can search and answer questions from right away.

What you get

An automatically updated knowledge base that keeps your AI chatbot's answers current with your latest documents.

What you need

A Google Drive account, a Supabase database, and an OpenAI API key.

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