PT Free trial

How-to

How to connect a Google Sheets spreadsheet to Hubviz

Sign in with your Google account in Hubviz Studio, pick the spreadsheet and tab and create a cube that reads straight from Google Sheets.

Build a cube that reads one sheet of a Google Sheets spreadsheet. When the spreadsheet changes, the cube picks up the new data on the next refresh, with no file to upload.

When to use it

  • Your team keeps the data in a shared spreadsheet in Google Drive, such as targets, budget or a manual log.
  • You want the dashboard to follow the spreadsheet without exporting and uploading files.

If the spreadsheet is on your computer, use Excel and CSV.

Before you start, open the project where the data will live and have the Google account that can open the spreadsheet at hand.

Connect the Google account

  1. In the project side menu, open Cubes and click the + button.

  2. Click Create Manually, pick the Google Sheets type and click Next.

  3. Click Create New Connection.

  4. Fill in Connection Name, such as “Sales targets 2026”. The name comes before the login: without it, Hubviz shows Connection name not identified. Please fill in the name before continuing. and does not start the login.

  5. Click Login with Google and allow access in the Google window. Meanwhile, the window shows Verifying authentication....

  6. When User currently connected! appears, click Save.

State in the windowWhat it means
No user connected.No login yet. The button reads Login with Google.
Verifying authentication...Hubviz is waiting for Google’s answer.
User currently connected!Logged in. The button turns into Logout from Google, to switch accounts.

Pick the spreadsheet and create the cube

  1. With the connection selected, click Select a Google Sheet.
  2. Pick the spreadsheet in the Google Drive window.
  3. Click Next.
  4. Name the cube in Cube Name and click Finish.

The cube opens with the spreadsheet’s sheets at the top and a preview of the data.

Pick the sheet and where the data starts

  • Sheet: click the sheet that holds the data. Each cube reads one sheet only. Switching sheets later clears the mapped fields: Hubviz asks you to confirm in Warning - Sheet Change. Need another sheet? Create another cube.
  • Start cell: if the table does not start at A1 (for example, there is a title in the first rows), click Change mapping position, enter the Starting cell, such as B3, and confirm. The cell must be a column letter followed by the row number.

Then check the fields on the Field Mapping tab, as you would with an Excel spreadsheet. See Cube fields.

Example: sales targets

Management updates the Sales targets 2026 spreadsheet every month, on the Targets sheet:

mesunidademeta
2026-01-01Industry1620320
2026-01-01Retail1236560
2026-01-01Services835744

The cube reads the Targets sheet. In the mapping, mes stays as a date, unidade as text and meta as a number. With automatic refresh on once a day, the new target shows on the dashboard the day after the spreadsheet is edited.

Data refresh

The cube reads the Google spreadsheet every time it is processed. For Hubviz Web to get the new data without you opening Hubviz Studio, turn on the cube’s automatic refresh.

Common errors

MessageWhat to do
Connection name not identified. Please fill in the name before continuing.Fill in Connection Name before clicking Login with Google.
You need to authenticate with Google first!You clicked Save before finishing the login. Log in, then save.
Error starting Google login. Please try again.The Google window did not open. Try again and check that the browser did not block the window.
No data found in this sheet.The chosen sheet is empty. Pick the sheet with the table.

Spreadsheet tips

  • Keep the column names in the first row of the table.
  • One table per sheet, no merged cells and no total rows in the middle.
  • The Google account used to log in must keep access to the spreadsheet. If access is removed, the refresh fails.

See also