How to Build Automated Dashboards With Google Apps Script and Google Sheets

Dashboards are a powerful way to communicate data to your team. One use for dashboards is tracking the progress of key performance indicators (KPIs). One KPI tracked at Lucid is the ranking and performance of our products in third-party marketplaces. Although there are enterprise-grade products to gather and visualize this type of data, you can generate automated dashboards with only Google Apps Script and Google Sheets.

Finally, create the dashboards from the formatted data. See How to Make a Killer Data Dashboard with Google Sheets for tips and tricks.

I have been using the power of the Google platform more often now. Why?  The power of Google Apps Script, a Javascript-like language with plenty of power and a large ecosystem of developers willing to share.  Mind you this is not easy for the typical spreadsheet user but, if you are a developer then you can rock this easily.  The same thing could be done with Microsoft office using Excel and some VBA scripts.  Most companies I work with don’t allow VBA because of the security issues.  Those concerns mostly go away when you use the Google platform.

Via: How to Build Automated Dashboards With Google Apps Script and Google Sheets