Case study · Media & content

Publishing AI video summaries to WordPress in one click

A content team had AI writing summaries of videos, and then someone copied each summary into WordPress by hand. We built a small Retool console on top of the summaries database and two Retool Workflows that do the publishing, so the team reviews a video, clicks once and the post is live.

The challenge

What wasn’t working

Each video could have several AI summaries from different prompts, so the raw list showed the same video many times.

Copying summaries into WordPress by hand was slow, and it was easy to publish the same video twice.

There was a backlog, and publishing it one post at a time would have taken days.

The solution

What we built

Review queue

One table with one row per video: title, channel, identifier and published date, with links to the media and the live post.

One row per video

A SQL query ranks each video’s summaries and keeps the first, then joins in the published post if there is one.

Live status

Each row shows “Post to WordPress” until it’s published and “Published” after, with the date and a link.

One-click publish

Clicking a row’s button runs a Retool Workflow that publishes that video to WordPress and refreshes the list.

Bulk publish

Select several videos and publish them together. Ones already published are skipped.

No mixed actions

Single publish is disabled while rows are selected, so single and bulk publishing can’t collide.

How it works

From AI summary to live post

  1. 1

    Summaries land

    AI-generated summaries are stored per video in the database.

  2. 2

    Review

    The team sees one row per video with its status.

  3. 3

    Publish

    One click, or a batch, runs a Retool Workflow that posts to WordPress.

  4. 4

    Status updates

    The list refreshes and the row shows the published date and link.

The result

What changed

  • AI summaries reach WordPress without copy and paste
  • One row per video with a live status prevents duplicate posts
  • A backlog can be published in one action
  • Publishing logic lives in workflows, so the console stays simple

Have a project like this?

Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.

Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day