Draft AI Overview ready content briefs in Notion from Airtable keywords

Build me an agent workflow that turns new keyword rows in our Airtable content briefs table into AI Overview ready briefs in Notion. The brief should be sourced from what Google is actually showing on the live search results page, not from generic LLM research.

Trigger: Airtable poll trigger on new_record for our content briefs table. Each new row carries the target keyword (and optionally a topic, audience, or country field if present).

On each new row, the agent should:

1. Call Real-Time Web Search's People Also Ask operation for the keyword with fetch_answers set to true, so it gets back the full PAA question tree along with the answer snippet and source link Google shows for each question.

2. Call Real-Time Web Search's Search operation for the same keyword with fetch_ai_overviews set to true, so it captures the top organic results and the AI Overview text if Google returns one. If no AI Overview is present, note that in the brief, do not invent one.

3. Rank the People Also Ask questions and pick the 8 to 12 highest intent ones. Prioritize questions that map to clear searcher intent (how, what, why, vs, cost, best), avoid duplicates, and prefer questions where Google already trusts a source enough to surface an answer snippet.

4. For each selected question, draft a tight 2 to 4 sentence answer grounded in what the top organic results and the AI Overview already say. Cite the source URL inline so the writer can verify. Do not paraphrase a single source, synthesize across the top results.

5. Use Notion's Create a Page operation to file the brief in our content briefs database. The page should include: a target H1 written for both human readers and AI Overview inclusion, a short intro angle (what makes our take different), the ranked question and answer pairs structured so a developer can drop them into FAQPage schema without reshuffling, an AI Overview summary block (or a note that none was returned), and a sources section listing every URL the answers were drawn from.

6. Optionally write the Notion page URL back to the Airtable row using Update Record so the writer can jump straight to the brief.

Tone: this brief is explicitly built for Google AI Overview and PAA inclusion, not a generic blog brief. It complements (does not replace) our existing Ahrefs and Semrush briefs, which give us the keyword and competitor view. This brief gives us the question and intent view from the live SERP.

Ask me before building: which Airtable base and table holds the briefs, which field carries the target keyword, which Notion database the brief should land in, and what country and language to search from (default to United States and English).