Connect and import data from APIs to Google Sheets.
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:
*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)
*Log timestamps and request URLs to your output sheet
*Import Curl commands and preset request files
*8 daily 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
*Preset OAuth 2.0 integrations for the following APIs: Facebook Ads, Github, Google Analytics, Google Analytics Management, Harvest, Instagram Insights, LinkedIn Ads, QuickBooks, Quora Ads, Spotify, Strava, Vimeo, Xero, YouTube Analytics, and YouTube Data.
*Add your own custom OAuth2 API connections.
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. 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.
📓 Beginner-friendly templates & tutorials:
💬 Fast, friendly support
🧑🤝🧑 User forum
✅ 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.