Next on Widget creation:
Next on Widget creation:
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
Pie Chart
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 using the dropdown menu if needed.
If you're using a Pie Chart, Table, Line Graph, or Bar Chart, you can also customise the Theme Colour during this step by selecting your preferred color from the Theme Color option.
Step 6: Add a Widget description
On the Widget settings page, you can now add a description to your Widget.
You can use this to explain what the Widget shows or to add extra context for your team.
Step 7: 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.