Spark Automations · Projects

Todo List —

Drag-to-reorder · double-click to edit · saved to this browser. Pull from Action column to seed.

Executive Summary at a glance

Sortable, filterable, searchable. Click any column header to sort. Click pills to filter. Click row to jump to its tier section.

Status: · Tier:

Client / Initiative ↕	Score ↕	Project ↕	Status ↕	% ↕	Deadline / Next	Action / Owner	Updated ↕

Tier 1 · Client Engagements 4 active

Active revenue / committed work · 3 SA-direct · 1 SA-vendor (Horus, with 3 sub-clients)

Project	Status	% complete	Key deadline	Notes
RUBISCO2 → V2 sand separator · SA-direct	active	~70%	Jun 9 · hotels demo May 31 · Anexo B	V2 design + V1 verified. Alert: drum_v2.py spec mismatch — file encodes V1 dims, V2 is 1100 OD × 4000 mm per bible v3.0 §3. Production scale: ~100 hotels. Media + links Bible: `RUBISCO2/RUBISCO2_Full_Updated_Final_Bible_v3_0.md` — source of truth V1 witness experiment: `Internal/research/v1-witness-experiment/REPORT.md` + `qa/overlay_left.png` Active Drive folder: 18ubCCSLoSz492cHVupwpSUi8VptH-8Vm Internal page: clients/rubisco2.html
Miguel Peraza → Content distribution · SA-direct	live	~60%	tonight 21:30 PdC 2nd alignment	24 clips drafted. OAuth blocking publish. Sculptor, 50-yr trajectory, RWA / criptoescultura. Media + links Prep video v4: Drive Client video: Drive Catch-up video Spark Automations: Drive Prep markdown: `briefs/2026-04-27.md` TMR research folder: `Marketing Team/research/2026-04-17-tmr-coverage/` Internal pages: miguel.html · miguel-deck.html
Arquitectura Financiera Integral → Marianita + Violeta · SA-direct · companion app	proposal drafted	~25%	Pablo review → send to Marianita	SA proposal v2 drafted Apr 28 — friend rate $1,500 USD, solo Pablo (LLM-augmented), 12 work-weeks across Q3 2026, target launch Sep–Oct. PWA + Supabase + Vercel + Belvo. Same DB substrate as Gabriel's $2k quote, plus Belvo + compliance brief + ownership-from-day-1 + 60d post-launch support. Marianita is a friend of Pablo's; equity / partnership conversation runs in parallel (separate doc). v1 retracted — was anchored on a hallucinated $90k figure from the dev PDF. Awaiting Pablo's greenlight on the friend rate before sending. Media + links Internal status: clients/afi.html SA proposal v1: clients/afi-proposal.html (auth'd, share with Marianita on Pablo's "send it") Client portal: clients/afi-portal.html (Marianita-facing) Dev quote (comparison): Drive — Propuesta.pdf · local copy · ($2,000 USD / 10 wks / solo Gabriel Lazo / RN+Expo+Supabase / no Belvo, no compliance) SA proposal v2 PDF: local copy (Chrome headless render of the HTML) Site diagnostic: `Clients/Arquitectura Financiera Integral/diagnostico/2026-04-27-site-review.md` Client charter: `Spark Automations/Clients/Arquitectura Financiera Integral/CLAUDE.md`
Horus Loves Vision → 3 sub-clients · SA-vendor	live	~50%	rolling	Tere (paused since Apr 13 — eye surgery), Paola (sparse), Luis (in deployment, funnel swap parked Apr 22). Pablo's other co. Media + links Tere CRM monitors live: n8n workflows under HLV Luis Kapso: `Clients/Luis Escartín/copy_draft_v1.md` · phone `+1 555-914-6255` Luis funnel swap (parked): `Workflow Creator/flows/funnel-main/Funnel - Main Flow.json` Internal page: clients/horus.html

Tier 2 · Internal Projects / SA Infrastructure 9 items

The substrate that powers everything else

