SEO Guest Post Generator
Pulls pending guest post topics from a sheet, merges them with brand guidelines.
What it does
You get SEO-optimized guest post articles automatically written by an AI using your brand guidelines and topics from Google Sheets. The system saves each new draft to a separate sheet and updates the original row so you never generate duplicates twice.
Step by step
- Configure a Google Sheets trigger to watch for new rows in the planning sheet.
- Map specific columns from the source sheet to variables like target keyword and brand voice.
- Set up a second Google Sheets action to write the generated content back into designated cells.
- Update the status column of the processed row to 'Completed' or 'In Progress'.
Where the LLM does the work
- Construct a system prompt that strictly enforces brand tone and SEO structure guidelines.
- Generate the actual article body by combining the target keywords with the provided outline data.
- Refine the output to ensure it reads naturally in the specified language while maintaining keyword density.
Watch out for
SEO keywords might be stuffed unnaturally so add a constraint in the prompt to prioritize readability over keyword repetition.
Tools that fit
OpenAI Chat Model LLM Generating guest post content
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal SEO Guest Post Generator: Pulls pending guest post topics from a sheet, merges them with brand guidelines. ## Specification - What it does: You get SEO-optimized guest post articles automatically written by an AI using your brand guidelines and topics from Google Sheets. The system saves each new draft to a separate sheet and updates the original row so you never generate duplicates twice. - Trigger: Run manually (Manual · on demand) - Autonomy: Fully hands-off - Expected setup effort: about an afternoon - Tools/services involved: - Google Sheets: Storing planning data and results - OpenAI Chat Model: Generating guest post content - Gmail: Sending notifications ## Known pitfalls, handle each one explicitly in your implementation 1. SEO keywords might be stuffed unnaturally so add a constraint in the prompt to prioritize readability over keyword repetition. ## Reference implementation https://n8n.io/workflows/7666 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/automated-seo-guest-post-generator/ via usecasesforagents.com
Frequently asked questions
Can I use a different Spreadsheet than Google Sheets?
Yes. Google Sheets is only the example spreadsheet in this recipe. The same flow works with Airtable, Baserow and Excel. Swap the spreadsheet connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Built for marketers who'd rather brief an agent than start from a blank doc.