Connect and import data from any API to Google Sheets™
Listing updated:August 14, 2024
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

✨ 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:
 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/

_______________________________________________________________________________________

📓 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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Rafi Ullah
October 3, 2024
Hello good morning sir My name is Rafiullah I'm from Pakistan I want to make experience with API Connector
Is this review helpful?
Yes
No
Profile Picture
Hermann Kelch
September 21, 2024
I want to make experience with API Connector before I get better voice for
Is this review helpful?
Yes
No
Profile Picture
Mohammad Umar Iraquee
September 29, 2024
Amazing
Is this review helpful?
Yes
No
Profile Picture
Ben Lay
March 11, 2024
I've been using this for years without any issue. Logged in today and I am now limited to 1000 records unless I pay. It's not like calling an api is rocket science. I'll just switch to one of the 100 other free versions.
Is this review helpful?
Yes
No
Profile Picture
Radim
March 15, 2024
Tutorial says: Go to Extensions -> API Connector -> Open. Well, all I see is "Help" which takes me to tutorial which says I should see "Open". But Open is not showing up. So it's not working for me.
Is this review helpful?
Yes
No
Profile Picture
Nsa Effanga (Willyboy)
August 31, 2024
The future is here Best app good work guys 💪 Keep it going 💯
Is this review helpful?
Yes
No
Profile Picture
Mukesh Kumar
August 14, 2024
Nice
Is this review helpful?
Yes
No
Profile Picture
Alfredo Eduardo Garc
July 26, 2024
Good perfect thanks
Is this review helpful?
Yes
No
Profile Picture
tharu priyankara
July 25, 2024
Very good and love it
Is this review helpful?
Yes
No
Profile Picture
Jeroen Backx
February 5, 2024
it was great until they decided to make scheduling exclusive to the paid program. Now I will look for something else.
Is this review helpful?
Yes
No
1-10 of 148
Search
Clear search
Close search
Google apps
Main menu