Import US Economic Indicators Data To Google Sheets

Reading Time: 4 minutes

The price movements in a financial market depend heavily on the economic indicators of a country. Being the largest global economy, US economic indicators data like CPI, inflation rate, mortgage rates, and many more can help ones analyze the current global economic scenario. This can help one make data-driven financial decisions.

In this article, we will learn how to import US economic indicators data to Google Sheets using Amigo Data Add-on. You will be able to import various kinds of US economic indicators data like inflation rate, mortgage rate, CPI, and many more. Amigo Data gives you the flexibility to update your data automatically, just set it up once and let Amigo Data do the job for you.

The snippet below shows the 10-year monthly US government bond yield.

10 year US government bond yield

To import US economic indicators data to Google Sheets, we will follow the steps below:

Import US economic indicators data to Google Sheets

Here’s the step-by-step guide to US economic indicators data to Google Sheets.

Install the Amigo Data add-on

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Click here to install

Install Amigo to import US economic indicators data to Google Sheets

Generate the API key

Sign up to RapidAPI.

RapidAPI page to sign up

Once you’re logged in, go to the U.S. Economic Indicators API in RapidAPI.

US economic indicators API in RapidAPI

Choose a subscription plan from the Pricing menu and subscribed to the API.

Subscribe to the US economic indicators API

Click Endpoints to go back to the US Economic Indicators API and scroll down a bit. You will find your API key under the Header Parameters.

RapidAPI key

Choose an endpoint

The types of data that we can retrieve using the API are listed on the left side of the documentation. For this tutorial, we will import from the Consumer Price Index endpoint. This endpoint provides us with 10+ years of consumer price index data. 

List of available data

Click the Test Endpoint option to run the query.

Test the API

The success message indicates that the endpoints are functioning correctly. 

The API is working

The API endpoint URL and headers can be found under Code Snippets.

Change (Node.js) Axios to Shell-> cURL from the dropdown menu.

Select the cURL from Shell

Copy the URL excluding the apostrophes and also note the headers. These will be used to pull the US economic indicators data to Google Sheets.

Endpoint URL and headers

Import the data to Google Sheets

Go back to Google Sheets and launch the Amigo Data extension to import the economic indicators data to Google Sheets.

Launching Amigo Data in Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Paste the endpoint in the API URL field.

Pasting the endpoint

Then expand the Details tab and enter the following as headers:

Header 1
Name: X-RapidAPI-Host
Header 2
Name: X-RapidAPI-Key
Value: your_key

Replace your_key with your RapidAPI key.

API headers

Then click the PREVIEW button to retrieve and preview the economic indicators data to import to Google Sheets.

Flatten the data points and then click IMPORT.

Preview, flatten and import the data

In the snippet below, we have the consumer price index imported into Google Sheets.

Snippet of imported data

You can likewise import other types of data. Following are some other examples.

Mortgage rate data

Using a Mortgage rate 30-year fixed endpoint, you can import 

30-Year fixed mortgage rates data on the monthly basis.

Bond Yield data

Using a 10-year Bond Yield endpoint, you can import 10-Year government bond yield data on the monthly basis.

Similarly, you can also explore other endpoints. To explore more endpoints go through the documentation.

After importing the data, you can also set a refresh schedule so that the data are updated automatically at regular intervals. By this, you can automate importing financial market data to Google Sheets. To learn how to set a refresh schedule, follow this link.

There are several other types of data that you can import into Google Sheets using Amigo Data such as CNBC data, Trading View data, Coinranking data, and many more. Visit our blog to find out the kinds of data you can import to Google Sheets.

Some related articles you may be interested in:

Import CNBC Data To Google Sheets

Automate Trading View Data Imports To Google Sheets

Automate Coinranking Data Imports To Google Sheets

Leave a Reply