Working in an AI company, using AI isn’t optional. It’s expected. It's a way of life!
So naturally, I started looking beyond just using AI for outputs. I wanted to see how it could improve the way we work. Not just faster outcomes, but smarter workflows.
I'm in a way blessed that I have a coding background, so I decided to experiment with something simple but powerful, using Google Apps Script. It’s free, flexible, and surprisingly capable if you know your way around it. I also used a combination of Claude and Minimax-M2.7 to troubleshoot and fix my code.
 |
| Me and my team now when AI and automation did all the work for us |
The Problem: Content Creation Fatigue
If you’ve ever worked in marketing, you know this pain.
Coming up with SEO content ideas consistently is exhausting. Not because tools don’t exist, but because the process is fragmented:
- You brainstorm topics
- You validate keywords
- You refine prompts
- You generate content
- You edit and structure everything
Yes, AI can write. But good content still needs:
- Relevance to your brand
- Alignment with your domain expertise
- Proper structure for SEO and readability
Even with tools like Semrush helping identify keyword trends and competitor gaps, the team still had to “figure things out” every single time.
So I asked a simple question:
What if we could automate the entire workflow?
The Solution: A Lightweight Content Automation Engine
I built a simple system that connects Google Sheets, Semrush, and Gemini into one streamlined pipeline.
Here’s how it works:
Step 1: Input the Idea
The team just fills in a “Topic” column in Google Sheets.
Think of it as the marketing angle or content idea.
That’s it. No prompting gymnastics required.
Step 2: Automate Keyword Intelligence
Using Google Apps Script:
- The script runs twice a week
- It reads new topics from the sheet
- Connects to Semrush via API
- Pulls relevant and trending keywords
No manual keyword research. No switching tabs like a caffeinated octopus.
Step 3: Generate Structured SEO Content
This is where Gemini comes in. By combining those keywords from Semrush together with the given topic, I designed a structured prompt that ensures every output follows SEO best practices:
- Strong, keyword-led title
- Meta description
- Clear introduction
- 5 to 6 structured sections
- Natural keyword integration
- FAQ section
- Conclusion with CTA
- Clean markdown output
- 1200 to 1800 words
The key here isn’t just AI generation.
It’s forcing consistency in quality and structure.
Step 4: Review and Approval Loop
Once the content is generated:
- The task is marked “Completed” on Google Sheets
- An email is triggered to me and the team
- Content is reviewed, edited, and approved before publishing
Human oversight stays in place. Just without the heavy lifting.
The Outcome: Less Friction, More Output
What used to be a messy, multi-step process is now streamlined into:
- Input topic
- Let automation handle the heavy work
- Review and publish
Simple. Scalable. Repeatable.
And most importantly, the team no longer dreads content creation.
Why This Matters (Especially Now)
Search behavior is changing fast.
People are:
- Starting with AI tools
- Cross-checking via reviews, Reddit, and YouTube
- Only then visiting brand websites
Which means your content needs to be:
- Structured
- Relevant
- Easy for both humans and AI to understand
This kind of workflow doesn’t just save time.
It positions your brand to show up where decisions actually happen.
Key Takeaways You Can Apply Today
1. Don’t Just Use AI. Systemise It.
Most teams use AI as a tool.
The real advantage comes when you turn it into a process.
If your team is still manually prompting every task, you’re leaving efficiency on the table.
2. Structure Beats Creativity (At Scale)
Good content isn’t just about ideas. It’s about consistency.
A strong framework ensures:
- Better SEO performance
- Easier readability
- Higher chances of being surfaced by AI
Think of structure as your unfair advantage.
3. Reduce Friction, Not Control
Automation doesn’t mean removing humans.
It means:
- Removing repetitive work
- Keeping strategic control
- Letting your team focus on refinement, not creation
The goal isn’t to replace marketers.
It’s to make them dangerously efficient.
If you’re still treating content as a manual craft, it might be time to rethink the system.
Because in an AI-first world, speed matters.
But structured speed wins.
What about you? What's stopping you from automating your workflows?