App Icon
Mixed Analytics
•  94,734
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 code needed, just enter your API key or OAuth2 credentials to connect. 
👇 More info

🟢 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)

_______________________________________________________________________________________

🔥 Pro features:
*Schedule API pulls to refresh automatically
*Set trigger execution order
*Automatically handle pagination
*JMESPath query language support for filtering API results
*Preset OAuth 2.0 integrations for the following APIs: Ahrefs, Facebook Ads, Github, Google Analytics, Google Analytics Management, Harvest, Instagram Insights, LinkedIn Ads, QuickBooks, Quora Ads, Spotify, Strava,  Vimeo, Xero, YouTube Analytics, and YouTube Data. 
*Add your own custom OAuth2 API connections.

_______________________________________________________________________________________

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

💬 Fast, friendly support
https://mixedanalytics.com/contact/

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

_______________________________________________________________________________________

⭐️ Trial
When you install this add-on, you will 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.

_______________________________________________________________________________________

✅ 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
Jordan Rooney
October 14, 2020
Brilliant tool and easily syncs up with Strava to allow you to create a leaderboard better than what Strava actually offer themselves. Ana is also a class act - very helpful and quick to respond.
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
October 15, 2020
Thank you for your review, that's really cool you made a Strava leaderboard with API Connector.
Profile Picture
George Chen
October 6, 2020
I can honestly say without hyperbole, if I had to choose between sliced bread and API connector...I'd be meaning to switch to a low carb diet anyway!
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
October 7, 2020
Thank you! Glad that API Connector is useful for the keto community! :D
Profile Picture
André Mark
October 3, 2020
The Coingecko API is really good, provides me with all the information I require and saves me having to figure out how to pull this data into my spreadsheet, saved me a lot of time, thanks!
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
October 7, 2020
Cool, I'm glad API Connector helps with your crypto data gathering!
Profile Picture
cryptocurrency prediction
September 26, 2020
Awesome work. made our life very easy.
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
September 27, 2020
Thanks, that's great to hear!
Profile Picture
Eye Blow
September 19, 2020
Is this tool for free and pro functions paid or fully paid after trial period?
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
September 20, 2020
It's free. After the trial period you can choose to upgrade to a paid plan or continue using the free version.
Profile Picture
Dinesh Puritipati
September 16, 2020
Awesome and fast support from Ana. Really loved the tool. Easy to customize the reports on google sheets.
Is this review helpful?
Yes
No
Profile Picture
MigaTrendz Fashion.solutions
September 15, 2020
active support always
Is this review helpful?
Yes
No
Profile Picture
Maria Jane Poncardas
September 9, 2020
Their support is active and it directly answers what we inquired of
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
September 9, 2020
Thanks! We try :)
Profile Picture
Ikram Barkad
September 3, 2020
This is really amazing for me. But before I purchase a subscription, I would like to know how to get Shopify Events API to return the shipping_label_created_success including the order number and also API products for specific products including the order number. Thanks
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
September 4, 2020
Thanks, I'm glad you like API Connector! For your first request, it sounds like you need to query the /admin/api/2020-04/events.json endpoint, and then include a filter to get the exact event you need. For the second one, you can query /orders.json?status=any as this returns both products and order numbers. For more detailed help, please contact support through the add-on or the site.
Profile Picture
Snug Team
August 24, 2020
I have an API token, is there a way to use this with this app?
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
August 25, 2020
Please contact support so we can discuss your reporting requirements.
Profile Pciture
Michael Lindenbaum
August 25, 2020
I have several customers who want my software application to post reporting results directly to google sheets for them. If the sheets are set up as public, is there a simple way to do this without OAuth and where the sheets can be in their accounts rather than in mine? Any suggestions would be great...if this add on can do that, how would it work for different sheets?
Profile Pciture
Ana Kravitz
August 24, 2020
Yes, API tokens can be added as query parameters in the URL or as key-value pairs in the request headers. Each API's documentation should say which method they require, and either method is supported by API Connector.
1-10 of 49
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu