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 supportsupport@dataconnector.app_______________________________________________________________________________________⭐️ Our Add-on vs OthersWe 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, stock quotes, economic data, forex data*Import and manage data from Facebook, Mailchimp, Jira, Asana, Shopify and more*Create tons of other cross-platform reports, visualizations, and data mash-ups for marketing, analytics, and no-code projects.*Import data from virtually any JSON API.
FAQs
What is the best free API connector for Google Sheets? ›
Data Connector - JSON API OAUTH FREE - Google Workspace Marketplace. 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!
Can I get Google API for free? ›Stay organized with collections Save and categorize content based on your preferences. All use of Google Search Console API is free of charge. However, it is subject to usage limits.
Do I need to pay for Google Sheets API? ›All use of the Google Sheets API is available at no additional cost.
Is the API connector free? ›Dimensions Privacy policy / terms of use. Use of the API Connector is provided for free and subject to the Dimensions terms of use.
Can you pull API data into Google Sheets? ›Connecting API to Google Sheets allows you to automate data flow from your app or source and forget about having to manually export/import the data you need. For this, you only need to write a few lines of code and enjoy the automation.
How do I import JSON into Google Sheets? ›- Copy the ImportJSON script from a GitHub repository such as paulgambill's: 'https://gist.github.com/paulgambill/cacd19da95a1421d3164'.
- Replace the default code in the Apps Script editor with the copied script and save the project.
The Google Sheets API is a RESTful interface that lets you read and modify a spreadsheet's data. The most common uses of this API include the following tasks: Create spreadsheets. Read and write spreadsheet cell values.
Is API connector free? ›Dimensions Privacy policy / terms of use. Use of the API Connector is provided for free and subject to the Dimensions terms of use.
Can you use Google Drive API for free? ›All use of the Google Drive API is available at no additional cost. Exceeding the quota request limits doesn't incur extra charges and your account is not billed.
Is Google Places API free alternative? ›OpenStreetMap
OpenStreetMap is a popular free alternative to Google Places API. It's built and maintained by a community of cartographers, humanitarians, software engineers, and others contributing information about points of interest all over the world.