Check out the store for many more

API Connector

1,506 users


API Connector lets you access API data from thousands of platforms directly within Google Sheets. No coding required!
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.

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

*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
*Schedule API pulls to refresh automatically on an hourly, daily, weekly, or monthly basis (paid feature)
*2 weeks free trial automatically enabled upon installation


Version: 11
Updated: July 15, 2019
Language: English