App Icon
Mixed Analytics
•  167,844
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 Analytics, Google Analytics Management, Harvest, Instagram Insights, LinkedIn Ads, QuickBooks, Quora Ads, Spotify, Strava,  Vimeo,YouTube Analytics, and YouTube Data. 
*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
David Foster
April 16, 2021
Amazing tool, amazing team!
Is this review helpful?
Yes
No
Profile Picture
Josef Heks
April 15, 2021
Fantastic tool, easy to use and excellent documentation and technical support by the developer. Great for getting data out of Harvest and into your Google Sheets for budgeting and time tracking.
Is this review helpful?
Yes
No
Profile Picture
Ben Muller
April 9, 2021
Excellent tool. Excellent support. Ultimate connector for getting access to import reports and action API calls from those tough to access places.
Is this review helpful?
Yes
No
Profile Picture
Cem Özdemir
April 5, 2021
Awesome tool, even better guides on the website, too! I'm just loving it! Developer is kind & helpful.
Is this review helpful?
Yes
No
Profile Picture
cagil undar
April 2, 2021
Thanks for all your work and this beautiful bridge.
Is this review helpful?
Yes
No
Profile Picture
Rex Blueskyes
March 29, 2021
masterful
Is this review helpful?
Yes
No
Profile Picture
Gökçe Çakar
March 28, 2021
Is there a way to add a button to Google Sheets to "Refresh All"
Is this review helpful?
Yes
No
Profile Picture
Gabriel Shaw
March 27, 2021
you have to pay to do basic stuff
Is this review helpful?
Yes
No
Profile Picture
Tom Schultz
March 24, 2021
Not working on ChromeOS. Was working on Windows.
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
March 26, 2021
Hi there, sorry you're having trouble getting connected. Most likely it's related to your cookie settings or a Google bug related to being logged into multiple accounts. Please check out the troubleshooting guide in the knowledgebase for info on resolving these issues.
Profile Picture
Jay Oren
March 21, 2021
Really nice addon, I'm using it to pull in data from iTunes and YouTube. Documentation is really clear and well-organized, and it makes a lot of complex tasks easy.
Is this review helpful?
Yes
No
1-10 of 85
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu