Mixed Analytics
•  92,879
Overview
Import API data to Google Sheets.
API Connector has a powerful, easy-to-use interface that lets you pull data from any API into your Google Sheets worksheet. No coding required; just enter your URL and API key. 

Features:
*Intuitive interface
*GET and POST support
*Save your API requests for future access
*IMPORTAPI() custom function 
*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 three built-in JSON-to-Sheets converter algorithms
*Library of beginner-friendly tutorials

Pro Features: 
*Schedule API pulls to refresh automatically
*Automatically handle pagination
*Built-in query language for filtering API results
*OAuth 2.0 integrations for Github, Harvest, QuickBooks, Quora Ads, and Vimeo (more coming soon)

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 pro versions allow many more requests, scheduling, and advanced features for power users.

Use this plugin to:
*Import Bitcoin and crypto currency 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 time and project details from Jira & Asana
*Track sales from your Shopify store
*Import weather data from OpenWeatherMap
*Create tons of other cross-platform reports, visualizations, and data mash-ups for marketing, analytics, and no-code projects. Recommended if you like other scraping & 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. Like Postman for Sheets!
Reviews
Language:
Sort by:
Dale Pease
June 4, 2020
This is the solution that I'd been looking several weeks for. With API Connector, I'll be able to connect Google Sheets to our CRM platform, and then connect a myriad of other apps to Google Sheets. The developer, Ana, was absolutely fabulous in helping me get everything set up and working. It is actually really hard to find a technical person who can speak to us non-techy folks in a language we understand. Ana did a great job helping me every step of the way. Many thanks!
Is this review helpful?
Yes
No
A User of API Connector
May 28, 2020
Tried to connect, the app got stuck in a loop can't do anything, help support doesn't seem to be available.
Is this review helpful?
Yes
No
Ana Kravitz
May 28, 2020
Sorry you had trouble connecting, but I didn't receive any support request.
A User of API Connector
May 18, 2020
This tool is so amazing! It allows you to handpick what data you need and summarize it in the friendly confines of Google Sheets!
Is this review helpful?
Yes
No
A User of API Connector
May 15, 2020
Wow is all I can say. As a data analyst, this tool has made my life so much easier. Instead of having to hard code my own API calls in Python, I can grab my data quickly and easily with this Add-On and immediately get to visualizing and making ML models. Knowledge Base is well documented and organized. As a bonus, Ana is quick to help with any issues that you can't solve looking through the documentation. Thanks a billion!
Is this review helpful?
Yes
No
Dave Mills
May 13, 2020
Great Add-on! Excellent value considering the amount of time I'm saving in writing calls myself. Reported an issue that was due to an API not being documented properly (rather than the add-one itself) and Ana had it fixed and up and running in less than 24 hours. Recommended!
Is this review helpful?
Yes
No
A User of API Connector
April 28, 2020
This add-on a cost- effective way to connect to APIs through Google Sheets. Ana is very helpful and quick to assist. Using Postman is great for testing out your API Connector requests to check that you are getting the right data.
Is this review helpful?
Yes
No
Ana Kravitz
May 2, 2020
Thanks! Yes, Postman is a great tool to see raw responses before they get processed into Sheets.
A User of API Connector
April 23, 2020
I have been teaching myself to use API for a few days now. I didn't even know they existed beforehand. Using the API connector made it easy to do everything I wanted and more.
Is this review helpful?
Yes
No
Ana Kravitz
May 2, 2020
Thanks, I'm glad API Connector helps you with learning how to use APIs.
A User of API Connector
April 22, 2020
The best app out there for someone who is not an expert in the field to fetch data from an API and put it into Sheets in a human readable format! Great value for the price. The customer support is also next level, very thorough and quick responses to help you get up and running!
Is this review helpful?
Yes
No
Ana Kravitz
May 2, 2020
Thank you, APIs are definitely not just useful for experts :)
A User of API Connector
April 20, 2020
Works great and excellent support!
Is this review helpful?
Yes
No
A User of API Connector
April 17, 2020
This is a great app. What surprised me the most was that I'm using a free version but still got great customer support. Emailed them with some questions and received friendly and clear instruction, almost immediately. The app's feature is great, this is the only tool I found so far that really helped me with my tasks.
Is this review helpful?
Yes
No
Ana Kravitz
April 17, 2020
Thank you for the review!
1-10 of 30
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu