Data Feed to Google Sheets

RapidWeaver Classic
1

Hi everyone.
I’m trying to wire-up a data feed, but I’m failing miserably, wondering
if an expert can figure this out.

I want to get semi-real-time data from a Covid19 data feed, and
import it into Google Sheets, using the Import functionality in Google Sheets.

Then I will display the data in some combination of data and graphics, using
Live Data or Gsheet stacks, and one of the charting stacks.

Here is a list of the Import functions in Google sheets.
IMPORT XML
IMPORT DATA
IMPORT FEED
IMPORT HTML
IMPORT RANGE

Here is the Feed Data Page. about-corona.net/documentation
and the feed corona-api.com/countries

Thank You.

2

You don’t say what you have done thus far to try to achieve this yourself? Anything?

In your google sheets, install an add-on called ‘Import-Json’. Its in beta but stable. Go through the process of installing it and making sure its there in your add-ons.

Then select A1 and type or paste into the function bar:
=IMPORTJSON("https://corona-api.com/countries")

Wait a few moments and you should get the data imported:

Annotation%202020-05-03%20192212
Annotation%202020-05-03%201922121223×953 189 KB

Might need to clean things up a bit from the import, or improve the api query, but that should get you a lot closer.

3

Thank You Indridcold.

I tried 3 of the IMPORT XML, DATA and FEED functions, in every confirguration I could hack my through, got some errors, could not figure it out.
However, now I have now loaded a google add-on called API connector? and it was super easy to bring it all in at once.

Thanks for your help.

image
image1388×784 157 KB