We often have some business data that we need to track. We collect, process and store it in spreadsheets to then create charts and diagrams. However, sometimes there is a need to go out to a non-technical audience. There are many services for building decent-looking charts and dashboards, such as Tableau, Qlikview, or Google Data Studio.
However, they are often too expensive or too limited to be useful for any case. Fortunately, it is possible to serve static HTML and JavaScript files directly from Google Apps Script.
In this article, I show you how to create a simple dashboard using data from Google Sheet and C3.js. First, we will set up a web application template in Google Apps Script. Next, we will integrate it with C3.js. Then, we will fetch data from Google Sheets (e.g. to update information in the dashboard) and insert it into the template. This project may become a scaffold for creating many different dashboards and visualizations.
Top comments (0)