App Icon
Data Connector
•  5,020
Overview
Connect to json and other data in Google Sheets
We recognize that your api Keys and other data is extremely sensitive. That's why we have chosen to open source our Add-on. The code can be found here:  https://github.com/brentadamson/dataconnector. If you would like to contribute or would like to suggest an enhancement, please open up an issue there.

Data Connector 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 to connect. Data Connector is the API connector of choice!

👇 Features:
*GET, POST, 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
*RUN() custom function 
*Refresh your formulas easily
*Built-in query language for filtering API results via JMESPath (XPath, JQ, JSONPath and others coming soon!)
*Free plan lets you save up to 1 commands. Paid features let you save unlimited commands. Run those commands unlimited times.
   *To celebrate our relaunch everything is free for now!
*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. 

_______________________________________________________________________________________

🔥 Pro features:
*Save unlmited commands. Run those commands unlimited times.
*Our free plan includes many features that our competitors will charge you for.

_______________________________________________________________________________________
💬 Fast, friendly support
support@dataconnector.app
_______________________________________________________________________________________

⭐️ 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. Most importantly, we are the only Add-on in our category that is open source.
_______________________________________________________________________________________

✅ 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 Data Connector: 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 Data Connector.

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.
Reviews
Language:
Sort by:
Profile Picture
Syifa El
February 2, 2021
Thank
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 8, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
1-2 of 2
Additional information
Data Connector
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu