If you’re looking for a quick and simple way to create a dashboard to display data from Google Sheets, look no further than WayScript. Using the following script, you can have a dashboard up and running in under 2 minutes.
First, an HTTP Trigger is needed to provide a URL in order to host the dashboard. Once this is added, a Dashboard Response module is attached to the tree. This allows the data to be displayed on the dashboard itself.
Now, it’s time to import the data from Google Sheets. Insert a Google Sheets module between the Trigger and Response modules. At this point, your tree should look like this.
Now that the Google Sheets module is inserted, choose a file to read from the toolbar on the left. When the file is loaded, import the desired columns; this creates variables that are used for the chart later in the script. It’s now time to add the chart that you want displayed using the Chart module and inserting it after the Sheets module.
Begin creating the chart by selecting the type of chart desired and then inputting the aforementioned variables created from the imported columns. In the image below, a line chart has been selected and the corresponding column variables have been inserted into the x and y-axes. This generates a preview of the chart.
Next, the chart must be passed onto the Dashboard Response module. To do this, click on the module and navigate again to the toolbar to the left. At the bottom there is a “chart” box; drag this to the title box input above.
Finally, turn the HTTP Trigger on by switching the slider to the active position. Click on the URL that appears, and the dashboard with the created chart opens in a new tab. WayScript provides the effortless ability to create this important tool that allow users to easily share data with others. To see the step-by-step process of creating this script, watch our YouTube video below!