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 BY STEP QUICK START

• 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 6: Customize your request

STEP 1: ADD NEW API REQUEST

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

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

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.

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.

STEP 5: VIEW THE OUTPUT

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

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:

• Include Headers
• Create an API Request Based on a Cell
• set up Scheduling
• get data from popular APIs like YouTube, GitHub, Mailchimp, Shopify, OpenWeatherMap, and many others.

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