Overview
Here we'll use the free Covid19 API to get current stats on the coronavirus worldwide, by country, into Google Sheets, and using the SyncWith Google Sheets Addon it will be kept up to date automatically
Get the data
We'll use the /summary endpoint to get one row per country:
Current Covid19 stats by country
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
ID | Country | CountryCode | Slug | NewConfirmed | TotalConfirmed | NewDeaths | TotalDeaths | NewRecovered | TotalRecovered | Date | Premium |
---|---|---|---|---|---|---|---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets