# Google Drive

> Let your assistants search and read your Google Drive, including shared drives, and save new files into a folder you pick after your Approve. Coming soon.

Status: Coming soon

Google Drive is where most companies keep their plans, contracts, budgets, and decks. Once you connect it, you can ask about your files in plain words ("what does the Q3 plan in my Drive say?") and your assistants search Drive, open the files they need, and answer with a link to each one they used. Ask them to save something ("put this summary in the Board folder") and they find the folder you mean and save a new file there once you approve.

> [!SOON]
> Google Drive is Coming soon. This page describes how it will work. The integrations open at launch are GitHub, GitLab, and Bitbucket.

## At a glance

| | |
| --- | --- |
| Category | Files and storage |
| Status | Coming soon |
| Connects with | Your Google sign-in |
| Access | Reads on its own; saving a new file waits for your Approve |
| Used by | The CEO in chat, and every assistant |

## What assistants can do

| Ability | How it runs |
| --- | --- |
| Search files by name and by the text inside them, in My Drive and shared drives | Reads on its own |
| Read Google Docs, Sheets (every sheet), and Slides | Reads on its own |
| Read Word, Excel, PowerPoint, CSV, Markdown, and text files | Reads on its own |
| List a folder, a shared drive, or your most recently changed files | Reads on its own |
| Find a folder by name and show its full path | Reads on its own |
| Save a new Google Doc, Google Sheet, or text file into a folder you pick | Waits for your Approve |
| Change, move, share, or delete a file that is already there | Never |

Long files are read a page at a time, so an assistant reads only as far as it needs.

## Connect it on stellarfirm.ai

1. Open [Integrations](https://stellarfirm.ai/app/integrations) and pick **Google Drive**.
2. Press **Sign in with Google** and pick the Google account your assistants should work with.
3. Google asks you to let StellarFirm **see, edit, create, and delete all of your Google Drive files**. Press **Allow**. Google offers only that one permission for saving into a folder you already have, so it reads broader than what StellarFirm does: your assistants read files, and save a new file only after your Approve. StellarFirm never changes, moves, shares, or deletes a file.
4. You come back to the Google Drive page, which now says **Connected** and the account you signed in with.
5. Ask in chat: "find the latest budget in my Drive and summarize it".

There is nothing to install and nothing to paste. Your sign-in is stored encrypted in StellarFirm cloud and is never shown back to you.

### If your company uses Google Workspace

Your Workspace administrator decides which apps people may sign in to. If Google says the app is blocked or needs approval, send your administrator the steps in [For IT administrators](/docs/trust/it-administrators#google-workspace), then sign in again.

## Saving a file

1. Ask in chat: "save this summary as a doc in the Board folder in my Drive".
2. The assistant looks for folders with that name. When more than one fits, or none does, it asks you which one, with each folder's full path.
3. It writes the file and asks to save it. On [Approvals](/docs/ceo/approvals) you see the file's name, whether it becomes a document, a spreadsheet, or a text file, and the folder's full path. Nothing is saved before you press **Approve**.
4. Once approved, the file is saved and the assistant answers with its link.

Markdown becomes a Google Doc and CSV a Google Sheet, so the file opens as a normal Drive file. A new file never replaces one with the same name. If the folder changed name since the assistant found it, nothing is saved and the assistant looks again.

If you connected Google Drive before saving was possible, the Google Drive page says **Connect again to allow saving**. Your assistants keep reading until you do.

## Connect it in the desktop app

The desktop app connects Drive with a Google Cloud app your company owns:

1. In Google Cloud, create a project, turn on the **Google Drive API**, and create an **OAuth client** (Web application).
2. Sign in once with that client and the read-only Drive permission to get a refresh token. The desktop app reads with it; saving to Drive from chat is on stellarfirm.ai for now.
3. On the computer that runs your assistants, set `GOOGLE_CLIENT_ID`, `GOOGLE_CLIENT_SECRET`, and `GOOGLE_DRIVE_REFRESH_TOKEN`.
4. Switch Google Drive on and to live in the assistants' configuration.

## Pause or disconnect

- **Turn off** keeps the sign-in but stops your assistants reading Drive.
- **Disconnect** deletes the sign-in from StellarFirm and tells Google to end StellarFirm's access.
- You can also remove StellarFirm at any time from your Google account under **Security, Your connections to third-party apps and services**.

## Good to know

- Assistants see exactly what your Google account can see. Sign in with an account that has access only to what they should read, if you want a tighter boundary.
- PDFs, pictures, and videos are listed but not read from Drive. Download a PDF and attach it to the chat, and the assistant reads it.
- A file larger than 20 MB is not read from Drive. Attach it to the chat instead.
- Reading a file never changes it, and Google's own sharing settings never change. A saved file takes the sharing of the folder it goes into.
- Calls to Google Drive do not use StellarFirm credits. Only the assistant's own thinking does, as with every answer.

## Prompts

```prompt title="Summarize a document"
Find the Q3 plan in my Drive and summarize the goals, the owners, and the dates.
```

```prompt title="Answer from a spreadsheet"
Accountant, open the budget spreadsheet in my Drive and tell me which teams are over budget this quarter, with a link to the file.
```

```prompt title="Save a summary"
Summarize this week's sales calls and save it as a doc in the Sales folder in my Drive.
```

```prompt title="Check a contract"
Legal, find the latest signed vendor agreement in Drive and give me a clause checklist with the renewal date.
```

---

Source: https://stellarfirm.ai/docs/integrations/google-drive