Help & Support
Send Feedback
API Connector
API Connector lets you access API data from thousands of platforms directly within Google Sheets.
5,244 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.

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
*Reference cells in API requests
*Choose how to display nested JSON data with a built-in JSON-to-Sheets converter
*Schedule API pulls to refresh automatically on an hourly, daily, weekly, or monthly basis (paid feature)

When you install this add-on, you will automatically enter a 7-day free trial that activates all features. After 7 days, you can choose to upgrade to a paid plan or continue using the free features. The free version of this add-on enables up to 10 daily API requests, while the paid version allows unlimited requests, scheduling, 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 sales 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
Reviews
A User of API Connector
October 18, 2019
Awesome add-on that works perfectly! Couple of hours saved every month since I'm using it. Massive thanks to Ana (the developer) who is also providing 5 stars support with all the queries I had. Highly recommended for users who often deal with CSV exports from many platforms.
Submit reply
Cancel
A User of API Connector
October 16, 2019
Fantastic little app - with great support from the maker!
Submit reply
Cancel
Cameron Brownlee
October 8, 2019
Good support from devs if you have problems!
Submit reply
Cancel
Ana Kravitz
October 9, 2019
Thank you, Cameron!
A User of API Connector
August 1, 2019
Wow, importing JSON has never been easier. It's nice to a have a little GUI when working with shared docs and such since not everybody knows APIs. Also, scheduling repeated api calls is a great feature. Dev reached out to me after I left a comment on their website within a few hours, I was pleasantly surprised.
Submit reply
Cancel
A User of API Connector
July 30, 2019
Such a great product! I've been trying to accomplish this on my own for weeks!
Submit reply
Cancel
A User of API Connector
July 29, 2019
Ana is a superstar, I was having problems with it because I didn't know what I was doing so I emailed the developer and she was really helpful. Great product and great customer service!
Submit reply
Cancel
Ana Kravitz
July 30, 2019
Thanks, Tom! Feel free to message me with any more questions.
A User of API Connector
July 29, 2019
It's simple and useful for even beginners!
Submit reply
Cancel
1-7 of 7
Additional information
Search
Clear search
Close search
Google apps
Main menu