Quick Start

Quick Start

Last Updated On July 28, 2019
You are here:
< Back

For this quick start, we’ll walk through how to use the API Connector for Google Sheets, using an example API request from an active public API.

SUPER QUICK START>>If you can’t wait, just enter the following example URL into the API URL Path, set an output sheet and click Run:
https://financialmodelingprep.com/api/v3/company/stock/list

That’s it! But if you’d like more detail, read on for step by step instructions.

STEP BY STEP QUICK START

STEP 1: ADD NEW API REQUEST

After installing the plugin in Google Sheets, click Add-ons > API Connector > Create New API Request

api-connector-menu-create

STEP 2: CONFIGURE YOUR API REQUEST

A window will open on the right side of your browser. Under API URL path, enter the following API URL: https://financialmodelingprep.com/api/v3/company/stock/list
api-connector-quick-start-img2

This is an open, public API so we don’t need to add any headers. Just leave that section blank.

STEP 3: CHOOSE DESTINATION TAB

Create a new tab. You can name it anything but here we’ll call it “Stocks”. Click ‘Set’ to set this as the data destination.

api-connector-quick-start-img3

Note that the tab must exist before you can choose it as a destination; if you type in a sheet name that doesn’t exist yet, you’ll receive an error message prompting you to retry. Leave the output type option as Overwrite.

STEP 4: NAME AND RUN

Again we’ll name the request “Stocks”. Click Run.

api-connector-quick-start-img4

STEP 5: VIEW THE OUTPUT

Following the above steps, you should now be able to see this API data in your own sheet.

api-connector-quick-start-img5

CUSTOMIZE YOUR REQUEST

Now, go forth and enter in your own API requests! Experiment with your own API URLs (this list of public APIs is a good place to start), or follow the documentation to:

If you still have questions, please leave a comment or reach out through the API Connector Contact Form.

Comments:2

  1. Hi, this is so useful. thank you. I get a “Could not authenticate me” error. I think it has to do with me requiring a token. Is there a way i can enter a token in your plug-in?

    **I am not an experienced developer

    1. Hi Dami, sure, API platforms typically accept authorization tokens as part of the API request URL or within a Header, so you can use those fields to enter your token into API Connector.

Leave a Reply

Your email address will not be published.