gsSQL
auto-youtube-subscription-playlist-2
| gsSQL | auto-youtube-subscription-playlist-2 | |
|---|---|---|
| 5 | 6 | |
| 16 | 247 | |
| - | - | |
| 8.3 | 4.7 | |
| 20 days ago | 9 days ago | |
| JavaScript | JavaScript | |
| 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
auto-youtube-subscription-playlist-2
-
Yeah, a lot more businesses have gotten greedy and much more sanitised.
For subscriptions, which constantly break anyway, use the "YouTube subscriptions playlist" spreadsheet macro. It still occasionally breaks, but rarer than YouTube's subscriptions and at least you get notified with a precise error message. I'm also planning to write a script that periodically checks the output playlist of that and then downloads the new videos. But all of that once I have some more spare time, so probably not this year.
-
FreeTube – The Private YouTube Client
videodeck for youtube is an alright interface
i ended up using this script that adds new videos into predefined playlists
https://www.google.com/url?q=https://github.com/Elijas/auto-...
this is one feature i wish more 3rd party clients had, instead of just sorting channels into categories, only do new videos in playlists which is easier to manage.
- 3 accounts so far have been deleted for Spams, scams or commercially deceptive content.
-
Vanced Has Been Discontinued
At least for videos I use google spread sheet script to manage a bunch subscriptions into different private playlists accessible via sharelinks in Newpipe with psonsorblock. Allows me to keep things in sync with youtube account on other devices.
https://github.com/Elijas/auto-youtube-subscription-playlist...
Music I just use the default App and pay for the subscription.
-
Vanced: youtube adblocker for android
https://github.com/Elijas/auto-youtube-subscription-playlist...
I use google spread sheet script to manage a bunch subscriptions into different private playlists accessible via sharelinks in Newpipe. Allows me to keep things in sync with youtube account on other devices.
-
Looking for a script\addon for Chrome\Brave that can remove watched videos from YouTube playlists.
Here you go: https://github.com/Elijas/auto-youtube-subscription-playlist-2/blob/master/removeVidsFromPlaylist.md
What are some alternatives?
sqliterally - Lightweight SQL query builder
NewPipe - A libre lightweight streaming front-end for Android.
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
SkyTube - Copylefted libre / open source YouTube player for Android
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.
auto-youtube-subscription-playlist - Script automatically compiles a playlist out of youtube subscription notifications in a gmail label (Youtube Collections alternative)
plaid-transaction-script - Automate bank transaction data using the Plaid API into Google Sheets
FreeTubeAndroid - A soft fork of FreeTube which brings it to Android (formerly FreeTubeCordova)
extract-gsheet - Quickly extract JSON data from a public Google Sheet without any API keys.
youtube-playlist-duration - A react app on finding the total duration of all videos in a YouTube Playlist
gcp-video-intelligence - The GCP Video Intelligence function allows you to enable powerful content discovery and analysis in your videos.
youtube-playlist-search - A Chrome Extension to search Youtube Playlists for Videos