Mixed Analytics
•  91,184
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, and Quora Ads (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:
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!
A User of API Connector
April 15, 2020
My experience has been amazing!! The app works very well, has very good documentation with various examples and excellent customer support it really exceeded my expectations! The most important feature, in my opinion, is the JMESPath option that feature really sealed the deal for me. In my case it reduced file size going from 70+ columns to just 15 and simplifying my workload too as I was creating various formulas and triggering google scripts to make the data look pretty, but not anymore! That feature is gold! Really great work!!
Is this review helpful?
Yes
No
Ana Kravitz
April 17, 2020
Nice! I agree, JMESPath is pretty cool.
A User of API Connector
April 15, 2020
The work developed on this addon is truly impressive - amazing how well it works but especially how well documented it is. This is a life saver!
Is this review helpful?
Yes
No
Ana Kravitz
April 17, 2020
Thank you, I'm glad you like API Connector.
1-10 of 28
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu