API Integration Tutorials

Marketstack API To Google Sheets: How To Import Stock Data [Tutorial]

  1. By Apipheny Team

Marketstack, formerly known as WorldTradingData, is a provider of global stock and indices data. Marketstack returns real time data for stocks and indexes globally. Their endpoints are extremely easy to use and their database can return up to 500 different stocks or indexes into your Google Sheets using the directions below.

In this tutorial I’ll show you how to import Marketstack API into Google Sheets using the Apipheny add-on:

  1. Install Apipheny
  2. Sign up for Marketstack and get your API key
  3. Create your API URL
  4. Enter your API request into Apipheny
  5. Import Marketstack data into your Google Sheet

Step 1.) Install and open the Apipheny Add-on in Google Sheets

To pull data from the Marketstack API into 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 Marketstack 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. 

Install Apipheny
Install Apipheny

2. After you’ve installed Apipheny, open a Google Sheet and then click on Add-Ons in the menu at the top. When you click “Add-ons”, you should see Apipheny in the menu.

Just click Apipheny > Import API to open the Apipheny sidebar in your Google Sheets:

Open Apipheny
Open Apipheny

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is an API integrator for Google Sheets. You can use Apipheny to connect to unlimited API data sources, make unlimited API requests to any endpoint, and more. Click here to learn more about Apipheny.

1.)  Install Apipheny by opening the following link on desktop and then clicking the Install button on the page: https://gsuite.google.com/marketplace/app/apipheny/966163326746

2.) After you’ve installed Apipheny, open a Google Sheet and then click on Add-Ons in the menu at the top.

When the menu opens, you should see Apipheny.

Click Apipheny > Import API to open the Apipheny sidebar in your Google Sheet.

Step 2.) Register for an account and get your API key

The next thing you need to do is sign up for an account at Marketstack.

Click here to register for Marketstack. The basic plan is free.

After you create an account, you’ll need to verify your email by clicking the link in the email that was sent to you.

After you verify your account and sign in, you’ll see your Marketstack API key on your dashboard:

WorldTradingData API key
Marketstack API key

Now keep this window open or copy and paste your key somewhere safe because you’re going to need it in a second.

Step 3.) Create your Marketstack API URL

Note: this process might have changed a little bit, but should be very similar.

Now that we have our API key, we need to construct our marketstack API URL.

Click here to read the Marketstack API documentation to learn how to structure your API request.

Here is an example API URL for Marketstack:

https://api.marketstack.com/v1/eod?access_key=YOUR_ACCESS_KEY&symbols=AAPL

In this example API URL, you can see that the stock that we are requesting data for is AAPL.

You can enter any one or more companies in place of AAPL to get data from, just separate them by comma

Also, where it says “YOUR_ACCESS_KEY” is where you will place your API token that you got in your dashboard.

Click here to search through the Marketstack database to see the different stocks and exchanges you can use in your API URL.

Step 4.) Enter your API request in the Apipheny add-on

Your next step is to enter your API URL into the Apipheny app.

If you want to use a demo URL, you can use this one:

https://api.marketstack.com/v1/eod?access_key=YOUR_ACCESS_KEY&symbols=AAPL

Just copy and paste your whole API URL into the Apipheny add-on, like this:

WorldTradingData stock and index data in Google Sheets
Marketstack stock and index data in Google Sheets

Once you have your API URL entered into the Apipheny app, just click Run and you’re done! Your stock and forex data from the Marketstack API will automatically import into your Google Sheet.

Related articles:

TAGS :
Apipheny Team

Apipheny Team

Meelad is a data analyst living in the San Francisco Bay Area and Co-founder of the Apipheny API integrator for Google Sheets.

Related Posts

21 Apr

Typeform API to Google Sheets: How To Import Typef

01 May

How To Get a List of Remote Jobs in Google Sheets

02 Sep

Squarespace API to Google Sheets: Squarespace Inte

Leave a Comment

API Basics