Build a Live-Updating COVID Dashboard with Google Sheets & Superset

In the face of overwhelming clickbait news about COVID-19, creating a data-informed dashboard can provide a calmer way to stay updated, and using Google Sheets alongside Apache Superset offers a streamlined method for building these dashboards without extensive coding. The process involves using Google Sheets for data acquisition, cleaning, and storage by leveraging a custom script called ImportJSON to fetch and format data from the COVID-19 API. This data is then connected to Apache Superset for visualization and deployment, with the integration facilitated by the gsheets-db-api plugin, allowing Superset to interact with Google Sheets. The tutorial outlines steps for setting up Google Sheets to automatically update data and integrate it into Superset for creating and saving visualizations, despite some limitations such as slower query execution compared to traditional databases. This approach is particularly suited for smaller datasets, and users can further customize their dashboards by exploring different COVID data attributes or integrating additional APIs.

No tracked trend matches for this post yet.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.