Skip to content

Instantly share code, notes, and snippets.

@ShrootBuck
ShrootBuck / yt-watcher.gs
Created January 29, 2026 00:04
A Google Sheets AppScript to send me new YouTube uploads in a specific email folder. Except shorts.
/**************************************
* YT Watcher
* Sheet columns: input | channel_id | channel_title | last_seen_video_id | last_seen_published_at
* Requires: Advanced Service "YouTube Data API v3" enabled in Apps Script.
**************************************/
const CONFIG = {
RECEIVER_EMAIL: "",
TIMEZONE: "America/Phoenix",
MAX_ITEMS_PER_FEED: 10,
EMAIL_SENDER_NAME: "YT Watcher",
@ShrootBuck
ShrootBuck / network-usage-tracker.py
Created January 25, 2026 21:07
macOS daemon that logs home Wi-Fi bandwidth usage to Postgres. Built to prove to my dad I'm not the one killing our 1.2TB data cap.
import json
import os
import subprocess
import time
import psycopg2
TARGET_ROUTER_MAC = ""
STATE_FILE = "/Users/zayd/wifi_tracker/state.json"
DB_CONFIG = ""
@ShrootBuck
ShrootBuck / comcast_watchdog.py
Created January 25, 2026 00:07
A resilient network surveillance script designed to audit residential ISP uptime (Xfinity is lying to me)
import hashlib
import json
import os
import sqlite3
import subprocess
import sys
import time
from datetime import datetime
import psycopg2
import requests
import os
import time
TARGET_URL = "https://nctnabncanovcjnyqiid.supabase.co/storage/v1/object/public/PublicStorage/KILLSHOT.txt"
SHUTDOWN_STRING = "KILLSHOT"
CHECK_INTERVAL = 60 * 5
def check_for_shutdown():
try:
@ShrootBuck
ShrootBuck / physics-lab-stuff.cpp
Created December 16, 2025 22:45
a fast standard deviation + mean calculator for my physics labs
#include <algorithm>
#include <cmath>
#include <cstdio>
#include <iostream>
#include <string>
#include <vector>
using namespace std;
void setIO(string name = "") {
ios_base::sync_with_stdio(false);
65535
1 2
1 3
2 3
1 2
3 1
3 2
1 2
1 3
2 3