> For the complete documentation index, see [llms.txt](https://support.hivo.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.hivo.co/integrations/google/google-sheets.md).

# Google Sheets

The HIVO Extension for Google Sheets is a solution that directly integrates the HIVO asset library into your online spreadsheet management interface. This feature allows you to access, search using smart filters, insert, and manage digital assets quickly right within the cells of Google Sheets.

### Installation & Login

#### 1. Install the Extension

* In your Google Sheets workspace, navigate to the top menu bar and select **Extensions > Add-ons > Get add-ons.**
* The Google Workspace Marketplace dialog will open. In the "Search apps" bar, enter the keyword “**HIVO”**.
* Select the **HIVO app**, click Install, and follow the on-screen prompts to complete the integration.

<figure><img src="/files/3gmeTcD0N8AGqPtVj5Qk" alt=""><figcaption></figcaption></figure>

#### 2. Where to find and open the HIVO Connector

After the extension has been installed, you can access it from the **Extensions** menu.

* Open your Google Sheets file.
* Select **Extensions → HIVO → Open HIVO Connector**.

The **HIVO Connector** panel will then open on the right-hand side of your workspace.

<figure><img src="/files/6cqb1CEOjEYY9EAoqutF" alt=""><figcaption></figcaption></figure>

#### 3. Account Login

Open the HIVO Connector panel and choose the login method that matches your account:

* **Standard Login**: Enter your system Email and Password.
* **Passwordless Login**: For accounts utilizing quick authentication methods.

<figure><img src="/files/jxCSLOYrJYgCYq5PhdQq" alt=""><figcaption></figcaption></figure>

### Switch View Modes & Searching HIVO Assets in Google Sheets

#### 1. Switch View Modes

To help you manage and oversee your assets efficiently, the HIVO Connector on Google Sheets provides the following flexible display modes:

* **Library View:**
  * **Asset view:** Visually displays your entire asset list in a grid or list format.
  * **Folder view:** Displays assets neatly organized according to the system's folder tree structure.

<figure><img src="/files/yt3QzUCyRfetah0qislO" alt=""><figcaption></figcaption></figure>

* **Collections View:** Supports two specialized display modes depending on your categorization needs:
  * **Collections view:** View assets grouped by assigned task-based collections.
  * **Category view:** View assets organized and segmented by specific thematic categories.

<figure><img src="/files/QiU7NKxMjIomPrMekiak" alt=""><figcaption></figcaption></figure>

#### 2. Searching HIVO Assets in Google Sheets

Allows you to Search by tags or keywords to precisely locate the exact asset you need in an instant, making data reconciliation or product catalog building on your spreadsheets much faster.

<figure><img src="/files/jDK7Cx9Xl4cr5wlh8pmC" alt=""><figcaption></figcaption></figure>

### Inserting and Replacing HIVO Assets in Google Sheets

#### 1. Insert an Asset into the Spreadsheet (Import Asset)

* Browse or search for the asset you want to use in the HIVO Connector panel.
* Click to **select the exact desired Version** of that file.
* Select the specific cell where you want to place the image.
* Click the **IMPORT button** to insert the asset directly into the selected cell in Google Sheets (the image will automatically be configured to fit inside the cell or sit over the cells depending on your display settings).

<figure><img src="/files/bPBqY96VbXERLYSeXrrv" alt=""><figcaption></figcaption></figure>

#### 2. Quick Asset Replacement (Swap Asset)

This feature allows you to swap an old image in your spreadsheet with another asset from the system without altering the row/column structures or affecting surrounding data:

* **Click directly** on the cell containing the image/asset that needs replacement on the Google Sheets page.
* In the HIVO Connector panel, use the toolbar to **search for the new asset by tags or keywords**.
* Select the **correct Version** you want to switch to, then click the **IMPORT button.** The system will automatically and accurately swap the old image for the new one.

<figure><img src="/files/pbk3x6ZY51U3if4U2A0o" alt=""><figcaption></figcaption></figure>

### Save Spreadsheet to HIVO

The **Save Spreadsheet** feature allows you to upload your Google Sheets file back into your HIVO library, ensuring it is centrally managed and accessible for collaboration.

To save a spreadsheet:

* Open the **HIVO Connector >** Navigate to the **Document** tab. If the **Document** tab is not visible, click **More** in the top-right corner of the HIVO Connector.
* Click "**Save to HIVO**" button
* Enter a **Document Name** and Choose the **Folder** where you want to save the spreadsheet.
* Click **Save Document**.

Once saved, the spreadsheet will be stored in the selected folder within HIVO.

<figure><img src="/files/kkCef58IdChuGnDlzDPk" alt=""><figcaption></figcaption></figure>

If you have any questions, don't hesitate to ask, we're always here to help!


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://support.hivo.co/integrations/google/google-sheets.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.