App Icon
Mixed Analytics
•  
199,618
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, Google Ads, Harvest, Instagram Insights, LinkedIn Ads, QuickBooks, Quora Ads, Spotify, Strava, Vimeo, Xero, YouTube Analytics, YouTube Data, and 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
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.
Profile Picture
Thomas Porhel
April 27, 2021
This API connector is fantastic. It was so easy to get data from multiple sources and to build the report I needed. Support is exceptional as well. I was stuck and asked their support for advice and got a working solution super fast.
Is this review helpful?
Yes
No
Profile Picture
Owen Heintz
April 26, 2021
Cant even do what its supposed to do... When I "add new" nothing happens the button just gets the border like its been clicked.
Is this review helpful?
Yes
No
Profile Pciture
mixed analytics
May 9, 2021
Sorry you were having issues Owen :( Occasionally other browser extensions can interfere with our extension, so I may suggest running in a private browsing window to help mitigate this. Otherwise, our reddit community is quite active if you wanna give us another shot!
Profile Picture
David Foster
April 16, 2021
Amazing tool, amazing team!
Is this review helpful?
Yes
No
1-10 of 92
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu