Pre-publish YouTube QA from your Airtable calendar
When a video flips to Ready for review in Airtable, vidIQ scores the title and thumbnail and a verdict lands in your Slack channel.
Build me a pre-publish QA agent for my YouTube content calendar. It should watch my Airtable base and fire whenever a video draft is ready for human review, then run the draft through vidIQ before I post it.
Trigger: poll Airtable with the New or Updated Record event on my Videos base / Videos table. The agent should only act when the row's Status field flips to "Ready for review" (make the exact status value configurable). Ignore other status changes.
Once a matching row fires, use Airtable's Get Record to read the full row. The fields it needs are: working title, planned thumbnail URL (or attachment URL), target topic / keyword, channel name, and the row id. Carry the row id through so we can write back at the end.
Then call vidIQ through its MCP server to score the draft. Three calls:
vidiq_score_title on the working title.
vidiq_score_thumbnail on the planned thumbnail URL.
vidiq_keyword_research on the target topic to pull search volume, competition, and related keywords.
With those results, reason about the weak spots. Identify the highest-opportunity keyword (good volume, lower competition) from the keyword research output. Draft two or three sharper alternate titles tuned to that keyword. Flag any thumbnail issues the score surfaces (low contrast, small face, no focal point, text too small, etc.) in plain language.
Then post a single Slack message via Send a Message to my content channel (let me set the channel id at setup). The message should include:
Video name and channel.
Title score and thumbnail score from vidIQ.
Target keyword with its volume and competition, plus the higher-opportunity keyword if it found one.
The recommended title (the strongest of the alternates) and the runner-up options below it.
Any thumbnail issues to fix.
A clear verdict at the bottom: GO if both scores clear the bar, REWORK if either is weak (let me tune the thresholds).
Optional but on by default: write the scores and the recommended title back to the same Airtable row using Update Record, so the calendar carries the review history. Use fields like Title Score, Thumbnail Score, Recommended Title, and QA Verdict (create them if they do not exist and let me map the field names at setup). If write-back is turned off, skip this step.
Keep it to one workflow, one Slack message per fire, and do not re-process a row unless the status flips back into Ready for review again.
What does this prompt do?
- Watches your Airtable content calendar and fires the moment a video is marked Ready for review.
- Scores the working title and thumbnail with vidIQ and pulls search volume plus competition for the target keyword.
- Drafts two or three sharper alternate titles tuned to the highest-opportunity keyword and flags any thumbnail issues.
- Posts a single Slack message to your content channel with the scores, the recommended title, and a clear go or rework verdict.
What do I need to use this?
- An Airtable base with a Videos table that includes a status field, a working title, a thumbnail image or URL, a target topic or keyword, and the channel name.
- A vidIQ account with an API key from the MCP settings page.
- A Slack workspace and the channel where you want the pre-publish review to land.
How can I customize it?
- Change the status value that triggers the review (for example Ready for review, In QA, or Final cut).
- Swap the destination Slack channel or route different channels (kids, gaming, finance) to different reviewers.
- Tighten or relax the verdict thresholds so only stronger drafts get a green light.
- Turn on the optional Airtable write-back so the scores and recommended title are saved on the row for future reference.
FAQs
When does this run?
What does the Slack message actually look like?
Does it change my Airtable row?
Can I use this for more than one channel?
What if my target keyword is weak?
Related templates
Work every partner tier decision from one board, with the revenue and commission numbers, clear promotion thresholds, and AI review briefs.
Open one board at month end to find every closed deal missing a commission, every commission with no deal behind it, and every amount that does not add up.
See warmup status, daily send volume, and bounce risk for every sending account in one grid, with the riskiest mailboxes floating to the top.
Review Introw partner payouts line by line, approve them from one board, raise the matching bill in Xero, and post every approval to Slack.
See who is due, build a week of dinners on demand, swap anything you do not like, then send the recipe and grocery links yourself.
See every customer photo that tags your brand, ask for permission in one click, and repost only once a yes is on the record.
Stop publishing YouTube videos with weak titles and thumbnails.
Connect Airtable, vidIQ, and Slack once. Every draft you mark Ready for review gets a vidIQ-scored verdict before it goes live.