Mixed Analytics
•  96,696
Overview
Connect and import data from any API 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:
*GET, POST, and PUT 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
*IMPORTAPI() custom function 
*Three built-in JSON-to-Sheets converter algorithms for handling nested JSON data
*Works with all major data formats (JSON, XML, and CSV)
*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 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 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:
Profile Picture
A User of API Connector
July 2, 2020
Is there a way to setup a two-way sync from Asana Projects to Google Sheets? We want to be able to update either source (Asana Project or Google Sheet) and the other source will automatically be updated as well...
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
July 2, 2020
You should be able to do this with scheduled requests that GET/POST data in and out of your sheet to Asana. Please send a message to support so we can talk about your requirements in more detail.
Profile Picture
A User of API Connector
July 1, 2020
Can we use this to connect Jira api ( server instances ). If so , how can we include client cert configurations ?
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
July 1, 2020
In general, you should be able to connect to both the Jira Cloud API and Jira Server platform API, but it sounds like your server requires an additional client certificate for authentication. Unfortunately there is no way to attach a client certificate file through API Connector, so that won't work here. Sorry for the inconvenience. I'll look into adding support for client certificates in the future.
Profile Picture
Brian Frick
June 29, 2020
I was already sold, but when I saw that you added the Archive Data from Mixed Analytics as well, I'm all-in. My Data Studio Reports are about to be next-level. Thanks for the hard work on this.
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
June 22, 2020
This is really amazing for me.
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
June 21, 2020
This is a fabulous add-on. I've used it to connect to several financial api services without a single hiccup. Although the PRO version offers scheduling, I do wish that the base version could be used as a code generator so that api requests could be embedded (and triggered) in google scripts. All in all -- very nicely done!
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
June 22, 2020
Thank you for your review! A code generator is an interesting idea. Please send over a message, I'd be happy to chat more about what you're looking for.
Profile Picture
David Browne
June 8, 2020
While intimidating for a first time user of APIs, this app makes the process simplified and has pretty much all bases covered in pagination, error handling and opens up data exploration for both hobbyists and professionals (for reporting purposes) alike. Customer support has also been 5 stars. Highly recommended.
Is this review helpful?
Yes
No
Profile Picture
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
Profile Picture
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
Profile Pciture
Ana Kravitz
May 28, 2020
Sorry you had trouble connecting, but I didn't receive any support request.
Profile Picture
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
Profile Picture
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
1-10 of 36
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu