Turn new Airtable content briefs into Ahrefs-backed Google Docs

Build an agent workflow that turns new Airtable content brief requests into Ahrefs-backed Google Docs briefs.

Trigger: Airtable poll, event type new_record, watching my Content Briefs table. Each row provides a target keyword and a country (two-letter code like us, gb, de). It also has empty columns for the generated doc link and a one-line difficulty verdict.

When a new row appears, the agent should pull the live SEO picture from Ahrefs for that keyword and country, then synthesize a writer-ready brief.

Ahrefs calls to make (always pass the row's country):

1. Get Keyword Overview for the target keyword to capture search volume, keyword difficulty, CPC, and parent topic.

2. Get SERP Overview for the target keyword to see the top organic results, their titles, URLs, domain ratings, and traffic.

3. From the SERP, pick the top two or three competing domains and call List Organic Keywords on each to understand the keyword cluster they rank for around this topic.

4. Call List Top Pages on those same competitor domains to identify the dominant content structures and formats winning for this topic.

Use the select parameter on every Ahrefs list call to limit fields to what the brief actually needs, since Ahrefs charges API units per field.

Then synthesize the brief. It should cover: search intent (informational, commercial, navigational, transactional), a suggested title and meta description, a full H2 and H3 outline, questions the article must answer, recommended word count anchored to the top results' length, internal linking ideas pulled from the competitors' related keywords, and a 'unique angle' section that explicitly calls out what the top-ranking pages are missing or doing poorly.

Output: call Google Docs Create Document to make a new doc titled something like 'Content Brief: <keyword> (<country>)'. Then call Batch Update Document to fill it with the brief content using proper heading styles (HEADING_1 for the doc title section, HEADING_2 for major sections, HEADING_3 for subsections) and bullet lists for the outline points and questions. Build the batchUpdate requests array in a single call, and order any position-dependent operations from highest index to lowest.

Write-back: call Airtable Update Record on the source row to populate the doc link column with the new doc's URL, and the difficulty verdict column with a one-line summary like 'KD 42, ~3,200 vol, mid difficulty, winnable with deeper FAQs' so the team can scan Airtable and assign briefs without opening every doc.

Keep the SERP and competitor analysis scoped to the row's country whenever one is supplied. If country is missing, default to us and note that in the verdict.