App Icon
Mixed Analytics
•  103,598
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
Amir Latif
November 23, 2020
What an amazing tool and the founder is super nice & supportive. I think my Google Sheets are now o totally rocket boosted. Excited to implement this system for reports and third party data. Thank you Ana for all the generosity, you truly won me over.
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
November 25, 2020
Thank you, hope your sheets are doing well in space :)
Profile Picture
Clarissa Rae
November 11, 2020
Great add-on... 👍👊
Is this review helpful?
Yes
No
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 :)
1-10 of 51
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu