Quick Start

Quick Start

Last Updated On July 02, 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.

Step 1: Add new API request
Step 2: Configure your API request
Step 3: Choose destination tab
Step 4: Name and run
Step 5: View the output

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:0

Leave a Reply

Your email address will not be published.