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>>To get started immediately, just enter the following example URL into the API URL Path, set an output sheet and click Run:
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
- 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/financials/income-statement/GOOG
STEP 3: CHOOSE DESTINATION TAB
Create a new tab. You can name it anything but here we’ll call it “Finance”. Click ‘Set’ to set this as the data destination.
STEP 4: NAME AND RUN
Again we’ll name the request “Finance”. Click Run.
STEP 5: VIEW THE OUTPUT
Following the above steps, you should now be able to see Google’s financial data from the Financial Modeling Prep API in your own sheet.
STEP 6: CUSTOMIZE YOUR REQUEST
- 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.