Google Sheets Full SQL Select Custom Function

Hacker News

=gsSQL() - Is a sheets custom function that contains the full functionality of SQL SELECT statements. It is used as a custom function OR can be used from your Google Apps Script directly. It is especially useful to perform Left/Right/Full joins and sub-queries (i.e. SELECT IN) between Sheets and/or ranges. It is also handy and quicker to read/write than the convoluted Google Sheets =QUERY() function. I have written this for myself, but have made it an open source project for anybody to use. Any comments, suggestions, improvements or help to improve would be greatly appreciated.

Visit product View on Hacker NewsNov 3, 2022

Share card

Actual performance

1points

Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →

Product HuntOn track for Day 1 leaderboard · Strong signals: google, apps, open · Missing: mac, agents, macos

76%76% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

TrustMRRFits verified-revenue profile · Strong signals: apps, google · Missing: mobile apps, ios, personal

51%51% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Hacker NewsMay not resonate with HN audience · Strong signals: open source, io · Missing: https docs, excited, just released

41%41% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

Indie HackersIH features products with proven revenue · Missing: supports, reddit linkedin, podcasting

37%37% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive

29%29% predicted probability of success on AppSumo, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

19%19% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

4%4% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Two-way sync between SQL and Google Sheets56%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Two-way sync between SQL and Google Sheets

Hacker News10

Use SQL Across Your Google Sheets, APIs, Airtables, and More57%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Use SQL Across Your Google Sheets, APIs, Airtables, and More

Hacker News1

UseSQL47%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Use SQL across your Google Sheets, APIs, Airtables, and more

Indie Hackers4analytics

Rails Scaffolding in Google Sheets44%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Rails Scaffolding in Google Sheets

Hacker News2

Causal Scenarios for Google Sheets41%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Causal Scenarios for Google Sheets

Hacker News2

Monte Carlo in Google Sheets46%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Monte Carlo in Google Sheets

Hacker News1

SQL4Sheets60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Run real SQL in Google Sheets with zero setup

Product Hunt+5

SpreadAPI – Google Sheets API Without Thirdparties51%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

SpreadAPI – Google Sheets API Without Thirdparties

Hacker News4

A Full-Featured Period Tracker with Google Sheets41%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

A Full-Featured Period Tracker with Google Sheets

Hacker News2

Flex.io53%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Turn any API into a lookup function in Excel / Google Sheets

Indie Hackerscommitment-full-time

Browse all products Analyze your launch