App Icon
Mixed Analytics
•  
200,461
Overview
Connect and import data from APIs to Google Sheets.
API Connector has a powerful, easy-to-use interface that lets you pull data from nearly any API into your Google Sheets worksheet. No code needed, just enter your API key or OAuth2 credentials to connect. 
👇 More info

✨ Standard (free) 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 
*Four built-in JSON-to-Sheets converter algorithms for handling nested JSON data
*Works with all major data formats (JSON, XML, and CSV)
*Log timestamps and request URLs to your output sheet
*Import Curl commands and preset request files
*8 daily requests, 3 saved requests

_______________________________________________________________________________________

🔥 Pro features:
*Schedule API pulls to refresh automatically
*Set trigger execution order
*Cycle through a list of stacked requests
*Automatically handle pagination
*JMESPath query language support for filtering API results
*Preset OAuth 2.0 integrations for the following APIs: 
➜Facebook Ads
➜Github
➜Google Ads
➜Google Analytics
➜Google Search Console
➜Harvest
➜Instagram Insights
➜LinkedIn Ads
➜QuickBooks
➜Quora Ads
➜Spotify
➜Strava
➜Vimeo
➜Xero
➜YouTube
➜Zoho CRM 
*Add your own custom OAuth2 API connections.

_______________________________________________________________________________________

⭐️ Trial
When you install this add-on, you automatically enter a 7-day free trial that activates all premium features. After 7 days, you will be switched to the free plan. 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.

_______________________________________________________________________________________

📓 Beginner-friendly templates & tutorials:
https://mixedanalytics.com/knowledge-base/

💬 Fast, friendly support
https://mixedanalytics.com/api-connector-contact-form/

🧑‍🤝‍🧑 User forum
https://www.reddit.com/r/api_connector/

_______________________________________________________________________________________

✅ Use cases
*Import Bitcoin and crypto currency price data
*Connect directly to trackers like CoinMarketCap / Binance / CoinGecko etc.
*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 / Trello etc.
*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 Postman, 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
sukesh sukesh
June 19, 2021
Is
Is this review helpful?
Yes
No
Profile Picture
Mark Mazza
June 18, 2021
After CMC sells you on this, you find out after the install that it won't update unless you manually go into the connector and push a button. You can't code for it to update even a measly once a day. This is no way for a company to gain a following. I understand the need to make money, but this is just petty toward beginners who don't have the disposable income. Those 8 manual retrieves should be 8 auto retrieves...or even 1 retrieve a day. Just going to the website impacts CMC's servers more than a single retrieve through their API.
Is this review helpful?
Yes
No
Profile Pciture
mixed analytics
June 20, 2021
Hey Mark, Thanks for the feedback! However just to clarify, we aren't associated with CMC. We are a generic swiss army knife dev tool that can be applied to (almost) any API. We are in the process of doing some improvements to API Connector and I'll pass on the idea of a single auto refresh to our tech team.
Profile Picture
Robert Conklin
June 15, 2021
Amazing API Connector! Can be used in various projects, Ana is super helpful and thorough
Is this review helpful?
Yes
No
Profile Picture
Md. Al Mamun Sohag
June 11, 2021
Great
Is this review helpful?
Yes
No
Profile Picture
Jorge Lopezcastaneda
June 10, 2021
great app
Is this review helpful?
Yes
No
Profile Picture
Mike Olivas
June 10, 2021
This is a great tool. We use it to sync down github info for 25 repositories and it works wonderfully.
Is this review helpful?
Yes
No
Profile Picture
Ingrid Hurtado
May 6, 2021
I love it, I just need some support, since yesterday (05-may) I have a connection error with Kobo, the services in Kobo are working fine, but the last 6 records doesn´t show in the Google Spreadsheet, does anybody know how to solve it?
Is this review helpful?
Yes
No
Profile Pciture
Rachmat Ramadhan
May 12, 2021
Mba Inggrid cara mendapatkan API Kobo nya bagaimana ya ? Thx
Profile Pciture
mixed analytics
May 9, 2021
Hi Ingrid! If you need help setting up the extension I would suggest checking out our Reddit community. Otherwise, I may suggest that you add &limit=250 to the end of your URL.
Profile Picture
Maxence Bruyas
May 5, 2021
it was really awesome and easy to use, until the team decided to monetize it : - make you pay for the automatic refresh - manual refresh capped to 8 per day - requests capped to 3
Is this review helpful?
Yes
No
Profile Pciture
Maxence Bruyas
May 11, 2021
I totally understand the need to cover your costs and generate margin. However I strongly disagree with monetizing features which were previously free such as automatic refresh (I only need 1 refresh every 2 hours so I don't think I consume a lot of resources :) ). This is basically a robbery when looking at the time invested to create dashboards around features which are now payable. How do we know that you're not gonna make us pay for 1 refresh per day for example ?
Profile Pciture
mixed analytics
May 9, 2021
Hey Maxence, I'm sorry the basic version doesn't cover your needs :( We wanna make sure we can keep our team running so we do have to charge for more premium services that consume a greater amount of our resources.
Profile Picture
Mirko Faraone
May 5, 2021
Fantastic Add on and extraordinary customer service! Ana you are the best 👍
Is this review helpful?
Yes
No
Profile Picture
Derek Lam
May 1, 2021
error, pricey
Is this review helpful?
Yes
No
Profile Pciture
mixed analytics
May 9, 2021
Hey Derek, sorry to hear about errors :( Our reddit community is quite active in responding to issues, so if you are willing to give us another shot you can drop by there and leave your error messages there for us to solve together. As for pricing, our pricing model allows free users basic access to our tool, with a very healthy boost of features when you choose to go pro.
1-10 of 95
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu