Turn new Airtable rows into SEO content briefs in Google Docs

Build me an agent workflow that turns new rows in our Airtable content pipeline into finished SEO content briefs in Google Docs.

Trigger: poll Airtable for new records in our Content Pipeline base (event type: new_record). I will configure the base, table, and view at setup. Each record has at least a target keyword field and a content angle or notes field; the workflow should read both off the triggering record.

When a new record fires, the agent should research the target keyword in Semrush by calling, in order:

1. Semrush Keyword Overview (One Database) for the target keyword to get monthly search volume, CPC, search intent, and keyword difficulty. Default the regional database to US but make it configurable.

2. Semrush Get Related Keywords on the target keyword to build a semantic keyword cluster the writer must include. Keep the top 15 or so by relatedness and volume.

3. Semrush Get Phrase Questions on the target keyword to surface real who/what/why/how questions readers ask. Keep 8 to 12 of the highest-volume questions for the FAQ section.

4. Semrush Get Organic Results for a Keyword to identify the top 10 ranking URLs for the target keyword. Capture position, URL, and domain.

Then synthesize everything into a structured content brief with these sections: Target keyword and one-line summary; Search intent (informational, commercial, etc.); Keyword stats (volume, KD, intent, CPC); Recommended word count, derived from a reasonable read of the top organic results (lean toward the median, round to the nearest 100); Suggested H2 and H3 outline that covers the angle from the Airtable row and clearly differentiates from the top 10; Semantic keywords to include, as a checklist; FAQ section seeded from the phrase questions, with a one or two sentence draft answer for each; Competitor URLs to study, listed by rank with domain.

Finally, write the brief into Google Docs. Call Google Docs Create Document to create a new doc titled with the target keyword and today's date, then call Google Docs Batch Update Document to insert the full brief with proper heading styles (Heading 1 for the title, Heading 2 for top-level sections, Heading 3 for outline subsections) and bulleted lists where appropriate.

After the doc is created, write the document URL back to the Airtable record using Update Record so the writer can click straight from the pipeline into the brief. Also set a status field to something like Brief Ready if that column exists.

If Semrush returns ERROR 50 :: NOTHING FOUND for any keyword report, treat it as an empty result and continue with the other sections rather than failing. If the API key is rejected or units are exhausted, stop and surface a clear error so I can fix the credential.