Auto-generate Notion content briefs from Airtable editorial calendar topics

Build me an agent workflow that turns every new topic in my editorial calendar into a fully researched content brief in Notion.

Trigger: poll Airtable for new records in my Content Pipeline table using the new_record event. The workflow should only fire on rows where the Status field equals "Briefing". The fields I want the agent to read off the row are Topic, Target Audience, and Target Keywords. Also capture the record ID so we can update the row later.

Step 1: Call Perplexity AI's Create Chat Completion using the sonar-pro model. Ask it to research the topic and produce: 3 to 5 compelling angles or hooks tailored to the target audience, recent industry data points and statistics (last 12 months where possible), what top-ranking competitors are currently saying about this topic, common reader objections or counterarguments, and a list of source-of-truth references with URLs. The response should include citations. Use the citations and search_results returned by Perplexity, not invented URLs.

Step 2: Call Notion's Create a Page operation to create a new page inside my "Briefs" database. Use the Topic as the page title. Set any matching database properties from the Airtable row (Target Audience, Target Keywords, Status = Draft Brief). Capture the new page ID and URL.

Step 3: Call Notion's Append Block Children on the new page to populate a structured brief with these sections, as heading_2 blocks followed by their content: Hook Ideas (bulleted list, 3 to 5), Suggested Outline (numbered list of H2 sections with a one-line description each), Key Stats and Data Points (bulleted list with the source after each stat), SEO Angle (a paragraph summarizing the recommended search intent, primary keyword, and a few related keywords to weave in), and Sources. For Sources, embed each Perplexity citation as a Notion bookmark block (not a plain text URL) so the page shows a rich preview.

Step 4: Call Airtable's Update Record on the original row. Write the Notion page URL into a field called "Brief URL" and set Status to "Brief Ready" so the editor knows it's good to go. Use the record ID captured at the start.

Error handling: if Perplexity returns no citations, still create the Notion page but mark Status on the Airtable row as "Needs Manual Research" instead of "Brief Ready". If the Notion page create succeeds but Append Block Children fails, retry once, then leave the page in place and write the URL back anyway so nothing is lost.

Keep the agent instructions tight and produce the brief in one pass per record.

Additional information

What does this prompt do?

Watches your Airtable content calendar and fires the moment a topic flips to a Briefing status.
Pulls the topic, target audience, and target keywords off the row and runs live web research for angles, recent data points, what top-ranking competitors are saying, and reader objections.
Creates a new page in your Notion Briefs database with hook ideas, a suggested outline, key stats, an SEO angle, and three to five citations linked as sources.
Writes the new Notion page link back onto the original Airtable row so the writer can jump straight from the calendar to the brief.

What do I need to use this?

An Airtable base with a content calendar table that has a status field (with a value like Briefing) and columns for topic, target audience, and target keywords.
A Notion workspace with a Briefs database, shared with your General Input connection.
A Perplexity AI account with API credits so the agent can run live web research with citations.

How can I customize it?

Change the status that triggers the brief (Briefing, Ready for Research, Queued) or watch a different Airtable table entirely.
Tweak the brief structure: add sections like internal links, suggested CTAs, target word count, or a competitor SERP snapshot.
Adjust the research scope: limit to recent results only, target a specific industry, or ask for more or fewer citations per brief.

Frequently asked questions

Where does the research come from?

Perplexity AI runs live, web-grounded searches and returns answers with real source links. Those links land in your Notion brief so your writer can verify everything before publishing.

Does this work with my existing Notion database?

Yes. Point the agent at any Notion database you use for content briefs and share that database with the connection. The agent fills in your existing properties and structure.

What if a topic is missing the audience or keywords?

The agent uses whatever is on the row. If audience or keywords are blank, it still researches the topic and notes in the brief that those inputs were missing, so you can fill them in and rerun.

Can I review briefs before my writer sees them?

Yes. Add a column like Brief Status to your Airtable table and have the agent set it to Ready for Review instead of pushing the brief straight to the writer.

How fast does a brief show up after I flip the status?

Usually within a couple of minutes. The agent checks Airtable on a short interval, then research and writing happen in one pass.