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)