Turn editorial calendar topics into researched Notion briefs

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.