AI Content Assistant (Using SEO Keyword + Competitor Analysis)
Objective:
Automate SEO content creation by combining keyword input with competitor content insights to generate high-quality, search-optimized blog posts.
Tools Used:
Make, Notion, OpenAI, Google Docs, HTTP (HTML Scraper)
NB: Other preferred CRMs and tools can be used to achieve a similar outcome.
Overview:
This AI Automation is triggered by a new Notion entry containing a target keyword and/or a competitor URL, the automation runs two parallel content creation paths:
Keyword Path: Generates an original blog article using OpenAI based on the keyword, saves the draft to Google Docs, and updates the content status in Notion.
Competitor Path: Scrapes the competitor URL, extracts the article text, analyzes strengths and content gaps via OpenAI, and creates a refined, inspired post. Final status is updated in Notion.
Optional: Add collaborative human checkpoints to ensure quality.
Outcomes:
Streamlined content creation with SEO and competitive edge built in
Reduced content production time by 70%
Enables scalable content workflows with consistent quality and strategic alignment
Like this project
Posted Jul 28, 2025
Automated SEO content creation that combines keyword input with competitor content insights to generate high-quality, search-optimized blog posts.