Help & Support
Send Feedback
API Connector
API Connector lets you import API data directly into Google Sheets.
19,697 users
Works with
Install
Overview
Thousands of sites provide access to their platforms via an API. 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
*IMPORTAPI() custom function
*GET and POST support
*Save your API requests for future access
*Choose whether new data should overwrite or append to existing data
*Reference cells in API requests for dynamic queries
*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 8 daily API requests, while the paid versions allow many more requests, scheduling, and advanced features for power users.

Use this plugin to:
*Import Bitcoin and cryptocurrency price data
*Connect directly to trackers like CoinMarketCap & Binance
*Track your Facebook page likes and follows
*Build your own SEO analysis tool
*Analyze Mailchimp email activity
*Get employee time and project details from Harvest & Asana
*List out sales from your Shopify store
*Import weather data from OpenWeatherMap
*Create tons of other cross-platform reports, visualizations, and data mash-ups. Recommended if you like other connection tools like Cryptofinance, Zapier, and Supermetrics.This is a totally flexible add-on that connects to almost any platform, so you can build what you want!
Reviews
A User of API Connector
December 29, 2019
So simple and easy to use! Great support too
Submit reply
Cancel
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-8 of 8
Additional information
Search
Clear search
Close search
Google apps
Main menu