Search API Connector Documentation
Import Metals API Data to Google Sheets
In this guide, we’ll walk through how to pull gold and silver data from the Metals API directly into Google Sheets, using the API Connector add-on for Sheets. We'll first get an API key from Metals-API, and then set up a request to pull in metals data to your spreadsheet.
- Before You Begin
- Part 1: Get your Metals-API API Key
- Part 2: Pull API data into Sheets
- Part 3: More Example API URLs
- Part 4: API Documentation
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Get Your Metals-API API Key
- If you haven't already, navigate to https://metals-api.com/ and click GET API KEY in the top right corner.
- They offer a range of plans, but for this example we'll start with the free plan. Click Get API Key.
- You'll be prompted to create an account, and a moment later will receive a verification email. Click on the email to verify your account, and you'll be redirected into your new Metals-API dashboard. Click the Dashboard link in the left-hand sidebar.
- You'll now see your API access key. Copy it and keep it safe, we'll need it in a moment. Congrats, you now have access to the Metals API.
Part 2: Pull Metals API Data into Google Sheets
For this example, we'll get the latest price of gold and silver in USD.
- Open up Google Sheets and click Extensions > API Connector > Open > Create request.
- In the request form enter the following:
- Request URL:
- Create a new tab and click Set current to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see the latest gold and silver data in your sheet.
- The timestamp is a UNIX timestamp. You can convert it back to a regular human-readable date with the Sheets function
=B2/60/60/24 + DATE(1970,1,1)
1/ratewill give you the price per unit in your selected currency. For example,
1/.00056221356= 1788.68 USD per ounce of gold.
Part 3: More Example API URLs
You can experiment with endpoints and query strings as described in the documentation to see other types of metals data, but here are some examples to get started:
- latest conversion rates for a set of currencies against USD. Possible symbols include currencies, crypto coins, and metals, and are listed here: https://metals-api.com/currencies
- historical price of gold and silver on 2022-01-01
- conversion rate of USD$25 to gold on 2012-01-01
- time-series data for gold between 2023-01-01 and 2023-01-05 (daily time series data ranges are limited to 5 days and a single symbol at a time)
- weekly data fluctuations for gold. The max allowed timeframe is 365 days.
Part 4: API Documentation
Official API documentation: https://metals-api.com/documentation