Connect to JSON APIs and other data in Google Sheets™
Listing updated:June 17, 2023
Works with:
59K+
Overview
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.
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
Data Connector - JSON API OAUTH FREE will ask for the permissions shown below. Learn more
Data Connector - JSON API OAUTH FREE will need access to your Google account
This will allow Data Connector - JSON API OAUTH FREE to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Christopher Chiu
March 6, 2024
I tried using it to connect w/ CoinGecko API. Read through all the documentation - not very clear or helpful. Didn't have any examples I could look at. Wasted an hour. Uninstalled it and went back to API Connector. I'm willing to upgrade to paid plan, but your documentation turned me off. Please spend time improving that, thanks.
Is this review helpful?
Yes
No
Profile Picture
Pavel Ch
March 11, 2024
Was using API connector previously, but since lowered their limits I switched to this Data Connector. Excellent extension, does what it says on the tin.
Is this review helpful?
Yes
No
Profile Picture
GohOnLeeds
January 18, 2024
What a fantastic tool! Just what I needed. Gets the job done with no fuss at all. Thoroughly recommended to anyone wanting to connect Google Sheets to APIs!
Is this review helpful?
Yes
No
Profile Picture
Al Patel
February 22, 2024
Been waiting for this for a long time, no longer need 3rd party add ons, thank you for releasing this feature.
Is this review helpful?
Yes
No
Profile Picture
Oscar Saavedra
January 17, 2024
Great and intuitive solution for API integrations!
Is this review helpful?
Yes
No
Profile Picture
Jason Aga
March 13, 2023
This data connection is awesome. I was easily able to connect to our property management system (PMS) and get the data I need. Previously I was exporting, downloading, copy/paste, upload data from Excel to the PMS, with this connection I am easily able to do all of that in one fell swoop! The input categories and customizations made it easy to understand and seamless to manage. Highly recommend for your API needs :)
Is this review helpful?
Yes
No
Profile Picture
Zearaf Tech
February 10, 2023
Data Connector is a fantastic app for managing and organizing data from multiple sources. With this app, you can connect to a wide range of data sources such as databases, spreadsheets, and cloud services, and easily consolidate the data into a single view. One of the standout features of Data Connector is the ability to automate data refreshes, so you can ensure that the data you are working with is always up-to-date. This is especially useful for businesses that rely on real-time data to make informed decisions. Another great feature is the ability to perform data transformations within the app, making it possible to clean, transform and shape your data before loading it into a target system. Overall, I would highly recommend Data Connector to anyone looking for a reliable and efficient way to manage and organize their data. The app has a great range of features, is easy to use, and provides a fast and seamless way to work with data from multiple sources.
Is this review helpful?
Yes
No
Profile Picture
Amenity Applewhite
August 24, 2023
It doesn't open: When I select it from the Extensions menu I get a syntax error: Unexpected non-whitespace character after JSON at position 4
Is this review helpful?
Yes
No
Profile Picture
Camilo Torreblanca
February 17, 2024
Great!
Is this review helpful?
Yes
No
Profile Picture
Carl Cervone
January 5, 2024
Super easy to set up and get going for my use case
Is this review helpful?
Yes
No
1-10 of 61
Search
Clear search
Close search
Google apps
Main menu