gsSQL
SheetsIO
gsSQL | SheetsIO | |
---|---|---|
5 | 1 | |
16 | 20 | |
- | - | |
8.3 | 3.9 | |
20 days ago | 2 months ago | |
JavaScript | Java | |
GNU General Public License v3.0 only | GNU Lesser General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
gsSQL
-
What's the formula for this?
The code is at: https://github.com/demmings/gsSQL/blob/main/dist/gssql.js
-
Need Help
You would need the custom function added to your Apps Script. The source code is here: https://github.com/demmings/gsSQL/blob/main/dist/gssql.js
- Show HN: Google Sheets Full SQL Select Custom Function
- Google App Script Project and Code Coverage on GITHUB
-
Combining two QUERY tables with common column
gsSQL on GITHUB
SheetsIO
-
OBS scoreboard for my students
SheetsIO, https://github.com/GrandyB/SheetsIO, uses a Google Sheet to write files on your computer which you can then read using OBS text or image sources. This does not require any programming knowledge outside of writing a JSON config file (to tell it what cell data to write to what file) which isn't that hard. There's an introduction video on the page that shows how to get started.
What are some alternatives?
sqliterally - Lightweight SQL query builder
riot - 🧨 Get data in & out of Redis with RIOT
cachefinance - A custom function and trigger to supplement GOOGLEFINANCE so data is always available and unsupported stocks can get price/name/yield data. As you can guess from the name, data is cached so when '#N/A' appears it does not mess up your asset history logging/graphing.
lrkFM - Awesome, (ad) free, open source file manager for Android
plaid-transaction-script - Automate bank transaction data using the Plaid API into Google Sheets
turbo-editor - Simple and powerful File Editor for Android. All is licensed under the GPLv3 license.
extract-gsheet - Quickly extract JSON data from a public Google Sheet without any API keys.
Google-Images-Search - [PYTHON] Search for image using Google Custom Search API and resize & crop afterwards
gcp-video-intelligence - The GCP Video Intelligence function allows you to enable powerful content discovery and analysis in your videos.
obs-websocket-java - A java library for https://github.com/obsproject/obs-websocket
react-awesome-query-builder - User-friendly query builder for React
kroki - Creates diagrams from textual descriptions!