How to get COVID-19 API data into Google Sheets

Here’s a step-by-step tutorial showing you how to pull Coronavirus data into Google Sheets using a COVID-19 API and the Apipheny add-on.

  1. Install Apipheny Google Sheets add-on
  2. Choose a COVID-19 API
  3. Enter your COVID API into Apipheny
  4. Import COVID data into your Google Sheet

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is an API integrator for Google Sheets. You can use Apipheny to connect to unlimited API data sources, make unlimited API requests to any endpoint, and more. Click here to learn more about Apipheny.

1.)  Install Apipheny by opening the following link on desktop and then clicking the Install button on the page: https://gsuite.google.com/marketplace/app/apipheny/966163326746

2.) After you’ve installed Apipheny, open a Google Sheet and then click on Add-Ons in the menu at the top.

When the menu opens, you should see Apipheny.

Click Apipheny > Import API to open the Apipheny sidebar in your Google Sheet.

Step 2.) Choose a COVID-19 API

You can think of an API as a data pipeline. APIs are created to serve a wide variety of purposes.

In this tutorial, we’re looking at COVID-19 APIs that have been created to provide COVID data to the public and help people better understand the COVID-19 pandemic.

A search on Google reveals a wide variety of COVID APIs to choose from.

The right API for you depends on your needs. Different APIs provide different data.

Here’s a resource that provides more than 20 different COVID-19 APIs to choose from.

Here’s an example Coronavirus API that we will be using for the rest of this tutorial:

https://coronavirus-19-api.herokuapp.com/countries

If you want to use this same API, just skip to the next step.

Most other COVID APIs should work if you follow the same steps.

Step 3.) Enter your COVID API URL in Apipheny

Once you’ve chosen a COVID API, your next step is to enter your API request into the Apipheny add-on.

Open your Google Sheets and make sure the Apipheny app is open, as we covered in step 1.

In the Apipheny app, make sure the “Import” tab is open.

Then just enter your COVID API URL into the Apipheny app, where it says “API URL Path”.

If your API URL requires any additional headers, you can include them in the “Headers” section in Apipheny.

Here’s what our API request looks like in Apipheny:

Coronavirus API request in Apipheny

If you want to use the same example COVID API URL as us, just copy and paste the following URL into Apipheny:

https://coronavirus-19-api.herokuapp.com/countries

Step 4.) Run your COVID API request

Once you’ve entered your COVID API URL into the Apipheny add-on, just click the “Run” button at the bottom of the Apipheny add-on and you’re COVID-19 API data will automatically import into your Google Sheet:

COVID API data in Google Sheets
COVID API data in Google Sheets

That’s it! Once you have your COVID data in your Google Sheet, you can start to manipulate the data and create reports to visualize the data.

You can play around with different Coronavirus APIs because each one will provide different data.

Related articles:

Related Posts

Leave a Comment