Connect and import data from any API to Google Sheets.
API Connector has a powerful, easy-to-use interface that lets you pull data from any API into your Google Sheets worksheet. Just enter your URL and API key to connect.
*GET, POST, and PUT support
*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
*IMPORTAPI() custom function
*Four built-in JSON-to-Sheets converter algorithms for handling nested JSON data
*Works with all major data formats (JSON, XML, and CSV)
*Library of beginner-friendly tutorials at https://mixedanalytics.com/knowledge-base/
*Fast, friendly support to get you up and running!
*Schedule API pulls to refresh automatically
*Set trigger execution order
*Automatically handle pagination
*Built-in query language for filtering API results
*One-click OAuth 2.0 integrations for the Ahrefs API, Github API, Google Analytics API, Harvest API, Instagram Insights API, LinkedIn Ads API, QuickBooks API, Quora Ads API, Vimeo API, and YouTube Analytics API.
*Add your own custom OAuth2 API connections.
When you install this add-on, you will automatically enter a 7-day free trial that activates all features. After 7 days, you can choose to upgrade to a paid plan or continue using the free features. The free version of this add-on enables up to 8 daily API requests, while the pro versions allow more requests, scheduling, and advanced features for power users.
Use this plugin to:
*Import Bitcoin and crypto currency price data
*Connect directly to trackers like CoinMarketCap & Binance
*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
*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 Zapier and Supermetrics.This is a totally flexible add-on that connects to almost any platform, so you can build what you want.