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.
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.
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.
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.
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.
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.
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).
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.
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.
If you have any questions, don't hesitate to ask, we're always here to help!
Last updated