Generate SEO Content Briefs From Airtable keyword list Into Notion

Feed in a keyword and this researches intent, pulls the questions people ask, outlines the article and sets a word-count target — delivering a writer-ready brief in Notion in under a minute.

difficulty Intermediatesetup 40 minresult A complete SEO brief — search intent, outline, FAQs and target length — is produced in Notion for each keyword, ending brief-writing busywork.
  1. 1

    Step 1 — Get the keyword(s)

    Add a Schedule Trigger + Airtable node reading unprocessed keyword records.

  2. 2

    Step 2 — Pull the People-Also-Ask questions

    Add an HTTP Request (SERP API) or an OpenAI node to gather the common questions and subtopics searchers expect for this keyword.

  3. 3

    Step 3 — Draft the brief

    Add an OpenAI node that outputs search intent, a heading-by-heading outline, the FAQs to answer, and a recommended word count.

  4. 4

    Step 4 — Deliver to Notion

    Add a Notion node to create a brief page in your content database.

Frequently asked questions

Can it process a whole list at once?

Yes — with the sheet/table input, loop over unprocessed rows and mark each done after Step 4, so you can queue dozens of keywords and let it work through them.

Will it write the article too?

This produces the brief a writer (human or AI) then fills. Keeping brief and draft separate gives you an editorial checkpoint and better quality.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.