SSS-00 · SUB-WORKFLOW
Universal Error Handler
Called by all other SSS workflows on any node failure. Logs error to Supabase and fires a Telegram alert with full diagnostic context.
Auntie: Systems Auntie
Trigger: Webhook + Manual test
Nodes: 6
🔗
01 · TRIGGER
Error Intake Webhook
Webhook · POST
Path: /sss-error-handler
Body: workflow_name, node_name, error_message, error_code, execution_id
→ Called by all 12 SSS workflows on failure
⚙️
02 · PROCESS
Normalize Error Data
Set Fields
Extracts error fields from body with safe fallbacks. Adds error_at timestamp. Handles both webhook + manual trigger inputs.
→ workflow_name, node_name, error_message, error_code, error_at
🗄️
03 · STORAGE
Log Error to Supabase
Supabase · INSERT
Table: sss_error_log
Logs all 6 fields + resolved=false flag for manual clearance.
→ Persistent searchable error record
📱
04 · NOTIFY
Alert Jerry via Telegram
Telegram · sendMessage
Sends formatted error alert: workflow, failed node, message, code, timestamp. Operator receives within seconds of failure.
→ Real-time failure notification
Node types
Trigger / Webhook
Process / Set Fields
Database / Storage
Notification
AI Agent (Auntie)
Scheduler / Router
Data flow
SSS-01 · CORE
Episode Intake & Transcription
Webhook receives recording → audio downloaded → Whisper transcribes → Content Auntie generates full episode brief → saves to Airtable + creates Notion approval page.
Auntie: Content Auntie
Trigger: POST webhook
Nodes: 10
🔗
01 · TRIGGER
Receive Episode Upload
Webhook · POST
Path: /sss-episode-upload
Payload: episode_title, audio_url, themes, platform_targets
⚙️
02 · PROCESS
Normalize Episode Payload
Set Fields
Extracts all fields with safe fallbacks. Adds submitted_at timestamp. Handles both webhook body wrapper and direct fields.
⬇️
03 · FETCH
Download Audio File
HTTP Request · GET
URL: {{ audio_url }}
Response: binary file for Whisper
🎙️
04 · TRANSCRIBE
Whisper Transcribe Audio
OpenAI · Whisper
Model: whisper-1
Language: en
Output: full text transcript
🤖
05 · AI AGENT
Content Auntie — Episode Brief
Claude · Sonnet
Voice-matched brief generation from transcript. Produces: 3 title options, description, SEO tags, chapters, 3 clip timestamps, LinkedIn + Substack + TikTok + email drafts.
→ Structured JSON · 18 fields
→ AIRTABLE
📊
06 · STORAGE
Save Episode Brief
Airtable · CREATE
Table: SSS Episodes
Status: Pending Approval
Saves all 11 brief fields
→ NOTION
📝
07 · OUTPUT
Create Notion Approval Page
Notion · CREATE PAGE
Parent: SSS Command Center
Formatted review page with title options, clips, LinkedIn + email drafts
Node types
Trigger / Webhook
Process / Fetch / Transcribe
AI Agent (Content Auntie)
Airtable Storage
Notion Output
SSS-02 · CORE
Auntie Router & Repurposing Engine
Approval triggers Content Auntie to generate 12 platform-specific pieces from one approved episode. All drafts saved to Airtable. Telegram notification sent.
Auntie: Content Auntie
Trigger: Approval webhook
Nodes: 8
✅
01 · TRIGGER
Approval Webhook
Webhook · POST
Path: /sss-content-approved
Payload: record_id, approved_title, transcript, themes
⚙️
02 · PROCESS
Normalize Approval Data
Set Fields
Extracts: record_id, episode_title, approved_title, transcript, themes. Adds approved_at timestamp.
🤖
03 · AI AGENT
Content Auntie — Repurpose All Platforms
Claude · Sonnet
12 platform outputs in one call: YouTube title + description + tags, LinkedIn 400w post, Substack 600w newsletter, 3× TikTok captions, Facebook post, email subject + body, community post.
→ Structured JSON · 12 fields
📊
04 · STORAGE
Save Repurposed Content
Airtable · UPSERT
Table: SSS Episodes
Status update: Approved — Scheduled
Saves all 12 platform drafts to episode record
📱
05 · NOTIFY
Notify — Content Ready
Telegram · sendMessage
Alerts Jerry: episode name, status, instruction to trigger SSS-03 scheduling.
Platform outputs generated
🎬 YouTube title + description + tags
💼 LinkedIn 400w post
📧 Substack 600w newsletter
📱 TikTok ×3 captions
👥 Facebook community post
✉️ Email subject + body
🔒 Paid community post
Node types
Trigger / Process
Content Auntie (Claude)
Airtable Storage
Telegram Notification
SSS-03 · CORE
Monday Morning Brief
Fires every Sunday 8 PM. Pulls Idea Vault top ideas + recent episode performance. Strategy Auntie synthesizes into a single Monday brief. Delivered via Gmail + saved to Notion.
Auntie: Strategy Auntie
Trigger: Sunday 8:00 PM schedule
Nodes: 7
⏰
01 · SCHEDULE
Sunday Night Schedule
Schedule Trigger
Cadence: Weekly
Day: Sunday (0)
Time: 20:00
PULL A
💡
02A · FETCH
Fetch Top Idea Vault Ideas
Airtable · SEARCH
Table: SSS Idea Vault
Filter: Status=New, Priority!=empty
Limit: 10, sorted by Priority desc
PULL B
📊
02B · FETCH
Fetch Recent Episode Performance
Airtable · SEARCH
Table: SSS Episodes
Filter: Status=Published
Limit: 5, most recent first · executeOnce: true
🔀
03 · AGGREGATE
Aggregate Ideas
Aggregate Node
Collapses 10 idea records into a single JSON array passed to Strategy Auntie.
🧠
04 · AI AGENT
Strategy Auntie — Monday Brief
Claude · Sonnet
Synthesizes ideas + performance into 8-field brief: top recommendation + reason, backup idea, what worked last week, audience signal, one action today, queue status.
→ Structured JSON · 8 fields
→ EMAIL
✉️
05A · DELIVER
Send Monday Brief Email
Gmail · SEND
To: Soul Said So
HTML-formatted brief. Arrives before Monday morning.
→ NOTION
📝
05B · ARCHIVE
Save Brief to Notion
Notion · CREATE PAGE
Parent: SSS Command Center
Logged in Command Center for reference.
Node types
Schedule Trigger
Airtable Data Fetch
Aggregate / Process
Strategy Auntie (Claude)
Gmail Delivery
Notion Archive
SSS-04 · CORE
Idea Vault Capture
Any Telegram message or voice note → Research Auntie classifies into a structured Idea Vault entry → saved to Airtable → confirmed back on Telegram instantly.
Auntie: Research Auntie
Trigger: Telegram message
Nodes: 8
📱
01 · TRIGGER
Telegram Idea Capture
Telegram Trigger
Fires on any message from Soul Said So's Telegram. Text or voice note. No commands required — just send the idea.
⚙️
02 · PROCESS
Extract Message Content
Set Fields
Extracts: chat_id, message_text (or caption for voice), has_voice flag, captured_at timestamp.
🔍
03 · AI AGENT
Research Auntie — Tag & Categorize
Claude · Sonnet
Transforms raw idea into structured entry: working title, core theme, emotional angle, audience pain point, format suggestion, priority score (High/Medium/Low), 5 searchable tags.
→ Structured JSON · 7 fields
💡
04 · STORAGE
Save to Idea Vault
Airtable · CREATE
Table: SSS Idea Vault
Status: New · Saves all 10 fields including raw capture + structured analysis.
✅
05 · CONFIRM
Confirm Idea Captured
Telegram · sendMessage
Replies to Soul Said So: idea title, theme, priority. Closes the loop instantly. Creator knows it was saved.
Node types
Telegram Trigger / Process
Research Auntie (Claude)
Airtable Idea Vault
Telegram Confirmation
SSS-05 · CORE
Audience Intelligence Collector
Every Saturday 6 PM: fetches YouTube comments → Research Auntie clusters themes → saves intelligence to Supabase → content opportunity auto-added to Idea Vault.
Auntie: Research Auntie
Trigger: Saturday 6:00 PM schedule
Nodes: 10
⏰
01 · SCHEDULE
Weekly Intelligence Schedule
Schedule Trigger
Day: Saturday (6)
Time: 18:00
Cadence: Weekly
🎬
02 · FETCH
Fetch Recent YouTube Videos
YouTube · getAll
Channel: Soul Said So
Published after: 7 days ago
Limit: 5 most recent
💬
03 · FETCH
Fetch YouTube Comments
HTTP Request · GET
API: YouTube commentThreads
Per video: 50 comments, relevance-ordered
🔢
04 · TRANSFORM
Extract Comment Text
Code · JavaScript
Flattens all comment threads. Filters short/empty comments. Returns top 30 by like count with text + likes.
→ Array of {text, likes}
🔍
05 · AI AGENT
Research Auntie — Audience Intelligence
Claude · Sonnet
Clusters 30 comments into: dominant theme, secondary theme, top question, emotional tone, audience struggle, content opportunity, standout comment quote.
→ Structured JSON · 7 fields
→ SUPABASE
🗄️
06A · STORE
Save to Supabase
Supabase · INSERT
Table: sss_audience_intelligence
Builds searchable intelligence database over time.
→ VAULT
💡
06B · STORE
Add to Idea Vault
Airtable · CREATE
Table: SSS Idea Vault
Content opportunity auto-added as Priority: High entry.
Node types
Schedule Trigger
YouTube + HTTP Fetch / Code
Research Auntie (Claude)
Supabase + Airtable Storage
SSS-06 · CORE
Weekly Performance Analytics Digest
Every Saturday 9 AM: pulls 7-day YouTube Analytics → Strategy Auntie interprets numbers in plain language → saves to Supabase + creates Notion analytics entry.
Auntie: Strategy Auntie
Trigger: Saturday 9:00 AM schedule
Nodes: 9
⏰
01 · SCHEDULE
Saturday Analytics Schedule
Schedule Trigger
Day: Saturday (6)
Time: 09:00
Cadence: Weekly
PULL A
📈
02A · FETCH
Fetch YouTube Analytics
HTTP Request · GET
API: YouTube Analytics v2
Metrics: views, watchTime, avgDuration, subsGained, subsLost, likes, comments
Range: 7 days
PULL B
🎬
02B · FETCH
Fetch Top Episode This Week
Airtable · SEARCH
Table: SSS Episodes
Most recently published · executeOnce: true
🔢
03 · TRANSFORM
Summarize Analytics Data
Code · JavaScript
Aggregates daily rows into weekly totals: total views, watch minutes, avg duration, net subs, likes, comments. Calculates engagement rate.
→ 9 summarized metrics
🧠
04 · AI AGENT
Strategy Auntie — Analytics
Claude · Sonnet
Interprets numbers as plain-language advice: performance summary, standout metric, growth signal, concern if any, next week recommendation, channel health grade.
→ Structured JSON · 6 fields
→ SUPABASE
🗄️
05A · STORE
Save to Supabase
Supabase · INSERT
Table: sss_performance
Builds 52-week rolling analytics history.
→ NOTION
📊
05B · OUTPUT
Create Notion Analytics Entry
Notion · CREATE PAGE
Parent: SSS Analytics Dashboard
Human-readable weekly summary with key numbers + Strategy Auntie recommendation.
Node types
Schedule Trigger
YouTube Analytics + Code
Airtable + Supabase
Strategy Auntie (Claude)
Notion Dashboard
SSS-07 · PRO
Sponsorship Pipeline & Brand Deal Tracker
Two triggers: (1) Add a target brand → Brand Deal Auntie writes personalized pitch → saved to Airtable. (2) Monday morning → surfaces follow-ups due → Telegram alert.
Auntie: Brand Deal Auntie
Trigger: Webhook + Monday schedule
Nodes: 11
Trigger A — New Brand
🔗
01 · TRIGGER
Add Target Brand Webhook
Webhook · POST
Path: /sss-add-brand
Payload: brand_name, brand_website, category, contact_email, notes
⚙️
02 · PROCESS
Normalize Brand Data
Set Fields
Extracts all fields. Adds added_at timestamp. Calculates follow_up_date as +7 days.
✍️
03 · AI AGENT
Brand Deal Auntie — Write Pitch
Claude · Sonnet
Generates: personalized 250w pitch email, alignment statement, proposed deliverables, realistic rate range. Opens with specific brand observation. No rate card in first email.
→ Structured JSON · 5 fields
📋
04 · STORAGE
Save Brand Deal to Airtable
Airtable · CREATE
Table: SSS Brand Deals
Status: Pitch Ready
Saves all pitch fields + follow_up_date
📱
05 · NOTIFY
Notify — Pitch Ready
Telegram · sendMessage
Alerts Jerry: brand name, email subject, rate range. Instruction to review in Airtable before sending.
Trigger B — Weekly Follow-Up Check
⏰
06 · SCHEDULE
Weekly Follow-Up Check
Schedule Trigger
Day: Monday (1)
Time: 09:00
Cadence: Weekly
🔎
07 · FETCH
Fetch Follow-Ups Due
Airtable · SEARCH
Filter: Status != Closed AND Status != Declined
Returns all open deals for follow-up review.
📱
08 · ALERT
Alert — Follow-Ups Due
Telegram · sendMessage
One alert per open deal: brand name, status, contact email, due date. Jerry updates Airtable after following up.
Node types
Webhook Trigger / Process
Schedule Trigger
Brand Deal Auntie (Claude)
Airtable Brand Deals
Telegram Notifications
SSS-08 · PRO
Affiliate Link Tracker & Performance Monitor
Webhook logs new affiliate links to Airtable. Monthly on the 1st, Product Auntie reviews all affiliate performance and sends an actionable digest via email.
Auntie: Product Auntie
Trigger: Webhook + Monthly 1st
Nodes: 10
Trigger A — Log New Affiliate Link
🔗
01 · TRIGGER
Add Affiliate Link Webhook
Webhook · POST
Path: /sss-add-affiliate
Payload: product_name, affiliate_url, platform, commission_rate, episode_id, placed_in
⚙️
02 · PROCESS
Normalize Affiliate Data
Set Fields
Extracts all fields, adds added_at. Initializes Clicks=0, Conversions=0, Revenue=0.
📊
03 · STORE
Save Affiliate to Airtable
Airtable · CREATE
Table: SSS Affiliates
Status: Active · Initialized with zero metrics.
✅
04 · CONFIRM
Confirm Affiliate Logged
Telegram · sendMessage
Confirms: product, platform, commission rate, placement locations.
Trigger B — Monthly Performance Review
⏰
05 · SCHEDULE
Monthly Affiliate Review
Schedule Trigger
Day of month: 1st
Time: 09:00
🔎
06 · FETCH
Fetch All Active Affiliates
Airtable · SEARCH
Filter: Status = Active
Returns all active affiliate records with performance metrics.
📦
07 · AI AGENT
Product Auntie — Affiliate Review
Claude · Sonnet
Diagnoses performance: top converters (promote more), click-but-no-convert (wrong fit or placement), zero activity (drop). Gives one revenue optimization recommendation.
→ 200-word plain-language digest
✉️
08 · DELIVER
Send Monthly Affiliate Digest
Gmail · SEND
To: Jerry
HTML email with full Product Auntie review.
Node types
Webhook / Process
Monthly Schedule
Airtable Affiliates
Product Auntie (Claude)
Telegram + Gmail
SSS-09 · PRO
Product Launch Runway
Fires once per product when a launch date is set. Product Auntie builds a 4-week content runway: episode topics, email subjects, social angles per week. Saved to Airtable + Notion launch plan.
Auntie: Product Auntie
Trigger: POST webhook (once per launch)
Nodes: 8
🚀
01 · TRIGGER
Product Launch Trigger
Webhook · POST
Path: /sss-launch-runway
Payload: product_name, type, launch_date, price, audience_problem, launch_url, email_list_size
⚙️
02 · PROCESS
Normalize Launch Data
Set Fields
Extracts all 7 launch fields with safe fallbacks.
📦
03 · AI AGENT
Product Auntie — Launch Runway
Claude · Sonnet
Builds 4-week escalation runway: Week 1 (awareness), Week 2 (education), Week 3 (anticipation), Week 4 (launch). Each week: episode topic, email subject, social angle. Plus launch day copy + post-launch follow-up.
→ Structured JSON · 14 fields
→ AIRTABLE
📋
04A · STORE
Save Runway to Airtable
Airtable · CREATE
Table: SSS Content Queue
Status: Runway Ready
All 4 weeks saved as structured fields.
→ NOTION
📝
04B · OUTPUT
Create Launch Plan in Notion
Notion · CREATE PAGE
Full 4-week plan with key message, all episode + email topics, launch day copy, and post-launch follow-up.
4-Week Runway Structure
WEEK 1
Awareness
Address the problem. No product mention.
WEEK 2
Education
Deeper exploration. Hint something is coming.
WEEK 3
Anticipation
Tease the solution. Build desire.
WEEK 4
Launch
Launch day email + social. Post-launch follow-up.
Node types
Webhook Trigger / Process
Product Auntie (Claude)
Airtable Content Queue
Notion Launch Plan
SSS-10 · PRO
Trend & Competitor Intelligence
Every Saturday 2 PM: fetches recent videos from 3 competitor channels → Research Auntie identifies trends, gaps, and Soul Said So's unique angle → saves to Supabase + Idea Vault.
Auntie: Research Auntie
Trigger: Saturday 2:00 PM schedule
Nodes: 11
⏰
01 · SCHEDULE
Weekly Trend Schedule
Schedule Trigger
Day: Saturday (6)
Time: 14:00
C1
🎬
02A
Competitor 1 Videos
YouTube · getAll
5 most recent videos, last 14 days
C2
🎬
02B
Competitor 2 Videos
YouTube · getAll
5 most recent videos, last 14 days
C3
🎬
02C
Competitor 3 Videos
YouTube · getAll
5 most recent videos, last 14 days
🔢
03 · AGGREGATE
Aggregate Competitor Titles
Code · JavaScript
Merges all titles + channel names + publish dates. Filters empty results. Returns up to 15 titles for analysis.
→ Array of {title, channel, published}
🔍
04 · AI AGENT
Research Auntie — Trend Intelligence
Claude · Sonnet
Identifies: dominant trend, trending formats, gap opportunity competitors aren't filling, Soul Said So's unique angle into the trend, topics to avoid, one standout title recommendation.
→ Structured JSON · 6 fields
→ SUPABASE
🗄️
05A · STORE
Save to Supabase
Supabase · INSERT
Table: sss_trend_intelligence
Builds searchable competitive history.
→ VAULT
💡
05B · STORE
Add Standout Title to Vault
Airtable · CREATE
Table: SSS Idea Vault
Priority: High
Tagged: trend-signal, competitor-gap
Node types
Schedule Trigger
YouTube Parallel Fetch / Code Aggregate
Research Auntie (Claude)
Supabase + Airtable
SSS-11 · PRO
New Subscriber Onboarding Sequence
New subscriber webhook → Content Auntie writes personalized 5-email sequence → Email 1 sent immediately → remaining 4 emails saved to Airtable for scheduled delivery.
Auntie: Content Auntie
Trigger: New subscriber webhook
Nodes: 8
👋
01 · TRIGGER
New Subscriber Webhook
Webhook · POST
Path: /sss-new-subscriber
Payload: subscriber_email, subscriber_name, subscribed_via, referral_episode
Integrate with Beehiiv / ConvertKit
⚙️
02 · PROCESS
Normalize Subscriber Data
Set Fields
Extracts: email, name (fallback: "friend"), subscribed_via, referral_episode. Adds subscribed_at.
✍️
03 · AI AGENT
Content Auntie — Onboarding Sequence
Claude · Sonnet
Writes 5 personalized emails using subscriber name + referral source. Day 0: welcome. Day 2: origin story. Day 4: quick win. Day 7: community. Day 10: personal invitation.
→ Structured JSON · 10 fields (5 subjects + 5 bodies)
→ EMAIL NOW
✉️
04A · SEND
Send Welcome Email Day 0
Gmail · SEND
To: subscriber_email
Sent immediately. Uses subscriber's name in greeting. Sender: Soul Said So.
→ SAVE QUEUE
📋
04B · STORE
Save Subscriber + Emails
Airtable · CREATE
Table: SSS Subscribers
Saves emails 2–5 subjects + bodies for scheduled sending on days 2, 4, 7, 10.
5-Email Sequence
Day 0
Welcome + best episode
Day 2
Creator origin story
Day 4
Quick-win tool
Day 7
Community intro
Day 10
Personal invitation
Node types
Webhook / Process
Content Auntie (Claude)
Gmail immediate send
Airtable subscriber queue
SSS-12 · PRO
Subscriber Segmentation & List Health Monitor
Monthly on the 5th: fetches all subscribers → segments by engagement score → Systems Auntie grades list health → prescribes actions per segment → Supabase + Telegram alert.
Auntie: Systems Auntie
Trigger: Monthly 5th, 9:00 AM
Nodes: 9
⏰
01 · SCHEDULE
Monthly List Health Schedule
Schedule Trigger
Day of month: 5th
Time: 09:00
👥
02 · FETCH
Fetch All Subscribers
Airtable · SEARCH
Table: SSS Subscribers
Filter: all records
Returns email, open count, click count, last open date per subscriber.
🔢
03 · SEGMENT
Segment & Score Subscribers
Code · JavaScript
Scores each subscriber: Engaged (5+ opens, clicked, active 30 days), Warm (2+ opens, active 60 days), Cold (low history), Inactive (90+ days no open). Calculates engagement rate %.
→ total, engaged, warm, cold, inactive, engagement_rate
⚙️
04 · AI AGENT
Systems Auntie — List Health Report
Claude · Sonnet
Grades list A–D (A=35%+ engagement). Gives: health summary, engaged segment action, cold re-engagement plan, inactive sunset decision, #1 priority action this month.
→ Structured JSON · 6 fields
→ SUPABASE
🗄️
05A · STORE
Save Health to Supabase
Supabase · INSERT
Table: sss_list_health
Monthly health trend data. Enables year-over-year comparison.
→ ALERT
📱
05B · NOTIFY
Alert — Monthly List Health
Telegram · sendMessage
Sends: grade, total subscribers, engagement %, top priority action. Jerry acts on Systems Auntie recommendation.
Segmentation Criteria
ENGAGED
5+ opens · clicked · active 30d
WARM
2+ opens · active 60d
COLD
Low open history · needs re-engage
INACTIVE
No open in 90+ days · sunset
Node types
Monthly Schedule
Airtable + Supabase
JavaScript Segmentation
Systems Auntie (Claude)
Telegram Alert