gsSQL
extract-gsheet
gsSQL | extract-gsheet | |
---|---|---|
5 | 1 | |
16 | 2 | |
- | - | |
8.3 | 4.2 | |
20 days ago | 4 months ago | |
JavaScript | Nunjucks | |
GNU General Public License v3.0 only | MIT License |
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
extract-gsheet
-
Extract Data from Google Sheets
If you have questions, drop them in the comments here, or let me know on GitHub. I hope you find this useful.
What are some alternatives?
sqliterally - Lightweight SQL query builder
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
qsheets - Questrade to Google Sheets bridge
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.
plaid-transaction-script - Automate bank transaction data using the Plaid API into Google Sheets
tabletop - Tabletop.js gives spreadsheets legs
gcp-video-intelligence - The GCP Video Intelligence function allows you to enable powerful content discovery and analysis in your videos.
react-awesome-query-builder - User-friendly query builder for React
auto-youtube-subscription-playlist-2 - Script automatically adds videos to playlists from Youtube channels and/or subscriptions (Youtube Collections alternative).