In this article, we’ll learn how to import live metal prices to Google Sheets. We can retrieve the prices of precious metals such as gold, silver, platinum, and palladium in most major currencies of the world.
We’ll use an extension in Google Sheets–Amigo Data–to pull the data into Google Sheets. With it we’ll be able to import gold prices to Google Sheets and also other precious metals with ease. And not just fetch the data and stop at that; in fact, the journey starts from there. The data are automatically pulled to Google Sheets, updated periodically, and delivered to our inbox so that the data follow us everywhere. Want hot and fresh data? Get Amigo!
Here’s a snippet of prices of gold and other precious metal imported into Google Sheets.
Read on to know how to import live metal prices to Google Sheets. Below are the steps.
How to import live metal prices to Google Sheets
Follow these steps to import live metal prices data to Google Sheets.
Install the Amigo Data extension in Google Sheets
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.
Click here to install.
Alternatively, you can get it from Google Sheets.
- Open a new sheet
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install
Get the endpoint URL
Sign up or log in to RapidAPI.
Once you’re logged in, go to the Live Metal Price API Documentation page in RapidAPI.
Click on the Subscribe to Test button and subscribe to a plan that’s right for you.
On subscribing to a plan (the free one included), an API key will be generated, which is used to authenticate API calls.
Click Endpoints to go back to the API documentation.
On the left is the list of the available endpoints. Select any one. For this tutorial, we’ll import the prices of precious metals such as gold, silver and platinum in a currency of our choice, so we select Latest in chosen currency.
The key and the header are filled automatically and the query parameters are also filled with default values. We can change these with symbols of our choice.
The default parameters will return the prices of gold, silver, palladium and platinum in euro and the value of the pound sterling and euro in euro.
We’ll modify the parameters to include the prices of 24-karat gold, and gold price change since open, with the prices quoted in the US dollar. For a list of supported metals and currencies, see this page.
On the right of the screen under the Code snippets is the endpoint for the specified parameters along with the headers we’ll need to import the metal prices data to Google Sheets.
Note the endpoint URL and headers. We’ll use these in the next step.
Import the live metal prices to Google Sheets
Open Google Sheets and launch Amigo Data from the sheet into which you want to fill the data. To connect to Amigo Data, click Extensions→Amigo Data→Connect.
You’ll be presented with a list of sources to connect to. Choose Custom API.
Paste the endpoint URL in the API URL field. Do not include the apostrophes.
Then expand the Details tab and enter the headers.
Click the PREVIEW button. Flatten and expand the nested datasets. Then click IMPORT.
The data will be imported into Google Sheets in a moment. Below is a snippet of the imported data.
The endpoint used here retrieves the price of the metals in ounce, We can get the price in gram by using the Latest Selected Metals in Selected Currency In Grams endpoint.
Once the data have been imported into Google Sheets, they can be updated automatically at regular intervals–hourly, daily, weekly or on custom days–should you so wish, and get these data sent to your inbox. Learn how to set a refresh schedule and set up alerts in Amigo Data.
Visit our blog to find out about the kinds of data that you can import to Google Sheets and how you can track stock and other financial data from Google Sheets.
Some commonly asked questions
How to get gold price in Google Sheets?
To retrieve gold price and import to Google Sheets, use the symbol XAU. This will return the price of gold. You can also retrieve prices of gold with a particular purity. For example, to fetch the price of 1 karat gold, use the symbol XAU_1K, XAU_2K for 2 karat gold, and so on all the way up to 24 karat. You can find the list of symbols here.
Can I track gold prices in Google Sheets?
Yes, you can track gold prices in Google Sheets. You can track the prices using the open price symbol–XAU_OPEN. Import the data to Google Sheets using Amigo and then set a refresh schedule to automatically update the data.
To see the price change, use the XAU_CHANGE. This will give the price change data since open.
Can I get gold price in other currencies than USD?
Certainly. You can get the price of gold in most major currencies. Simply specify the currency symbol in which to get the price in the requestedCurrency field. For example, to fetch gold price in Indian rupee, use the symbol INR. You can find the list of supported currencies here.
Some recommended articles:
Get Real-Time Crypto Prices In Google Sheets With Live Coin Watch API
Import NSE Data To Google Sheets