I Automated My SEO Content. My Team Finally Stopped Complaining

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:

1. Input topic
2. Let automation handle the heavy work
3. 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?

Why AEO Matters and Why Brands Need To Stop Relying Only on Paid Media

Most brands still pump money into ads and hope traffic magically appears. It’s like paying for express shipping when the item is still sitting in your cart. AEO (Answer Engine Optimization) fixes that problem by helping your brand show up where people actually start looking today: answer engines like ChatGPT, Perplexity and Gemini.

Here are the five big reasons brands should take AEO seriously instead of throwing more budget into paid traffic.

1. Your customers aren’t starting on Google anymore

People now begin their journey inside AI tools, not search engines. They ask AI for answers, then cross check with human reviews, then only later do they land on a brand site. If your brand doesn’t show up in that first AI-generated answer, you basically didn’t get invited to the party.

Visitors who do discover a brand through answer engines convert 4.4 times better and faster. Yes, four point four. Paid media wishes it could do that. AI search visitors tend to convert better because LLMs can equip users with all the information they need to make a decision.

Source: semrush.com

2. AEO is SEO’s cool, more socially aware cousin

The fundamentals remain the same. If AI can’t interpret your content, it won’t cite you. AEO builds on SEO but demands better structure, better clarity and more human relevance.

That means:
• Clean HTML
• Clear headings
• Minimal JS
• Fast, stable pages
• Content sections that make sense even if AI lifts them out of context

Think of it as cleaning your house because guests might show up anytime.

3. Answer engines need answers, not fluff

AEO is powered by the questions buyers ask at every funnel stage. You’re no longer writing to please an algorithm. You’re writing to answer real people.

You need to research:
• Keyword data
• Social and forum conversations
• Chat transcripts
• Sales calls

Then build content that leads with the answer, adds depth, includes FAQs and connects back to your product naturally.

Your future customer isn’t going to scroll five paragraphs to get to the point. Neither will AI.

4. AI trusts the internet’s gossip channels

AI heavily references sources like Reddit, YouTube, Quora, review sites and editorial listicles - What I like to call "human-first channels". If your brand isn’t present, mentioned or endorsed in these places, there are lesser chances for you to make it into AI answers.

AEO requires feeding the right signals:
• Earned mentions on sites AI cites
• Social proof in human-first channels
• Strong editorial reviews
• Presence in best-of lists
• YouTube explainers or tutorials

If you’ve ever wished you could control the internet conversation about your brand, AEO gives you a legitimate excuse to try.

5. You can finally measure visibility inside AI ecosystems

AEO isn’t guesswork. Modern AEO scorecards track visibility, share of voice, citation volume and even AI-referred demand.

Brands applying AEO have seen massive jumps in citations and leads. It’s the kind of data that makes CMOs smile and finance teams suspiciously cooperative.

Final thought

Paid media will always have its place, but using ads alone is like trying to win a race with one shoe. AEO helps brands show up early in the buyer journey, stay visible in AI-generated conversations and capture higher intent traffic without endlessly inflating CPMs.

If AI is the new front door of the internet, AEO is how you get your brand on the welcome mat.

What about you? Are you already optimizing your website for AI?

Google AI Mode. Adapt or Disappear from Search Results

Google is bringing something huge to the table, and it’s called AI Mode. This isn't just a small tweak; it's a massive shift in how we all search and find stuff online. You know how you used to type something into Google and get a list of links? Well, that's changing.

Image credit: Google Blog

Think of AI Mode like your super smart assistant, powered by Google's Gemini AI. Instead of just giving you links, it actually answers your questions. You can ask it complicated stuff, even chat back and forth, and it'll pull info from everywhere – text, photos, videos – to give you a complete, human-like answer right there on the search page. It’s like it’s done all the digging for you!

So, what does this mean for your brand and your online presence? Big, big news.

1. Why Your Website Might Get Fewer Traffic and Clicks

Your old SEO playbook might be outdated! This is the tough pill to swallow. If Google’s AI gives someone a full, direct answer to their question, why would they need to click your website link? They probably won’t. This means a drop in your organic click-through rates (CTR). We’re talking about "zero-click searches" becoming more common. If people aren't clicking, that's fewer eyeballs on your site, right?

2. What About Your Ad Money (PPC)?

Now, this is an interesting one. Google's not just going to leave ads out; they're putting them right into those AI answers (watch the AI Mode video above know more). That will be a new spot to be seen, which could be great, but it also means advertisers are going to fight like crazy for those prime AI-powered spots. This could push up your Cost Per Click (CPC) for the most valuable ad placements. Also, if users get their answers from the AI, they might scroll less, making traditional ads at the bottom of the page less effective. You'll need to be super smart about how you bid now.

3. Forget Optimizing Keywords, Start Thinking "Why" (Intent and semantic based)

This is where the game truly changes. Just stuffing your website with keywords isn't enough anymore. Google's AI is smart enough to understand the "why" behind your search. It’s about user intent.

Let's say someone searches for "best running shoes for flat feet." They're not just looking for words; they're looking for guidance. If your website has a detailed guide on choosing shoes and shows them where to buy, you're hitting that intent. The AI can then help them ask more questions, like "which brand is best?" – and your content needs to be ready to answer.

Or, imagine someone just types "Apple." Simple, right? But the AI, being super smart, looks at other things they've searched for recently. If they looked up "iPhone 15 reviews" or "MacBook Pro," the AI knows they mean Apple Inc. If they just searched "healthy recipes" or "fruit salad," the AI knows they mean the fruit. This is called semantic targeting – understanding the deeper meaning, not just the exact words. Your website content needs to make sense, deeply!

So What You Can Do Right Now?

It’s not entirely doom and gloom. Here’s how you start preparing:

• Become the Ultimate Expert: Google’s AI loves authority. Make sure your website clearly shows who is writing the content and that they know their stuff. Build trust, get good reviews, and make sure Google knows you're the real deal.
• Give Direct Answers, Fast: When you write for your website, imagine someone asking a question, and answer it directly, right at the top. Use bold headings, clear lists, and short paragraphs. Make it super easy for the AI to grab your info.
• Build Your Website Like a Smart Library: Don't just have random pages. Think of a big main topic (like "everything about coffee"). Then, create smaller, detailed pages that link back to it (like "how to brew espresso," "types of coffee beans"). This tells Google's AI you're a true deep expert on the subject.
• Boost Your Brand's Overall Buzz: The AI looks at everything. So, keep your online reputation sparkling clean. Get good reviews, get mentioned by other reputable sites, and use videos and pictures on your site – the AI loves all kinds of media.
• Watch and Learn, Always: Don't just focus on old metrics. See if the AI is mentioning your brand, how much traffic you're getting from those AI-driven searches, and if those users are actually converting. Keep testing new ideas, because this AI thing is moving fast.

The digital game has changed. Google AI Mode isn't just coming; it's here. Adapt your strategy, focus on being truly helpful and authoritative, or risk fading into the digital background. Your move!

How do you think this will impact your brand or business?