Project Name	Description	Link	Docs
gsSQL	Query Google Sheet data using standard SQL SELECT syntax	gsSQL Notes	JSDoc
cachefinance	Google Sheet custom function and/or event trigger for enhanced stock/etf data lookup	cachefinance Notes
Select 2 Query	Convert SQL Select statement to Google Sheets QUERY	Select2Query

Latest Articles

• Using gsSQL Library February 15, 2024
• How to Find Duplicates in Google Sheets [using gsSQL custom function] February 15, 2024
• Google Sheets Query function: The Most Powerful Function in Google Sheets February 12, 2024
• Generate Google Sheets QUERY from Standard SQL April 18, 2023
• Using a calculation to evaluate JOIN condition. April 1, 2023
• Custom Function Triggered on Data Changes March 8, 2023
• GROUP BY in gsSQL February 27, 2023
• Bind Variables in gsSQL January 21, 2023
• Select where EXISTS using correlated Sub Query December 28, 2022
• Correlated Sub Query December 23, 2022
• Theme Update - jekyll-theme-leap-day December 22, 2022
• Welcome to First Post! December 18, 2022