Project	Status	% complete	Last updated	Notes
Spark Automations brand v1 monochrome geometric, Inter	live	100%	Apr 27 · locked	Brand kit finalized. SVGs delivered. Media + links Brand kit: `Brand/BRAND.md` Logo SVGs: `Brand/logo_.svg` (horizontal, stacked, mark, star) Internal page:* brand.html
Internal dashboard spark-automations-internal.vercel.app	live	95%	Apr 27	Multi-page internal site, Vercel auto-deploy from `main`. Media + links Live: spark-automations-internal.vercel.app Repo: `pablogona/spark-automations-internal` Entry: dashboard.html
Public marketing site spark-automations.com	ready-to-deploy	~85%	awaiting Vercel + DNS	Repo built. Awaiting Vercel project import + DNS pointing. Media + links Repo: `pablogona/spark-automations-public` Target domain: spark-automations.com
Unified site + per-user auth internal + public merged	built-not-shipped	~80%	Apr 27 reverted	Built today, NOT deployed. Env vars + auth restoration deferred. Reverted on `main` for now. Media + links Last commit: `9087f06 Revert "Unified site..."` Prior: `dcecedf Unified site: merge public marketing + internal dashboard, gate by per-user auth`
Inbox pattern chat widget → SessionStart hook	live	100%	live	Chat widget → `inbox/` → SessionStart hook reads on next session. Media + links Server: `inbox_server.py` (port 8765) Drop folder: `Internal/inbox/` Memory: `project_inbox_pattern.md`
CAD viewer prototype /clients/cad-viewer	live	70%	witness diff = v0.2	Live page. Witness-mesh diff overlay = v0.2 milestone, not yet shipped. Media + links Live: clients/cad-viewer.html
Recurring brief GitHub Actions + Gemini Flash	gated	~95%	blocked on secret	Workflow shipped. Blocked on `GEMINI_API_KEY` repo secret. Media + links Latest brief: 2026-04-27 · evening Brief log: all briefs
Cloud Run `ask-audio-processor` audio/video/Drive ops	live + drift	~92%	/create-folder undeployed	Live in production. New `/create-folder` endpoint coded but undeployed (gcloud reauth needed). Media + links Service account: `drive-ai-processor@project-64b3c795-f17f-4358-b90.iam` Endpoints: `/ask`, `/upload-to-drive`, `/drive-search`, `/media/sync-drive-folder`, `/media/transcode-drive-video`, `/media/transcribe-gcs`, `/create-sheet`, `/list-drives` Memory: `project_gcp_infra.md`
n8n workflows email sender + monitors	live + queue	~70%	2 unresolved (Apr 21)	Email Sender `3Giq79kdfUODIP5P` live. Tere monitors live. Luis funnel inactive. 2 unresolved send errors (execs 2618, 2619). Media + links Email Sender: workflow `3Giq79kdfUODIP5P` (Email Sender — Claude) Tere monitors: CRM Integrity + Session Watch + Daily Report (Mon-Fri) Luis monitors (inactive): `QSA7w4cJRuL9hEE7`, `jTHbrWdSAlZDWfvA`, `m5QL6PVT73nmbyDE` Luis Kapso: `72QmiPptKxf4AnYS` (Inbound), `rIJ48i1FxplYtKZN` (Send Helper)

Tier 3 · GCT (Theory + Future SA Deliverables) 3 items

Pablo's theory work + the SA-built infra around it

Project	Status	% complete	Owner	Notes
GCT manuscript Geometric Consciousness Theory	ongoing	~70% ?	Pablo	Pablo's domain. %-complete is Pablo's call — placeholder. Lepton masses, gauge group, constants derived; PMNS tension + α residual open. Media + links Main document: `GCT/Geometric Consciousness Theory/Geometric_Consciousness_Theory.md` Internal page: clients/gct.html Memory: `project_gct_context.md`
GCT public website SA-built deliverable	deferred	0%	post-CORE1	SA will build site / domain / infra. Deferred until other commitments clear.
Citation checker / open-problem watcher future agents	speculation	0%	—	Future agents: monitor citations, scan arXiv for related claims. Vision-stage.

