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:
*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:
 Integrates with thousands of interesting, unique, and popular data APIs. This is a totally flexible add-on that connects to almost any platform, so you can build what you want.  Hundreds of APIs are available through a built-in library, or add your own custom connection in a no-code interface. 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/