Print

Import Alpha Vantage Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Alpha Vantage API directly into Google Sheets, using the API Connector add-on for Sheets. Alpha Vantage is an excellent financial data API providing data for stocks, commodities, forex, and cryptocurrency.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Alpha Vantage API Key

  1. Navigate to https://www.alphavantage.co/ and click Get Your Free API Key Today
    alphavantage-getkey
  2. Fill out the form and click Get Free API Key
    alphavantage-getkeysubmit

  3. You should now see your key. Keep it handy as you'll need it in a moment. Congrats! You're now ready to use the Alpha Vantage API.
    alphavantage-copykey

Part 2: Pull Alpha Vantage API Data into Sheets

For this example, we'll get a list of income statements for TSLA. Substitute in your own key.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://www.alphavantage.co/query?function=INCOME_STATEMENT&symbol=TSLA&apikey=your_key
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see data populate your sheet.
    alphavantage-response

Check the documentation for other available data. Alpha Vantage's documentation provides example request URLs for each of their eight data categories: Core Stock APIs, Alpha Intelligence, Fundamental Data, Forex (FX), Cryptocurrencies, Commodities, Economic Indicators, Technical Indicators.

Part 3: API Documentation

Official API documentation: https://www.alphavantage.co/documentation/

Leave a Comment

Jump To