SEO content brief generator: Airtable + Semrush + 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.

Additional information

What does this prompt do?

Watches your content pipeline in Airtable and kicks off as soon as a writer adds a new target keyword.
Pulls live search data from Semrush: monthly volume, search intent, difficulty, related terms, real reader questions, and the top 10 ranking pages.
Drops a polished brief into Google Docs with target keyword, intent, recommended word count, an H2 and H3 outline, must-include terms, an FAQ section, and competitor URLs to study.
Replaces the manual ritual of opening Semrush, running five reports, and pasting the results into a template for every new piece.

What do I need to use this?

An Airtable base with a Content Pipeline table that has at least a target keyword field and a content angle or notes field.
A Semrush account on a plan that includes API access (Business plan or the API add-on).
A Google account that can create documents in the Drive folder you want briefs saved to.

How can I customize it?

Point it at a different Airtable table or view if you keep separate pipelines per brand or per writer.
Switch the Semrush region (United States, United Kingdom, Germany, and so on) so the volume and difficulty match the audience you actually write for.
Tweak the brief template: ask for more H3s, add a tone or style section, require an internal-linking checklist, or change the word-count formula.

Frequently asked questions

What do I have to put in the Airtable row to make this work?

At minimum a target keyword. A content angle, audience, or working title makes the outline sharper, but the keyword alone is enough to generate the brief.

Where does the finished Google Doc end up?

A new document is created in your Google Drive each time. You can tell the agent which folder to save into, and have it paste the doc link back into the Airtable row so writers can click straight through.

How long does it take to produce a brief?

Usually under a minute. Most of that time is Semrush returning the keyword and competitor reports.

Will this work if my team is on Semrush's cheapest plan?

No. The Semrush API is only available on the Business plan or with the API add-on. Starter and Pro plans cannot make these calls.

Can the same brief format work for multiple writers or brands?

Yes. The template lives in the prompt, so you can adjust the headings, sections, or tone once and every brief that follows uses the new format.