Skip to main content
All CollectionsWidgetsWidget Creation
Adding Widgets from a Google Sheet
Adding Widgets from a Google Sheet
Niamh McGlade avatar
Written by Niamh McGlade
Updated over 2 weeks ago

How to Add a Google Sheets Widget in Hurree

Once Google Sheets is connected, you can display its data in any visualization type. Follow these steps to add a Google Sheets widget to your dashboard:

Step 1: Start Adding a Widget

  • Click the + Add Widget button on your dashboard.

Step 2: Select a Visualization Type

  • Choose how you want to display your data:

    • Number

    • Line Graph

    • Bar Chart

    • Other available formats

  • You can change this later when selecting data from your sheet.

Step 3: Select Google Sheets as Your Connector

  • Click Google Sheets from the list of available connectors.

Step 4: Choose Your Sheet

  • Select the document and specific sheet from which you want to pull data.

Step 5: Configure Your Widget

  • Use the sheet builder to choose the cells, columns, or rows you want to display.

  • The preview widget on the right will update as you make selections.

  • Adjust the visualization type if needed using the dropdown menu.

Step 6: Finish & Add to Dashboard

  • Click Finish when you're satisfied with your widget.

  • Your new widget will appear in the top left corner of your dashboard.

Important Notes

Live Data Updates – As your Google Sheet updates, your Hurree widget will automatically update to reflect the latest data.
Error Handling – If data used in your widget is removed from the Google Sheet, your widget will enter an error state and may need to be reconfigured.

Did this answer your question?