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

✨ Free features:
*100 monthly requests
*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
*4+ 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
*Automatically handle pagination
*JMESPath query language support for filtering API results
*Connect to integrated APIs by clicking a button (OAuth)
*Create custom OAuth connections

_______________________________________________________________________________________

🔥 Paid features:
*Schedule API pulls to refresh automatically
*Set trigger execution order
*Higher save/run limits

_______________________________________________________________________________________



✅ 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 Business, 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/

_______________________________________________________________________________________

📓 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/