App Icon
Connect and import data from any API to Google Sheets.
Listing updated:June 7, 2023
Works with:
1M+
Overview
API Connector is a powerful, easy-to-use extension that pulls data from any API into Google Sheets. Start quickly with a library of ready-to-use APIs, or create your own custom connections to the data sources you choose.

👇 More info

✨ Standard (free) features:
*Free, unlimited requests through the IMPORTAPI() custom function 
*Access thousands of preset requests through a built-in API library
*Visual field editor to filter and re-arrange fields
*Save your API requests for future access
*Choose whether new data should overwrite or append to existing data
*Use cell values in API requests for dynamic queries
*Four built-in JSON-to-Sheets converter algorithms
*GET / POST / PUT / PATCH /  DELETE support
*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
*Preview JSON output
*JMESPath query language support for filtering API results
*250 monthly sidebar 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
*Higher save/run limits
*Connect to APIs by clicking a button (OAuth)
_______________________________________________________________________________________


✅ Integrations:
➜3Commas, 7Timer, AccuWeather, ActiveCampaign, AdRoll, Aftership, Ahrefs, Airtable, AlphaVantage, API-Football, AppsFlyer, Asana, BambooHR, BaseLinker, BigCommerce, Binance, BscScan, Brokermint, ChargeBee, ChatGPT/OpenAI, CJ Affiliate, Clickbank, ClickUp, Clockify, CoachAccountable, CoinAPI, Coinbase, CoinGecko, Coinmap, CoinMarketCap, ConstantContact, ConvertKit, Copper CRM, Criteo, Crunchbase, CryptingUp, CryptoCompare, Data Golf, eBay, Etsy, EventTemple, Facebook Ads, Facebook Pages, Financial Modeling Prep, Freshdesk, Geocode, Github, Google Ads, Google Analytics (UA and GA4), Google Calendar, Google Classroom, Google Cloud Vision, Google Custom SERP,  Google Drive, Google Maps, Google PageSpeed Insights,  Google Search Console, Harvest, Hubspot, Hunter, IMDB, Instagram Insights, Intercom, iTunes, Jira, Keepa, Klaviyo, KoboToolbox, Kraken, KuCoin, LinkedIn Ads, LinkedIn Pages, Mailchimp, Mapbox, Netflix Unofficial, Notion, Okta, OpenAI (ChatGPT), OpenSea, OpenWeatherMap, Paypal, Pipedrive, Pinterest Ads, Procore, Product Hunt, QuickBooks, Quora Ads, Reddit, Ship24, ShipStation, Snapchat Ads, Spotify, Strava, Stripe, TD Ameritrade, Toggl, Trello, Twitter, Udemy, Vimeo, VWO, Wildberries, WooCommerce, Wordpress, Xero, Yahoo Finance, YouTube Data,  Zendesk, Zoho CRM + many more interesting, unique, and popular data APIs. Recommended if you like scraping and connection tools like Coupler, Supermetrics, Zapier, and Postman. This is a totally flexible add-on that connects to almost any platform, so you can build what you want.  See more at https://mixedanalytics.com/integrations/

_______________________________________________________________________________________

⭐️ Trial
When you install this add-on, you automatically enter a 14-day free trial that activates all premium features. After 14 days, you will be switched to the free plan. 

_______________________________________________________________________________________

📓 Beginner-friendly templates & tutorials:
https://mixedanalytics.com/knowledge-base/

💬 Fast, friendly support from Mixed Analytics
https://mixedanalytics.com/contact/

🧑‍🤝‍🧑 User forum
https://www.reddit.com/r/api_connector/
Additional information
PricingNot available
Privacy policy
Terms of service
API Connector will ask for the permissions shown below. Learn more
API Connector will need access to your Google account
This will allow API Connector to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
AnhQuang911
May 1, 2023
working so slow + when you track total 100 packages per days. The old tracking still count in. For example. Last couple day you track 50 trackings. Today you tracking 60 trackings. and you have limited for 10 trackings that you can't track. JUST BECAREFUL using it.
Is this review helpful?
Yes
No
Profile Picture
twoAlgo
December 4, 2022
Add-on works well. Yet, it can't be used anymore to connect to Binance. Be aware of it, and let's hope that the developer will take the necessary technical effort to update the app and allow again the connection to Binance.
Is this review helpful?
Yes
No
Profile Picture
Nicholas Harris
April 4, 2023
Great app, friendly customer support
Is this review helpful?
Yes
No
Profile Picture
Chris Colotti
July 29, 2022
it works very well. My only bummer is I need this for ONE simple API call monthly and the free tier does not even include just one basic schedule. I get it, but for a very small use case like mine having 1-2 available triggers with no less than a monthly execution would be great. Then if you need more move to a paid plan, but having zero triggers on the free tier with 250 monthly calls seems short sighted.
Is this review helpful?
Yes
No
Profile Picture
John Derringer
April 12, 2022
First - This tool is exceptionally well built, intuitive, reliable, and has great documentation. If you are new to APIs you can get a basic connection up and running quickly. My first connection was up in less than 30 minutes including install time. Second - As many other reviewers have said Ana is amazing. We ran into a few self-inflicted issues setting up a custom API and she not only helped troubleshoot our connection but explained every step in detail so that we could learn from our mistakes. Third - For all of the reviewers that left a poor review because there is a charge for premium features, shame on you. This tool is super useful and people should get paid for their labor. This tool is no different. It's also extremely inexpensive. A lot of work went into this tool and the support you get is top-notch. Thanks again, Ana!
Is this review helpful?
Yes
No
Profile Picture
Jonathan French
May 3, 2022
API Connector reduced a 6-7 minute process done manually, many times a day, down to about 30 seconds. The Knowledge Base and direct email support is very good.
Is this review helpful?
Yes
No
Profile Picture
Xavier Vespa
June 2, 2022
Awesome, very flexible, reliable, so many possibilities, and super reactive user support !
Is this review helpful?
Yes
No
Profile Picture
Nadir Nasir
March 22, 2022
Loved it at first... then they made batch queries a paid feature... then... the query does not even run. No way to debug or evaluate what the issue could be. Deleting!
Is this review helpful?
Yes
No
Profile Picture
Daniel Clark
February 24, 2022
Fantastic tool and a lifesaver for our data team. We can focus on analysis now, instead of uploads!
Is this review helpful?
Yes
No
Profile Picture
Jamie Thomson
February 18, 2022
Fantastic product, clear instructions, and unsurpassed support from Ana. Thoroughly recommend this product, it has allowed me do delve into using APIs in a clear and simple way.
Is this review helpful?
Yes
No
1-10 of 124
Search
Clear search
Close search
Google apps
Main menu