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. No coding required; just enter your URL and API key.
*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
*Three 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
*Schedule API pulls to refresh automatically
*Automatically handle pagination
*Built-in query language for filtering API results
*OAuth 2.0 integrations for Github, Harvest, QuickBooks, Quora Ads, and Vimeo (more coming soon)
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.