gsSQL
plaid-transaction-script
gsSQL | plaid-transaction-script | |
---|---|---|
5 | 1 | |
16 | 30 | |
- | - | |
8.3 | 0.0 | |
20 days ago | about 1 year ago | |
JavaScript | JavaScript | |
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.
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
plaid-transaction-script
-
Plaid Google Sheets integration
Found two great scripts (thanks u/phoenixy1) on Github (thisisnotawill & lpg0) following the setup should be easy.
What are some alternatives?
sqliterally - Lightweight SQL query builder
bank-account-to-sheets - Google Apps Scripts to automatically import bank account transactions into Google Sheets via Plaid.
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
plaid-to-gsheets - Automate a personal finance dashboard using the Plaid API, Google Sheets, and Data Studio. Build transformation rules to categorize everything to your liking. Easily add data from non-plaid sources. This system takes a bit of work to set up, but it's worth it for anyone who is picky about how they want to track their finances.
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.
BGG-Best-Games-for-Player-Count - a script for google sheets to import your owned games from Board Game Geek API and sort them by how good they play for a given Player Count
extract-gsheet - Quickly extract JSON data from a public Google Sheet without any API keys.
Amex-Offers-Helper - A tiny script to register all availiable Amex credit card offers
gcp-video-intelligence - The GCP Video Intelligence function allows you to enable powerful content discovery and analysis in your videos.
how-to-apply-formatting-to-a-cell-range-in-the-react-spreadsheet - A quick-start project that shows how to apply formats to a cell range in the Syncfusion React Spreadsheet component. This project demonstrates how to format numbers in cell range as currency, percentages, decimals, and dates. This project also contains code to apply cell formatting options like font size, font family, font color, and fill color and conditional formats with preset colors, data bars, color scales, and icons scales.
react-awesome-query-builder - User-friendly query builder for React