Skip to content

Get Commodities Rates With An API And Google Sheets

Commodities-API

This web API provides precise rate data for a wide range of commodities in a variety of currencies.

Commodities-API originated as a modest, minimalist Open-Source API for financial institutions’ recent and historical commodity prices.

Accurate

With a precision of two decimal points and a rate of up to every 60 seconds, the API can provide real-time commodity data. Commodities-API is designed on a solid back-end architecture that provides response speeds for defined API calls of less than 50 milliseconds.

Only a few of the jobs include delivering commodity exchange rates, converting single currencies, and returning Time-Series and Fluctuation data.

Secure

The Commodities-API protects your connection with bank-grade 256-bit SSL encryption.

Commodities-API is used by thousands of developers, small businesses, and huge corporations on a daily basis. Because of its dependable data sources and 6+ years of expertise, this API is the most popular site for commodity rates.

How To

We’ll demonstrate to you how to use the API Connector add-on for Sheets to pull gold data directly into Google Sheets from the Commodities-API. We’ll begin by obtaining an API key from Commodities-API, and then submit a request for gold data into your spreadsheet.

GET THE API CONNECTOR ADD-ON FROM THE GOOGLE MARKETPLACE BY CLICKING HERE BEFORE BEGINNING.

First section: Commodities

1° Get your API Key

2° Pick the plan that suits you the most and sign up

3° Once you verify your email address, go to your Dashboard

The second section: let’s get started

We’ll start by following the Commodities documentation to get the most recent cotton values in USD.

  • API root: https://commodities-api.com/api/
  • Endpoint: /latest
  • Query strings: &base=USD&symbols = COTTON&access_key=YOUR_ACCESS_KEY

When we combine everything, we get the following API Request URL: https://commodities-api.com/api/latest?base=USD & symbols = COTTON&access_key=YOUR_ACCESS_KEY

Third section: insert API data into Google Sheets 

Let’s copy and paste the URL into API Connector.
1- Select Add-ons > API Connector > Open in Google Sheets from the drop-down menu.
2- In the Create tab, type the API URL we just defined.

3- We don’t require any headers, thus that section can be skipped. Set authentication to none because we don’t need any extra authentication.

4- To use it as your data destination, create a new tab and press ‘Set current’.

5- Type a name for your request and hit the Run button. Your sheet will update with the most recent gold statistics in a moment.

Now you’re ready to enjoy the features of this reliable API!


Also published on Medium.

Published inAppsTechnology

Be First to Comment

Leave a Reply

%d bloggers like this: