Print

Import Financial Modeling Prep Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Financial Modeling Prep API directly into Google Sheets, using the API Connector add-on for Sheets. 

Financial Modeling Prep actually provides their own Sheets extension, so you can try that out if you like (here's the link). API Connector has many unique and powerful features for working with any API (not just Financial Modeling Prep), so you may find one or the other better suited to your needs.

Contents

Before You Begin

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

Part 1: Get Your Financial Modeling Prep API Key

  1. If you haven't already, create an account at https://financialmodelingprep.com/register.
  2. Once you're logged in, navigate to the dashboard (or just click this link to go there directly).
  3. Click the API Keys link in the sidebar and you'll see your API key on the right. Keep this handy as we'll need it for all requests. You now have access to the FMP API!financialmodelingprep-img2

Part 2: Pull Financial Modeling Prep API Data into Google Sheets

For this example request, we'll fetch key metrics for a stock symbol (AAPL). Substitute in your own API key in place of your_API_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://financialmodelingprep.com/api/v3/key-metrics/AAPL?apikey=your_API_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.
    financialmodelingprep-response

Part 3: API Documentation

To get more data, just copy and paste any of the URLs shown in their API documentation.

Official API documentation: https://site.financialmodelingprep.com/developer/docs

8 thoughts on “Import Financial Modeling Prep Data to Google Sheets”

  1. Hi,

    How can you check how many requests you have made on Financial Modeling Prep? I'm using a free API key to test out my app; thus, it's quite important for me to know the number of requests I made.

    Another question: On Financial Modeling Prep, do we have a rate limit for APIs, such as 10 requests/sec or some other amounts?

    Thank you in advance!

    Reply

Leave a Comment

Jump To