Check out the store for many more

API Connector

404 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. Currently limited to GET requests (POST requests coming soon!)

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
*See recent tweets from Twitter
*Create cross-platform data mashups, reports, and visualizations

*Easy-to-use interface
*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. (All features except scheduling remain free after trial period)


Version: 5
Updated: June 16, 2019
Language: English