1. Milestone update

   "Shipped [feature].

    What was hard to build: [technical challenge]

    Value to users: [concrete benefit]"



2. Weekly numbers

   "This week's numbers:

    Users: 247 (+12)

    MRR: $345 (+$21)

    Churned: 2

    Main improvement: [what I fixed]"



3. Sharing a failure

   "What I messed up this week: [specific failure]

    Root cause: [why]

    What I'll do differently: [lesson]

    Sharing this so you don't make the same mistake"



4. Decision-making process

   "Was torn between [option A] and [option B].

    What tipped it: [reason]

    Here's how I think through these decisions"



5. Technical tip (short form)

   "How I solved [problem] in Flutter:

    [3 lines of code or a diagram]

    Full post →"



6. Question / feedback request

   "Redesigning the [feature X] UI.

    Option A vs Option B — which feels more intuitive?

    Real user input matters"



7. Gratitude / community

   "[Follower name]'s feedback led to [improvement].

    Thank you — before/after comparison:"

Mon: last week's numbers (MRR / user count)

Wed: technical tip or failure story

Fri: what shipped this week or WIP screenshot

Sun: next week's goal (accountability post)

// supabase/functions/post-x-update/index.ts

// Review drafts generated by weekly-sns-draft, post approved ones

const { data: draft } = await supabase

  .from('sns_drafts')

  .select('content')

  .eq('platform', 'x')

  .eq('status', 'approved')

  .order('created_at')

  .limit(1)

  .single();



if (draft) {

  await postToX(draft.content);

  await supabase.from('sns_drafts')

    .update({ status: 'posted' })

    .eq('id', draft.id);

}

Core principle  → earn trust through transparency (imperfect is fine)

Post types      → rotate through: numbers / failures / tech / decisions

Frequency       → 4 posts/week is the sustainable ceiling

Automation      → weekly GHA generates draft → manual review → post