App Icon
Connect and import data from APIs to Google Sheets.
Works with:
661,413
Overview
API Connector has a powerful, easy-to-use interface that lets you pull data from nearly any API into your Google Sheets worksheet. No code needed, just enter your API key or OAuth2 credentials to connect. 
👇 More info

✨ Standard (free) features:
*Free, unlimited requests through the IMPORTAPI() custom function 
*Save your API requests for future access
*Choose whether new data should overwrite or append to existing data
*Reference cells in API requests for dynamic queries
*Four built-in JSON-to-Sheets converter algorithms for handling nested JSON data
*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
*8 daily 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
*JMESPath query language support for filtering API results
*Higher save/run limits through the sidebar
*Preset OAuth 2.0 integrations for the following APIs: 
➜Facebook Ads
➜Github
➜Google Ads
➜Google Analytics
➜Google Search Console
➜Harvest
➜Instagram Insights
➜LinkedIn Ads
➜QuickBooks
➜Quora Ads
➜Spotify
➜Strava
➜Vimeo
➜Xero
➜YouTube
➜Zoho CRM 
➜Your own custom OAuth2 API connections.

_______________________________________________________________________________________

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

_______________________________________________________________________________________

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

💬 Fast, friendly support
https://mixedanalytics.com/api-connector-contact-form/

🧑‍🤝‍🧑 User forum
https://www.reddit.com/r/api_connector/

_______________________________________________________________________________________

✅ Use cases
*Import Bitcoin and crypto currency price data
*Connect directly to trackers like CoinMarketCap / Binance / CoinGecko etc.
*Track your Facebook page likes and follows
*Build your own SEO analysis tool
*Analyze Mailchimp email activity
*Get time and project details from Jira / Asana / Trello etc.
*Track sales from your Shopify store
*Import weather data from OpenWeatherMap
*Create tons of other cross-platform reports, visualizations, and data mash-ups for marketing, analytics, and no-code projects. Recommended if you like other scraping & connection tools like Postman, Zapier, and Supermetrics.This is a totally flexible add-on that connects to almost any platform, so you can build what you want.
Additional information
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:
Profile Picture
A User of API Connector
August 1, 2019
Wow, importing JSON has never been easier. It's nice to a have a little GUI when working with shared docs and such since not everybody knows APIs. Also, scheduling repeated api calls is a great feature. Dev reached out to me after I left a comment on their website within a few hours, I was pleasantly surprised.
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
July 30, 2019
Such a great product! I've been trying to accomplish this on my own for weeks!
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
July 29, 2019
Ana is a superstar, I was having problems with it because I didn't know what I was doing so I emailed the developer and she was really helpful. Great product and great customer service!
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
July 29, 2019
It's simple and useful for even beginners!
Is this review helpful?
Yes
No
Profile Picture
Gursimran Dhillon
February 17, 2021
so blessed fr
Is this review helpful?
Yes
No
Profile Picture
A User of API Connector
December 29, 2019
So simple and easy to use! Great support too
Is this review helpful?
Yes
No
Profile Picture
Tom Schultz
March 24, 2021
Not working on ChromeOS. Was working on Windows.
Is this review helpful?
Yes
No
Profile Picture
Amir Latif
November 23, 2020
What an amazing tool and the founder is super nice & supportive. I think my Google Sheets are now o totally rocket boosted. Excited to implement this system for reports and third party data. Thank you Ana for all the generosity, you truly won me over.
Is this review helpful?
Yes
No
Profile Picture
Dinesh Puritipati
September 16, 2020
Awesome and fast support from Ana. Really loved the tool. Easy to customize the reports on google sheets.
Is this review helpful?
Yes
No
Profile Picture
Ben Muller
April 9, 2021
Excellent tool. Excellent support. Ultimate connector for getting access to import reports and action API calls from those tough to access places.
Is this review helpful?
Yes
No
1-10 of 100
Search
Clear search
Close search
Google apps
Main menu