Mixed Analytics
•  86,733
Overview
Connect APIs to Google Sheets.
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)
*Automatically handle pagination (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 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 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 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!
Reviews
Language:
Sort by:
A User of API Connector
March 25, 2020
What an amazing Tool. As a beginner in BI, this tool helped me a lot to concentrate on getting things done instead learning coding and connecting APIs first. This tool is worth every cent! For common Data Sources (Mailchimp, Facebook etc. there are wonderful step by step guides. But also for other APIs its simple to connect. Just as a wish: It would be awesome to have a direct integration from APIs to Google Biq Query in that style.
Is this review helpful?
Yes
No
Ana Kravitz
March 25, 2020
Thank you for your awesome review. It's difficult to use API Connector with Big Query because their API authenticates with OAuth 2.0 rather than API keys, so I suggest using an add-on specifically designed for Big Query instead (I think there are a few).
A User of API Connector
March 17, 2020
Really amazing app! Wish the cost wasn't there but thus far its the only thing Ive found to accomplish the tasks I'm trying to complete. Really, really great job.
Is this review helpful?
Yes
No
Ana Kravitz
March 17, 2020
Thank you, I'm glad you like it! And I appreciate the fair feedback, I love free software too :p But I think API Connector is still very cheap for the value it offers (and it's free anyway unless you choose to upgrade), and the fee ensures that I'll keep supporting and improving it.
A User of API Connector
March 14, 2020
I used to use Supermetrics custom JSON connector but they got a bit expensive, so I looked for alternatives. This works really well and has some great features like automatic pagination handling.
Is this review helpful?
Yes
No
Ana Kravitz
March 14, 2020
Thanks for the comment. There are more new features coming!
A User of API Connector
February 28, 2020
How much does it cost?
Is this review helpful?
Yes
No
Ana Kravitz
February 28, 2020
It’s free, though you can upgrade to a paid plan if you want higher limits and some advanced features. Click the “upgrade” link in the addon to see pricing details.
A User of API Connector
February 12, 2020
A monthly cost to schedule triggers is overkill. I'd be fine with a one time fee, even if it were high but monthly is absurd. Especially when you can trigger it manually for free.
Is this review helpful?
Yes
No
Ana Kravitz
February 13, 2020
Thanks for your feedback. The monthly fee is for support, higher request limits, multi-query requests, and additional saved limits as well as triggers. As you note, the add-on lets you trigger manually for free.
A User of API Connector
February 10, 2020
if only it allows trigger more frequent, it can be a live data feed. It is still a great add-on nevertheless.
Is this review helpful?
Yes
No
Ana Kravitz
February 10, 2020
Hi there, unfortunately this is Google's policy -- they don't permit add-ons to run triggers more than once an hour. However, API Connector also activates a custom function called importAPI() which enables data refreshing every 2 minutes. Please check the documentation or send over a note for more info.
A User of API Connector
February 5, 2020
Ana, Thank you so much for your support and for your great tool! I know that you have an awesome product and would love to see how it evolves over time. I really like the fact that your product gave life to my sheets and the fact that all of my needs were met and your exceptional customer support! Good luck with all of your endeavors and God bless!
Is this review helpful?
Yes
No
Ana Kravitz
February 6, 2020
Thanks for the feedback, and hope to give life to many more sheets in the future :)
A User of API Connector
December 29, 2019
So simple and easy to use! Great support too
Is this review helpful?
Yes
No
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.
Is this review helpful?
Yes
No
A User of API Connector
October 16, 2019
Fantastic little app - with great support from the maker!
Is this review helpful?
Yes
No
1-10 of 15
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu