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.
To pull data from the COVID API to Google Sheets easily and without writing any code, first install and open the Apipheny Google Sheets add-on.
Apipheny is a no-code API integrator for Google Sheets that you can use to make unlimited API requests, connect to unlimited APIs (including the COVID API), save API requests, schedule API requests, and more. Click here if you want to learn more about Apipheny.
1. Install Apipheny by clicking the Install button on this page.
2. After you’ve installed Apipheny, open a Google Sheet and then click on the Add-Ons option in the top menu. Then, in the add-ons menu, you should see Apipheny.
Click Apipheny > Import API to open the Apipheny sidebar in your Google Sheet:
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:
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.
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:
If you want to use the same example COVID API URL as us, just copy and paste the following URL into Apipheny:
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:
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.