# Use Google Sheets, Google Docs and Google Drive

Lists what the assistant can do with Google Sheets, Google Docs and Google Drive, and which actions ask you first.

Google Sheets, Google Docs and Google Drive are available on every plan, including Free. Connect each one from its card in **Connectors**, or from a card in chat the first time the assistant needs it.

## Google Sheets

The assistant can:

- List your spreadsheets, get spreadsheet details, and search a sheet.
- Read a range, find the used range, and read a sheet by its name.
- Create a spreadsheet, add or rename a worksheet, duplicate a worksheet, and update cells.
- Append rows, sort a range, and export a sheet to CSV or to an Excel file.
- Import a CSV or Excel file from your files into a sheet, in your personal workspace or a shared one, within the file size limit.

Every change asks you first: creating a spreadsheet, changing cells, adding rows, sorting, importing a file, adding, renaming, copying, moving, clearing or deleting a worksheet, and find and replace. Reading and exporting do not. To change which actions ask first, read [How do I approve, allow or stop an action from a connector?](https://support.bluedeer.ai/connectors/overview/approve-connector-actions.md).

## Google Docs

The assistant can:

- Create a document, and read its content.
- Insert text at a position in a document, or at the end.

Creating a document, inserting text, and find and replace across a whole document ask you first. Reading does not.

## Google Drive

The assistant can:

- List and search your files, and get details about a file.
- Read a file's text, and create a folder.
- Upload a file you can open in Bluedeer (an artifact in the File manager, or a file sent or an artifact made in the chat) to Drive, within the file size limit. It can stay as it is, or become a Google Doc (from Word, OpenDocument, text, Markdown or HTML), a Google Sheet (from Excel, CSV or OpenDocument) or Google Slides (from PowerPoint). When a file of the same name is already in the folder, the approval card offers **Replace** next to **Upload**: Upload adds a second file, and Replace puts your file in as a new version of the one in Drive, which keeps its link, its sharing and its earlier versions in Drive's version history. When the folder has more than one file of that name, the card lists them (up to 10, the most recently changed first), each with its name, when it was last changed, who owns it and a link to open it in Drive: pick the one to replace, then choose Replace. Replace stays greyed out until you pick one. Once you have chosen Replace, the card names the file you picked, with when it was last changed, who owns it and a link to open it in Drive, also when you open the chat again later. A file that can't be replaced is listed greyed out and can't be picked: point at it (on the phone, press it) to see why. A file can't be replaced when it is a Google Doc, Sheet or Slides and your file would not become the same kind, when you can't edit it, or when Bluedeer did not create it and you have not given Bluedeer full access to your Drive; with only one file of that name, Replace itself is greyed out with the reason. If the file you picked is changed, renamed, moved or deleted after the card is shown, nothing is replaced and the assistant asks again. Bluedeer replaces a file only when you choose Replace on the card, even if you set uploads to Drive to run without asking.
- Save a Drive file into your File manager, within the file size limit. Google Docs, Sheets and Slides are saved as Word, Excel or PowerPoint files, or as PDF if you ask. Saving the same version again gives back the same file. A saved Drive file can then be attached to an email like any other file.
- Move a file to the trash.
- Share a file with one email address, as a reader, commenter or writer.

Uploading a file, creating a folder and moving a file to the trash ask you first; the card names the file. For an upload, the card shows the file (its name, type, size, version and where it comes from), the Drive folder it goes to, and who can open that folder, such as **Only you** or **Shared with 2 people**. The first upload asks you to allow Bluedeer to add files to your Drive. Saving a Drive file into your File manager does not ask first. Sharing a file asks you first too: Bluedeer shows an approval card in chat, and nothing is shared until you approve it. Check who the file will be shared with before you approve: the card lists each person and their level of access, and says so plainly when the file would be open to anyone with the link. To stop it asking, change **Share a Google Drive file** under **Settings** → **AI & Chat** → **Connector permissions**, in **Google Drive**.

## What you see in the chat

Results from these apps appear as cards in the chat, on the web and on the phone:

- A list of files shows the first files with their owner and when they were last changed, and a button to show the rest. A file's name opens it in Google, and each row has a menu of actions.
- One file shows a sketch of its kind, or **No preview available**, with its details and a link to open it.
- A document shows the start of its text and its headings.
- A range of a spreadsheet shows a grid of its first rows, with a button to show more. A wide range scrolls sideways inside the card, and the card says how many more rows and columns the sheet has.

The card shows part of a long result. The assistant can still use all of it.

## Stop being asked

Choose **Don't ask again** on a card to stop asking for that kind of change. To stop asking for every change in one app, turn off **Ask before changes in** that app (for example **Ask before changes in Google Sheets**) in **Settings** → **AI & Chat** → **Connector permissions**. Changes there then happen without asking.

## Related

- [Use Gmail and Google Calendar](https://support.bluedeer.ai/connectors/built-in/use-gmail-and-google-calendar.md)
- [What can a connector see and do?](https://support.bluedeer.ai/connectors/overview/connector-safety.md)
