App Icon
Mixed Analytics
•  92,108
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. Just enter your URL and API key to connect. 

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)
*Library of beginner-friendly tutorials at https://mixedanalytics.com/knowledge-base/
*Fast, friendly support to get you up and running! 
(https://mixedanalytics.com/contact/)

Pro Features: 
*Schedule API pulls to refresh automatically
*Set trigger execution order
*Automatically handle pagination
*Built-in query language for filtering API results
*One-click OAuth 2.0 integrations for the Ahrefs API, Github API, Google Analytics API, Harvest API, Instagram Insights API, LinkedIn Ads API, QuickBooks API, Quora Ads API, Vimeo API, and YouTube Analytics API. 
*Add your own custom OAuth2 API connections.

When you install this add-on, you will automatically enter a 7-day free trial that activates all features. After 7 days, you can choose to upgrade to a paid plan or continue using the free features. 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 this plugin to:
*Import Bitcoin and crypto currency price data
*Connect directly to trackers like CoinMarketCap & Binance
*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
*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 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
A User of API Connector
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
A User of API Connector
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
A User of API Connector
September 15, 2020
active support always
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
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
A User of API Connector
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
A User of API Connector
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
A user of API Connector
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.
Profile Picture
A User of API Connector
August 21, 2020
Already in love. Tried both the single row output and the grid output, and I see the work put in to ensure cohesive column naming. Thanks, Ana, love from 🇯🇲.
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
August 23, 2020
Awesome, thank you for trying API Connector!
Profile Picture
A User of API Connector
August 12, 2020
Absolutely amazing tool, Ana has saved me so much money on a Supermetrics subscription, and helped me with my queries every step of the way! Will be recommending this to everyone.
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
July 21, 2020
fantastic piece of kit to add onto your googlesheets masterpieces
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
July 2, 2020
Is there a way to setup a two-way sync from Asana Projects to Google Sheets? We want to be able to update either source (Asana Project or Google Sheet) and the other source will automatically be updated as well...
Is this review helpful?
Yes
No
Profile Pciture
Ana Kravitz
July 2, 2020
You should be able to do this with scheduled requests that GET/POST data in and out of your sheet to Asana. Please send a message to support so we can talk about your requirements in more detail.
1-10 of 45
Additional information
Mixed Analytics
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu