extract-gsheet
gsSQL
extract-gsheet | gsSQL | |
---|---|---|
1 | 5 | |
2 | 17 | |
- | - | |
4.2 | 8.3 | |
4 months ago | 24 days ago | |
Nunjucks | JavaScript | |
MIT License | GNU 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.
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.
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
What are some alternatives?
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
sqliterally - Lightweight SQL query builder
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.
tabletop - Tabletop.js gives spreadsheets legs
plaid-transaction-script - Automate bank transaction data using the Plaid API into Google Sheets
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).