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
Summaries land
AI-generated summaries are stored per video in the database.
- 2
Review
The team sees one row per video with its status.
- 3
Publish
One click, or a batch, runs a Retool Workflow that posts to WordPress.
- 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
More work
More case studies
A group travel company moves off Airtable onto Supabase and Retool
Read the case study →Gemstone manufacturing (B2C)House Of Sylas: from a backlog of Google Sheets to apps for the team and its partners
Read the case study →Finance operationsAI invoice and expense automation that files itself
Read the case study →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