Help & Support
Send Feedback
API Connector
API Connector lets you access API data from thousands of platforms directly within Google Sheets.
248 users
Works with
Install
Overview
Thousands of sites provide access to their platforms via an API (application programming interface). The API Connector add-on has an intuitive, easy-to-use interface that lets you get data from these APIs into your Google Sheets worksheet. No coding required; just enter your URL and API key.

This add-on supports any API that returns data in the standard JSON format, using an API key for authorization and GET/POST methods. The free version of this add-on enables up to 10 daily API requests, while the paid version allows unlimited requests and some additional power features.

Use this plugin to:
*List popular YouTube videos by category
*Analyze Mailchimp email activity
*Get employee time and project details from Harvest & Asana
*List out products from your Shopify store
*Get AB test result details from Visual Website Optimizer (VWO)
*Import weather data from OpenWeatherMap
*Create tons of other cross-platform reports, visualizations, and data mash-ups

Features:
*Easy-to-use interface
*GET and POST support
*Save your API requests for future access
*View API responses directly in your sheet
*Choose whether new data should overwrite or append to existing data
*Choose how to display nested JSON data
*Schedule API pulls to refresh automatically on an hourly, daily, weekly, or monthly basis (paid feature)
Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu