LOW / CODEBlueprints
marketingai

AI SEO Content Brief Generator

Input a target keyword and let Claude AI research search intent, suggest headings, estimate word count, and generate a complete SEO content brief. Results are saved to Google Sheets and emailed to your content team.

Intermediate~20 minn8nMake.com 956 downloads 3570 views

Setup Instructions

1. Get your Claude API key from console.anthropic.com and store it as a credential. 2. Create a Google Sheet with columns: Keyword, Search Intent, Target Word Count, Suggested Title, H2 Headings, H3 Headings, Key Points, Internal Link Suggestions, CTA Recommendation, Brief Status, and Generated Date. 3. Set up a trigger — either a webhook that receives keywords, a form submission, or a Google Sheets trigger when a new keyword is added to the Keyword column. 4. Add an HTTP Request node to call the Claude API (POST https://api.anthropic.com/v1/messages) with model "claude-sonnet-4-20250514". Use a detailed system prompt instructing Claude to act as an SEO content strategist: analyze the keyword's search intent, suggest a title, recommend H2/H3 structure, estimate word count, list key points to cover, and suggest internal linking opportunities. 5. Parse the Claude response JSON and map each field to the corresponding Google Sheets columns. 6. Add a Google Sheets node to append or update the row with the full content brief. 7. Add a Gmail node to email the formatted brief to your content writer or team distribution list, including the keyword, suggested structure, and key points. 8. Test with a sample keyword like "best project management tools 2026" and verify the brief quality.
Troubleshooting
**Claude response is unstructured or hard to parse:** Add explicit JSON formatting instructions in your prompt, e.g., "Return your response as valid JSON with these exact keys: searchIntent, wordCount, title, h2Headings, h3Headings, keyPoints." Use a JSON parse node after the API call. **Google Sheets update overwrites existing data:** Make sure you're using an "append row" operation, not "update." If updating existing keyword rows, match on the Keyword column to find the correct row ID. **Email arrives with broken formatting:** Format the brief as HTML in the Gmail node body. Use <h2>, <ul>, and <p> tags for clean rendering. Avoid sending raw JSON in the email body. **Token limit exceeded for long briefs:** Increase max_tokens to 4096. If the brief still gets cut off, break it into two API calls — one for structure and one for detailed key points.

Related Blueprints

marketingai

AI Email Subject Line A/B Generator

Feed your email campaign context to Claude AI and get 10 subject line variations with predicted open rate scores and reasoning for each. Results land in Google Sheets for team review, with top picks sent to Slack and Gmail.

google-sheetsslackgmail
Beginner~10 min
617
marketing

Email Campaign Trigger Workflow

Trigger targeted email campaigns based on user actions captured through Typeform. Responses flow into Google Sheets for segmentation, then personalized emails go out via Gmail automatically.

typeformgmailgoogle-sheets
Intermediate~25 min
748
salesai

AI Personalized Sales Email Drafter

Generate hyper-personalized outreach emails using Claude AI based on prospect data from Google Sheets. Each email is tailored to the prospect's role, company, and pain points before being drafted in Gmail.

gmailgoogle-sheetsslack
Beginner~15 min
932
salesai

AI Deal Intelligence Briefing

Before a sales call, Claude AI pulls prospect info and recent context from Google Sheets, generates a comprehensive prep briefing with talking points, and posts it to Slack so your team walks into every call prepared.

google-sheetsslackgmail
Intermediate~20 min
344

Need a custom version?

We can build a tailored automation workflow for your specific needs.

New blueprints weekly

Get notified when we publish new automation workflows.