Connect and import data from any API to Google Sheets™
Listing updated:November 30, 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:
*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

_______________________________________________________________________________________

🔥 Paid 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/
Additional information
PricingFree of charge with paid features
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 :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu