App Icon
Mixed Analytics
•  112,944
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

✨ 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

_______________________________________________________________________________________

🔥 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: 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
Karl O'Connor
January 22, 2021
Great tool, Great service love it
Is this review helpful?
Yes
No
Profile Picture
Ebbe Kjær Skau
January 19, 2021
We are using API Connector to feed our dashboards, and keeping a daily overview on performance across many clients. .. The tool is easy to use. Rare to see customer service at this level - thanks a lot! Highly recommend!
Is this review helpful?
Yes
No
Profile Picture
Άγγελος Χρονοπουλος
January 17, 2021
extremely useful add on, it makes our lives easier! Also, i had years to see support like this. Extremely helpful people
Is this review helpful?
Yes
No
Profile Picture
Frank Kosik
January 5, 2021
Great add on and support 👍
Is this review helpful?
Yes
No
Profile Picture
Andrew Salt
December 12, 2020
Very good tool for bringing API data into Google Sheets. The Knowledge Base link on their site is very useful, and the development team are very responsive to queries on their pages and forums. It has helped me to connect to Stripe, Paypal, FaceBook Ads and a few custom API feeds for our data. Very happy user
Is this review helpful?
Yes
No
Profile Picture
Kartik Sapra
December 12, 2020
Super helpful Documentation is very proper, and all queries are resolved in less than 24 hrs Ana is a rockstar and trusted partner, totally recommend it to every data enthusiast!
Is this review helpful?
Yes
No
Profile Picture
Ana Hassel
December 11, 2020
This API connector is Brilliant. I reached out to the creator as I am quite new to this, and loved the instructions she pointed me to. Very thorough. The support turnaround was super quick. I am planning to expand with this, I love automation :) Another very happy customer!!
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
December 15, 2020
Thanks for such a positive review, automation is key!
Profile Picture
Daniel Mori
December 11, 2020
Excellent tool and support. I've built many reliable processes thanks to API Connector. Very happy customer here.
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 7, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Jesse Pavey
December 4, 2020
It works well, but I can only seem to fetch 25 rows of data. Is this a limitation of the free trial? Thank you.
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
December 4, 2020
The free version of API Connector has no limitation on the number of rows it returns. However it's pretty common for APIs to limit the data they send back at once (this is called pagination). API Connector has built-in pagination handling, if you shoot a message to support I'll be happy to give you more info about how that works.
1-10 of 61
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu