Like with other widgets, click the +Add Widget button to get started.

First, you will have to choose your visualization however this can be altered when you get to the stage of choosing data from your sheet.

Once you have selected a visualization, click Google Sheets from your list of connectors.

Next, you will have to choose the document and specific sheet you would like to pull data from.

The final configuration page is where you can start building your widget. You can select specific cells, columns and rows from the sheet builder below which will start populating in the preview widget on the right-hand side of your screen.

The amount and format of data you can select will depend on the visualization you select, which can be changed through the dropdown at the top of the page.

When you are happy with the widget you’ve created click finish and this will instantly appear in the top left-hand corner of your dashboard.

This is live data so as your Google sheet updates, this will be updated in Hurree ensuring your widgets always show the most accurate information.