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.
- Before You Begin
- 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
- API Connector demo video
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
STEP 1: ADD NEW API REQUEST
After installing the plugin in Google Sheets, click Add-ons > API Connector > Open
A window will open on the right side of your browser. In the Create tab, leave the Method as GET. Under API URL path, enter the following API URL:
This API doesn’t require any headers, so just leave that section blank. This is an open, public API, so you can also skip the Authentication section.
Create a new sheet in your workbook. You can name it anything but here we’ll call it “iTunes”. Click ‘Set current’ to set this sheet 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.
Again we’ll name the request “iTunes”. Click Run.
Following the above steps, you should now be able to see music data from the iTunes API in your own sheet.
- include headers
- create an API request based on a cell
- set up scheduling
- troubleshoot any issues you’re having
- get data from popular APIs like YouTube, GitHub, Mailchimp, Shopify, OpenWeatherMap, and many others.
Check here for an introduction to API Connector in video form:
Please leave a comment below or in the API Connector user community. You’ll receive a response shortly!