All Collections
How to add a new information to your dashboard
How to add a new information to your dashboard

Learn how you can add charts, tables and an indicator to your dashboard

Vitor Mazon avatar
Written by Vitor Mazon
Updated over a week ago

The Sheetgo dashboard feature lets you present the data from your workflows in a clean environment. After you've built your first dashboard you can always go back and add new information to make it more complete and precise. You can add new charts, data tables, and indicators to highlight a specific number or result.

All the information that you show in your dashboard is being pulled straight out of your spreadsheets. This means that, when the spreadsheets are updated the information inside your dashboard will also be updated.

After you create a dashboard it will be pinned to the tabs bar, next to your workflow. To add new data to the existing dashboard click on the "+" icon on the sidebar.

On the Add resource submenu select what type of information you want to add to the dashboard, a new chart from your sheets, a data table, and an indicator.

Add chart

If you need to add new charts to your dashboard you can click on the Add chart which will open the add charts box. From there you just need to select which new chart you want to add by clicking on the desired chart card and finish by clicking on Add to dashboard. The new graph will appear at the top of the dashboard and from there you can move it to the position that you need it to be by editing the dashboard.

Add an indicator

You can also add specific data to be highlighted as an indicator in your dashboard. To do this, click on Add an indicator. Give your indicator a proper name and select from which spreadsheet the data will be pulled.

After selecting the spreadsheet, select the tab where the data is and specify which cell you want to highlight. When you are done click on Insert indicator.

The data from the cell you've selected will be shown at the top of your dashboard and from there you can edit and change its position.

Add a data table

You can also show in your dashboard a table extracted directly from your spreadsheets. To do this click on Add a data table, and you will see the box below, you can give your table a title and then select the file where the information you want to highlight is located.

When you click on Select file, Sheetgo will show only the spreadsheets that are already connected to your workflow. Select where the data that you need is and click on Done.

After selecting the spreadsheet you will need to specify if you want to show a Data range or a Named Range.

Data range

If you choose a Data range you need to select the tab and write down the range of cells that you want to show.

Named range

If you select Named range, you will need to have a named range already saved in your spreadsheet.

To create a named range follow the steps in this Google documentation

With a range saved, select it from the dropdown menu and click on Insert data table.

After adding all the new data that you need now you need to edit your dashboard to place each new information in its desired location. To edit your dashboard follow the steps in this article.

Need more help?

Contact us via chat, on our email ([email protected]), or send us a ticket!

Visit our Community for help, tips, tricks, and feedback for Sheetgo.

Did this answer your question?