How to create your Sheetgo dashboard
The Sheetgo dashboard is a feature that allows you to see in just one place the charts and graphs that already exist inside your spreadsheets. Presenting this data in an alternative setting enables you to concentrate on the provided information, simplifying the process of disseminating insights and showcasing results.
You can use the Sheetgo dashboard feature to create a visual summary of the information present in your workflow, you can also easily share and download the dashboards giving you control over how this data is distributed.
The dashboard is available for workflows that use Google Sheets that already have at least one chart in it. The chart can either be located on the source or destination file.
Creating the dashboard
To create your dashboard, you need to open the Sheetgo app. Select which workflow you want to use as the base for your dashboard and open it. On the workflow overview go to the Create button at the top left corner of the screen. Once you click on it a dropdown menu will appear with three options, the dashboard feature is the third one, "Create dashboard".
Selecting the chart
When you click on create dashboard a new dialog box will appear. In the left corner, you will find all the spreadsheets that are connected to the workflow. If you select one of the spreadsheets, at the central space of the dialog box you will find a card for each chart that exists in the spreadsheet.
To create your dashboard you just need to select which charts you will use by clinking on the checkbox at the top right corner of each card. In your dashboard, you can select charts and graphs that are coming from different spreadsheets inside the same workflow, with the option you can connect and visualize different sets of information at the same time.
You can check how many charts you have selected and from how many spreadsheets at the bottom left corner of the dialog box.
When you are ready, you can just click on the Create dashboard, at the bottom right corner.
If the spreadsheet doesn't have a chart in it you will be invited to create one. The link that appears on this box will take you to your spreadsheet where you will be able to add a chart to the document.
After that, your dashboard will be created showing all the charts you've selected in a clean environment, letting you focus only on the information that they show.