Weekly YouTube Content Calendar in Notion (vidIQ + Notion)

Every Friday at 7am in my local timezone, generate next week's YouTube content slate and add it to my Notion content calendar so I walk into Monday with five planned ideas.

Trigger: cron, weekly on Friday at 7am.

Inputs the user will configure when installing this workflow:

- The Notion database (data source) that serves as their Ideas / content calendar, plus a mapping from the fields below to that database's properties.

- The niches, topics, or channel themes the agent should research (e.g. 'AI workflow automation', 'home espresso', 'indie game dev').

- Optional: preferred mix of long-form versus Shorts, target audience notes, and any topics to avoid.

What the agent should do on each run:

1. For each configured niche, call vidIQ Keyword Research to surface high-volume, low-competition keyword candidates, and vidIQ Trending Videos to see what is currently hot in that category and region.

2. Synthesize five distinct video ideas across the niches. For each idea capture: a working title written for click-through, the target keyword, the search volume and competition score from vidIQ, a one-line hook describing the angle, and a suggested format of either long-form or Shorts.

3. Before creating any new page, call Notion Query a Data Source against the Ideas database and skim recently planned or published items. Skip any candidate that clearly duplicates an idea already in the calendar so the week-over-week slate stays fresh.

4. For each remaining idea, call Notion Create a Page to add a new page to the Ideas database, mapping the fields above to the configured database properties (title, target keyword, search volume, competition score, hook, format).

Use vidIQ for Keyword Research and Trending Videos, and Notion for Query a Data Source and Create a Page. Keep the output strictly to filling the database; no Slack notification, no email, just a clean five-page drop into the content calendar.

Additional information

What does this prompt do?

Generates five fresh YouTube video ideas every Friday at 7am so you start Monday with a planned slate.
Picks topics from high-volume, low-competition keywords and trending videos in your niche, using real vidIQ data instead of guesswork.
Drops each idea into your Notion content calendar with a click-worthy title, target keyword, search volume, competition score, a one-line hook, and a suggested format (long-form or Shorts).
Scans your existing calendar before adding anything new, so duplicates and topics you already covered get skipped automatically.

What do I need to use this?

A Notion workspace with an Ideas database (the one you use as your content calendar), shared with the General Input connection.
A vidIQ account with API access for keyword research and trending video data.
The niches, topics, or channel themes you cover, so the agent knows what to brainstorm around.

How can I customize it?

Change the day or time the calendar gets filled (the default is Friday at 7am in your timezone).
Adjust how many ideas you want each week and the mix of long-form versus Shorts.
Update the niches, target audience, or topics to avoid so the agent stays on brand.

Frequently asked questions

Will this work if my Notion content calendar has different properties than the defaults?

Yes. Point the agent at your Ideas database and tell it which property each field should fill (title, keyword, volume, competition, hook, format). The defaults are a starting point, not a requirement.

Does it actually pick good keywords or just brainstorm in a vacuum?

It pulls real search volume and competition scores from vidIQ, plus what is currently trending in your category, so each idea is grounded in actual demand for your niche.

How does it avoid repeating ideas I've already planned or published?

Before adding anything new, it reads your existing Ideas database and skips candidates that clearly overlap with topics already in your calendar.

Can I focus on Shorts only, or only long-form?

Yes. Tell the agent which formats your channel covers and it will weight the five ideas accordingly.

What if I don't want it to run one week?

You can pause the workflow or change its schedule any time from the workflow page. Nothing gets added to Notion until the next scheduled run.