Data Connector is powerful, yet easy-to-use and lets you pull data from any API into your Google Sheets™ worksheet. Just enter your API key or connect via OAuth2. Data Connector is the API connector of choice!

Data Connector is the ONLY Add-on of it's kind that gives you OAuth2 connections, JMESPath™ and other filters on it's free tier. Other Add-ons make you pay for those features. 

Documentation: https://dataconnector.app/docs/docs/

👇 Features:
*GET, POST, PUT, support
*Connect to OAuth2 (OAuth 2) sources
*Save your api requests for future access
*Reference cells in API requests for dynamic queries
*=RUN() custom function 
*Refresh your formulas easily
*Built-in query language for filtering API results via JMESPath
*Free plan lets you save up to 1 command. Paid plan lets you save unlimited commands. Run your commands unlimited times.
_______________________________________________________________________________________
💬 Fast, friendly support
support@dataconnector.app
_______________________________________________________________________________________

⭐️ Our Add-on vs Others
We offer the best value: save 1 command 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 OAuth2 connections and JMESPath filtering on the free plan - which means you can extract the content you want.

_______________________________________________________________________________________

✅ Use cases
*Import and export Bitcoin and crypto currency / cryptocurrency, stock prices / stock quotes, fantasy football, 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 from Search Console, SEMRush™, SEOMoz™ and DataForSEO™
*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™, 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.
*Here are just a few more of the sources you can import using Data Connector: Google Analytics™ API, Linkedin™ API, Ahrefs™ API, Product Hunt™ API, Facebook™ API, Doubleclick™ API, Shopify™ API, Adform™ API, Rapid 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, Coinbase™, CriptoYa™, Mubi™, Delhivery™, Instagram™ API, Spacex™ API, Adroll™, AdForm™, Adwords™, CRM APIs, WooCommerce™, Etsy™, Salesforce™ API, Bing™ API, API-Sports™, Meta Weather™, Alpha Vantage™, HR API, Video Game™ API , Facebook Ads™ API, Snapchat™ API, TikTok™, Google Maps™ API, Salesforce™, Twitter™, Notion™, Big Query™, Ahrefs™, GA4™, Hubspot™, PipeDrive™, USPTO™, Paypal™ API, Looker Studio™ (previously Google Data Studio™), Airtable™ & Microsoft Excel™, Google Indexing™ API, ROAS™, Yahoo Finance™, ESPN™, DraftKings™, NFL™, NBA™ or any other JSON API can be imported to Google Sheets™ with Data Connector.

Connect to any type of database: MySQL™, BigQuery™, PostgreSQL™, Redshift™, MariaDB™, Oracle™,  SQL Server™,  Microsoft Azure™, Microsoft SQL Server™, MongoDB™, Redis™, 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.