Connect APIs to Google Sheets.
Thousands of sites provide access to their platforms via an API. The API Connector add-on has an intuitive, easy-to-use interface that lets you get data from these APIs into your Google Sheets worksheet. No coding required; just enter your URL and API key.
*IMPORTAPI() custom function
*GET and POST 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
*Choose how to display nested JSON data with a built-in JSON-to-Sheets converter
*Schedule API pulls to refresh automatically on an hourly, daily, weekly, or monthly basis (paid feature)
*Automatically handle pagination (paid feature)
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 paid versions allow many 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 employee time and project details from Harvest & Asana
*List out 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 Cryptofinance, Zapier, and Supermetrics.This is a totally flexible add-on that connects to almost any platform, so you can build what you want!