Connect to any HTTP API and pull data into google sheets.
Listing updated:May 2, 2023
Works with:
2K+
Overview
Awesome Query has evolved into an extension that focuses on API integration and data extraction/transformation. 

Currently it is in beta and feedback is welcome.

==============================OLD==============================
Awesome Query provides a business friendly query language and a smart editor, with which you can query your data in sheets easily.  

Latest update:
-- Support multi-word header name
--Improve UI and editor
--Specify header row number

Features: 

Query language
-- More friendly syntax compared to google's query language
-- Use header (multiple words) row instead of A, B, C, D
-- Easy date type support
-- Support both ad-hoc run and QUERY function creation
 
Smart editor
-- Syntax highlighting
-- Validate query syntax during editing
-- Auto-completion based on sheets structure

Automation (under consideration/development)
-- Save query
-- Schedule or run query automatically
-- Deliver/publish the query result based on criteria
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
Awesome Query will ask for the permissions shown below. Learn more
Awesome Query will need access to your Google account
This will allow Awesome Query to :
See, edit, create, and delete all your Google Sheets spreadsheets
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
Loading
Search
Clear search
Close search
Google apps
Main menu