Connect and import data from any API to Google Sheets.
API Importer has a powerful, easy-to-use interface that lets you pull data from any API into your Google Sheets worksheet. Just enter your API key or OAuth2 credentials to connect. API Importer is the API Connector of choice!
*GET, POST, PUT, HEAD, DELETE, PATCH 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
*API() 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)
*Refresh your formulas easily
*Built-in query language for filtering API results via JMESPath
*Free plan lets you save up to 3 commands. Paid features let you save unlimited commands. Run those commands unlimited times.
*Easily connect to Ahrefs API, Github API, Google Analytics API, Google Analytics Management API, Harvest API, Instagram Insights API, LinkedIn Ads API, QuickBooks API, Quora Ads API, Spotify API, Strava API, Vimeo API, and YouTube Analytics API.
*Add your own custom OAuth2 API connections.
🔥 Pro features:
*Save unlmited commands. Run those commands unlimited times.
*Our free plan includes many features that our competitors will charge you for.
📓 Beginner-friendly templates & tutorials:
💬 Fast, friendly support
⭐️ Our Add-on vs Others
We offer the best value: save up to 3 commands on the free plan and unlimited commands on the paid plan. Unlike our competitors, we don't limit the number of times you can run those commands. In addition, we are the only add-on that lets you have JMESPath filtering on the free plan - which means you can extract the content you want.
✅ Use cases
*Import Bitcoin and crypto currency / cryptocurrency, stock prices / stock quotes, economic data, forex / fx / foreign currency / foreign exchange price data
*Connect directly to trackers like CoinMarketCap & Binance
*Track your Facebook page likes and follows and connect to Facebook Ads
*Build your own SEO analysis tool
*Analyze Mailchimp email activity
*Get time and project details from Jira & Asana
*Connect to the Harvest API
*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.
*Tons of other data mashups and data visualizations.
Use this as a replacement for, or in conjunction with, importFromWeb, Supermetrics, SheetGo, Google Analytics, Autocrat and Power Tools. This is the perfect no code tool to help you effortlessly get the data you need in your Sheet.
Here are just a few more of the sources you can import using API Importer: Google Analytics API, Linkedin API, Ahrefs API, Product Hunt API, Facebook API, Doubleclick API, Shopify API, Adform API, Optimizely API, IMDb API, Active Campaign API, Kelly Blue Book API, Github API, Twitter API, Intercom API, Crypto Price API, Harvest API, Adroll API, Xero API, Criteo API, Google My Business API, CRM API, Stripe API, Indeed API, Outbrain API, iTunes API, Sports API, Yahoo API, Surveymonkey API, Youtube API, News API, Tumblr API, Quora API, Esports API, Wordpress API, Reddit API, Pinterest API, Trello API, Google Ads API, Google Search Console API, Searchmetrics API, Asana API, Adobe API, Netflix API, Yandex API, Tiktok API, Hubspot API, Stocks API, Vimeo API, Wikipedia API, Constant Contact API, Spotify API, Mailchimp API, Ziprecruiter API, Semrush API, Government Data API, Weather API, Quickbooks API, Jira API, Taboola API, OpenWeather API, Google Adsense API, Amazon API, Moz API, Instagram API, Spacex API, Salesforce API, Bing API, HR API, Video Game API , Facebook Ads API, Snapchat API, Google Maps API, Paypal API, Google Indexing API or any other JSON API can be imported to Google Sheets with API Importer.
Connect to any type of database: MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, Microsoft Azure, GCS / Google Cloud, AWS / Amazon Web Services and many others. Simply expose your database as an API and connect just as you would any other API.