Tier 4 · Future / Opportunity / Undocumented 5 items

Surfaced but not yet scoped or scoped but not yet started

Project	Status	% complete	Trigger	Notes
FinTech project (Diego) ? via Diego sub-thread	undocumented	0%	tonight 22:00 PdC	Diego flagged in WhatsApp Apr 27, will discuss tonight. Scope undefined.
Limiting Beliefs app ? Pablo earlier audio	vision	0%	—	Pablo mentioned in earlier audio. No scope yet.
WhatsApp / Kapso Spark for Pablo personal channel for Pablo	provisioning	~30%	Apr 27 in flight	Kapso wizard half-done by Pablo Apr 27.
GCT-based emotional support voice agent long-horizon	deferred	0%	—	Pablo flagged earlier as possibility. Long-horizon.
Twilio Voice integration sketched	deferred	0%	—	Sketched. Not started.

Tier 5 · Skills + Tooling Pablo's leverage layer

Live skills under ~/.claude/skills/ · invoked by Spark across projects

Skill	Status	Triggers	Notes / last evaluated
`cad-twin` 7-step CAD loop	live	"build part X", "make CAD for Y", "PRT-XXXXX", "fab-ready dossier", "native SolidWorks part"	Apr 21 — project-aware via `projects/<name>.md`. RUBISCO2 reference at `PRT-90001_test_plate_small/`, size drift 0.000%.
`cad-from-anything` voice/photo/video → CAD	live	"design this for me in 3D", "model this part from this video", any new PRT-XXXXX without folder	Apr 25 — shipped, 2 acid tests passed. Research-first by design.
`cadquery-sw-review-loop` CadQuery → SW → 6 PNG views	live	"render the drum", "import into SolidWorks", "iterate on the design", "review the model"	Requires SW 2026 running. CadQuery under `py -3.13`.
`mech-render` renders + blueprints from MD	live	"render this part", "generate blueprints for X", "make all views"	Triggers on any markdown part description.
`part-card` component-card PDFs	live	"make component cards", "generate part cards", "BOM with images"	One page = one component. Crops from base render.
`video-from-anything` multi-tool video composer	live	"make me a video about X", "build the GCT video", "compose this explainer"	Apr 27 — upgraded today. Manim + NB Pro + Veo + ffmpeg. Project-aware.
`generate-image` NB Pro + self-critique	live	"make an image of", "render this", "visualize this"	Up to 3 self-critique passes.
`generate-video` Veo 3.1	live	"animate this", "render a video", "interpolate between two frames"	Text-to-video, image-to-video, first+last frame interpolation.
`google-workspace` Drive + Gmail + Sheets ops	live	any Drive link, any Gmail send/reply, sheet ops, "follow up with X"	All Cloud Run endpoints documented in SKILL.md. Email send via n8n webhook.
`n8n-mcp` + 6 sub-skills n8n workflow expert	live	building/debugging n8n workflows, validation errors, expression syntax	Sub-skills: `n8n-code-javascript`, `n8n-code-python`, `n8n-expression-syntax`, `n8n-mcp-tools-expert`, `n8n-node-configuration`, `n8n-validation-expert`, `n8n-workflow-patterns`.
`youtube-researcher` research via YouTube	live	"research X on YouTube", "what do experts say about X"	Triggers proactively on any topic that benefits from video sources.
`ask-video` Gemini video Q&A	live	YouTube/Vimeo/TikTok links, "visual transcription", "ask the video"	Visual + audio transcript.
`ask-audio` built in-house	live	Drive audio/video URLs, "transcribe this voice note"	Cloud Run pipeline. Local file → Gemini direct. Drive URL → Cloud Run, no local bandwidth.
`arch-from-anything` scaffold only	scaffold	"design this house", "build the planos for X", new architectural project	Apr 26 — full MVP build opens after CORE1 ships May 15. Sibling to `cad-from-anything`.

Projects Portfolio