Joshua R. Dapitillo

Remote · UTC+8

Automation · AI workflows

AI Automation Line Map

Five production workflows I run at GROW HQ, drawn as a transit map. Each line starts with one command and ends with something delivered: a report, a scheduled video, an edited cut, a podcast post or an action list from a video briefing.

Client
GROW HQ GmbH
Role
Workflow design and build, run with Claude Code
Tools
  • Claude Code
  • Whisper (local)
  • ffmpeg
  • Google Sheets API
  • Notion API
  • YouTube Data API
  • Podigee API
  • Loom
  • WordPress
Year
2026
Language
German and English

Line map5 lines · 1 hub

  • L1Webinar report
  • L2YouTube publishing
  • L3Video editing
  • L4Podcast to WordPress
  • L5Loom to action list

All lines start at Claude Code

The brief

Agency work is full of repeatable chains: fetch a recording, transcribe it, pull numbers into a sheet, file it, tell the team. Done by hand, every chain costs hours and invites small mistakes, and client data has to stay where it belongs.

The approach
  1. Each workflow is a Claude Code command with written rules, checks and a progress table, so every run is repeatable and every step is visible.
  2. Transcription runs locally on the Mac with Whisper, so recordings never go to a cloud transcription service.
  3. Quality gates before anything leaves: transcript loop checks, audio-sync and frame checks on videos, and an approval step before publishing.
  4. APIs instead of clicking: Google Sheets, Notion, YouTube, Podigee and WordPress are written to directly.
  5. Every run ends with a status table, and the Notion task or comment for the team is always the last step.
The outcome

In regular use at GROW HQ since summer 2026, across several client accounts. Client names and numbers stay out of this write-up on purpose.

The line map

Automation line map: 5 workflows starting from Claude Code Webinar report: Recording, Local Whisper, Transcript QA, Filed to Drive, Funnel KPIs, Sheets report, Notion. YouTube publishing: Final render, Local Whisper, Titles from transcript, Approval, Upload + schedule, Podcast episode, Notion. Video editing: Raw footage, Local Whisper, Cut plan, Render, Subtitles + overlays, QA: sync + frames, Delivered to Drive. Podcast to WordPress: Podigee episodes, WordPress post, Live on the client site. Loom to action list: Loom link, Video + transcript, Frame every 5 s, Timecoded action list. RecordingTranscript QAFiled to DriveFunnel KPIsSheets report Final renderTitles from transcriptApprovalUpload + schedulePodcast episode Raw footageCut planRenderSubtitles + overlaysQA: sync + framesDelivered to Drive Podigee episodesWordPress postLive on the client site Loom linkVideo + transcriptFrame every 5 sTimecoded action list Local Whisper transcripts on the Mac Notion task for the team Claude Code one command per line Lines L1 Webinar report L2 YouTube publishing L3 Video editing L4 Podcast to WordPress L5 Loom to action list
Hover a line or its legend entry to follow it.Swipe sideways to see the whole map. Interchanges are steps that several lines share.

Line by line

  1. L1

    Webinar report

    Turns a recorded client webinar into a filed transcript and a funnel KPI report.

    1. Recording
    2. Local Whisper
    3. Transcript QA
    4. Filed to Drive
    5. Funnel KPIs
    6. Sheets report
    7. Notion

  2. L2

    YouTube publishing

    Takes a finished video from render to a scheduled upload, with a podcast episode alongside.

    1. Final render
    2. Local Whisper
    3. Titles from transcript
    4. Approval
    5. Upload + schedule
    6. Podcast episode
    7. Notion

  3. L3

    Video editing

    Cuts long-form, testimonial and ad videos with subtitles and animated overlays.

    1. Raw footage
    2. Local Whisper
    3. Cut plan
    4. Render
    5. Subtitles + overlays
    6. QA: sync + frames
    7. Delivered to Drive

  4. L4

    Podcast to WordPress

    Publishes podcast episodes as posts on a client's WordPress site.

    1. Podigee episodes
    2. WordPress post
    3. Live on the client site

  5. L5

    Loom to action list

    Turns a Loom briefing or feedback video into a timecoded action list, with a screenshot for every point, so nobody has to rewatch it.

    1. Loom link
    2. Video + transcript
    3. Frame every 5 s
    4. Timecoded action list