# Data Feed to Google Sheets

**URL:** <https://forums.realmacsoftware.com/t/data-feed-to-google-sheets/32711>\
**Category:** RapidWeaver Classic\
**Created:** [May 3, 2020, 4:53pm UTC](https://forums.realmacsoftware.com/t/data-feed-to-google-sheets/32711 "2020-05-03T16:53:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RogueTrader](https://avatars.discourse-cdn.com/v4/letter/r/ee59a6/32.png) [@RogueTrader](https://forums.realmacsoftware.com/u/RogueTrader)\
**Post date:** [May 3, 2020, 4:53pm UTC](https://forums.realmacsoftware.com/t/data-feed-to-google-sheets/32711/1 "2020-05-03T16:53:02Z")

</div>

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](http://about-corona.net/documentation)  
and the feed [corona-api.com/countries](http://corona-api.com/countries)

Thank You.

---

<div class="post-metadata">

**Author:** ![indridcold](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/indridcold/32/16088_2.png) [@indridcold](https://forums.realmacsoftware.com/u/indridcold)\
**Post date:** [May 3, 2020, 6:26pm UTC](https://forums.realmacsoftware.com/t/data-feed-to-google-sheets/32711/2 "2020-05-03T18:26:58Z")

</div>

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](https://europe1.discourse-cdn.com/flex005/uploads/realmacsoftware1/original/3X/1/7/17e0cb7e3ee18955b873abeea221b8e0f44c549d.jpeg)

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

---

<div class="post-metadata">

**Author:** ![RogueTrader](https://avatars.discourse-cdn.com/v4/letter/r/ee59a6/32.png) [@RogueTrader](https://forums.realmacsoftware.com/u/RogueTrader)\
**Post date:** [May 3, 2020, 7:08pm UTC](https://forums.realmacsoftware.com/t/data-feed-to-google-sheets/32711/3 "2020-05-03T19:08:23Z")

</div>

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](https://europe1.discourse-cdn.com/flex005/uploads/realmacsoftware1/original/3X/b/1/b1770477cb7ef4fe0dbc03b3ef286b618ff447c9.png)

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/system/32/25301_2.png) [@system](https://forums.realmacsoftware.com/u/system)\
**Post date:** [June 3, 2020, 5:08am UTC](https://forums.realmacsoftware.com/t/data-feed-to-google-sheets/32711/4 "2020-06-03T05:08:25Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.