A solo founder's tutorial for eliminating SEO busywork without an engineering sprint or paid tools
Learn how to build three SEO automations — keyword alerts, a self-updating content audit, and an automated content planning pipeline — using free tools you already have. Cut your weekly SEO time down to a focused 30-minute execution window.
TL;DR
Automate research, not execution - Set up three automations (keyword alerts, content audit tracker, AI content planner) that tell you what to do each week, then spend 30 minutes doing it.
Use Google Search Console + Sheets + Zapier - No expensive tools needed. A free stack of Search Console data, Google Sheets formulas, Apps Script email triggers, and a Zapier-to-ChatGPT workflow handles all the analysis.
Focus on "almost ranking" keywords (positions 8-20) - These are your highest-leverage targets where a small content effort yields disproportionate ranking gains.
Flag declining pages automatically - Conditional formatting in your audit tracker turns pages red when clicks drop 20%+, so you know exactly what to refresh without manually checking every URL.
Ship one SEO action per week, every week - The system's value isn't sophistication. It's consistency. 52 small SEO actions per year compounds into meaningful organic growth for solo founders.
What You'll Build: A 3-Task SEO Automation System That Runs Without You
By the end of this tutorial, you'll have three pieces of SEO automation running on autopilot: automated keyword opportunity alerts, a self-updating content audit tracker, and an automated content planning pipeline that tells you exactly what to write next. No engineering sprint required. No developer time blocked.
Your success criteria are simple. After setup, your weekly SEO time drops from "I don't even know where to start" to a focused 30-minute execution window. You'll open your laptop on Monday morning to a prioritized list of exactly what to publish, what to update, and which competitors just moved. Everything else runs in the background.
This system is built for solo founders shipping product and doing marketing simultaneously. If you have a growth team, this tutorial isn't for you. If you're trying to reach your first 100 users and can't afford to spend half your week on SEO busywork, keep reading.
Prerequisites and Setup Checklist
Before you start, confirm you have the following ready. Missing one of these will stall you mid-setup.
Google Search Console connected to your domain (free, takes 10 minutes if not done)
A Google account with access to Google Sheets and Google Apps Script
A free or low-tier account on one SEO tool: Google Search Console is the minimum; Ahrefs Webmaster Tools (free) or Ubersuggest (freemium) adds depth
ChatGPT, Claude, or any LLM you already use for writing
Zapier or Make.com free tier for connecting the pieces
An existing website with at least 5 published pages (blog posts, landing pages, or docs)
Time estimate: 90 minutes for initial setup. After that, 30 minutes per week to act on what the system surfaces. Potential blocker: if your site isn't in Google Search Console yet, do that first and wait 48 hours for data to populate before proceeding.
Why This Approach Works for Solo Founders
Most SEO automation guides assume you have a content team, a dev team, and a quarterly planning cycle. You don't. You have Tuesday evening and maybe Saturday morning. That constraint changes everything about which tasks you automate.
As SEO strategist Tom Critchlow has emphasized, SEO automation should start with data gathering and opportunity identification before scaling into execution. You pilot on a small URL sample and use judgment to decide what to automate first. That's the "three tasks on autopilot" philosophy: automate the research and prioritization, keep the human judgment for the final 30 minutes of execution.
The numbers back this up. Businesses using SEO automation reduced campaign timelines by 34%, and companies report 28% lower operational SEO costs. For a solo founder, that translates directly to hours reclaimed for product work. The approach here is lean SEO: automate inputs, execute outputs manually, measure what matters.
Step 1: Set Up Automated Keyword Opportunity Alerts
Your first automation replaces the "stare at keyword tools wondering what to target" loop. You'll create a system that emails you weekly with keywords your site is almost ranking for (positions 8-20), so you know exactly where a small effort yields big results.
Action: Open Google Search Console and navigate to Performance > Search Results. Set the date range to the last 28 days. Click "Export" and choose Google Sheets.
In the exported sheet, create a new tab called "Opportunities." Add this formula in cell A1 to filter queries where your average position is between 8 and 20 and impressions exceed 50:
=FILTER(Queries!A:D, Queries!D >= 8, Queries!D = 50)
This gives you keywords where you're visible but not clicking. These are your highest-leverage content targets.
Automate it: In Google Sheets, go to Extensions > Apps Script. Paste this script to email yourself the opportunity list every Monday:
function emailOpportunities() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Opportunities');
var data = sheet.getDataRange().getValues();
var body = 'Your SEO opportunities this week:\n\n';
for (var i = 0; i < Math.min(data.length, 10); i++) {
body += data[i][0] + ' | Pos: ' + data[i][3] + ' | Impressions: ' + data[i][1] + '\n';
}
MailApp.sendEmail('YOUR_EMAIL@gmail.com', 'Weekly SEO Opportunities', body);
}
Set the trigger: In Apps Script, click the clock icon (Triggers), add a new trigger for emailOpportunities, set it to "Time-driven" > "Week timer" > "Every Monday between 7am-8am."
Expected result: Every Monday, you get an email listing up to 10 keywords you're close to ranking for. Checkpoint: Run the function manually once. If you get the email, the automation works.
Common failure: The Opportunities tab is empty. This means either your site has fewer than 28 days of Search Console data, or no queries match the filter criteria. Lower the impressions threshold to 10 and widen the position range to 5-30.
Step 2: Build a Self-Updating Content Audit Tracker
Your second automation answers the question: "Which of my existing pages need attention?" Instead of manually checking each page's performance, you'll build a tracker that flags declining pages automatically.
Action: Create a new Google Sheet called "Content Audit Tracker." In the first tab, list every URL on your site with these columns: URL, Title, Last Updated Date, Current Clicks (28d), Previous Clicks (28d), Change %.
Export your Search Console Pages data for the last 28 days and the previous 28 days. Paste each into separate tabs ("Current" and "Previous"). In your main tracker, use VLOOKUP to pull clicks for each URL from both tabs:
=VLOOKUP(A2, Current!A:B, 2, FALSE)
=VLOOKUP(A2, Previous!A:B, 2, FALSE)
=((D2-E2)/E2)*100
Add conditional formatting: Select the Change % column, go to Format > Conditional formatting, and set cells to turn red when the value is less than -20. These are your pages that need a content refresh.
Automate the data refresh: Use Search Console's API with Apps Script, or use a simpler method: set a recurring calendar reminder every two weeks to re-export and paste the data. The formatting and formulas do the analysis automatically.
Expected result: A color-coded spreadsheet that shows you at a glance which pages are growing (green), stable (neutral), or declining (red). Checkpoint: You should see at least 2-3 pages flagged in red or green after your first data paste.
Common failure: VLOOKUP returns #N/A errors. This happens when URL formats don't match between tabs (trailing slashes, http vs https). Normalize URLs by adding a helper column: =SUBSTITUTE(SUBSTITUTE(A2,"https://",""),"http://","") and VLOOKUP against those instead.
Step 3: Create an Automated Content Planning Pipeline
This is where AI SEO earns its keep. You'll connect your keyword opportunities and content audit data to an LLM that generates a prioritized content brief every week. No more staring at a blank editorial calendar.
Action: Open Zapier (or Make.com). Create a new Zap with this workflow:
Trigger: Schedule (every Monday at 9am)
Step 2: Google Sheets > Get Spreadsheet Rows from your "Opportunities" tab (limit to top 5 rows)
Step 3: Google Sheets > Get Spreadsheet Rows from your "Content Audit Tracker" where Change % < -20 (declining pages)
Step 4: ChatGPT (Zapier integration) > Send this prompt:
You are an SEO content planner for a solo SaaS founder. Based on these inputs, create a prioritized weekly content plan with exactly 2 actions.
Keyword opportunities (almost ranking):
{{Step 2 data}}
Declining pages that need refresh:
{{Step 3 data}}
For each action, provide:
1. What to do (write new post OR refresh existing page)
2. Target keyword
3. Suggested title
4. 3 subheadings to cover
5. Estimated time (15min, 30min, or 45min)
Prioritize refreshes over new content when a page has lost more than 30% traffic.
Step 5: Email (send the ChatGPT output to yourself) OR Google Sheets (append to a "Weekly Plans" tab)
Expected result: Every Monday, you receive a content brief with exactly two tasks, prioritized by impact. One might say "Refresh your /pricing-guide page targeting 'saas pricing models' (estimated 30 minutes)." The other might say "Write a new 800-word post targeting 'how to track user signups' (estimated 45 minutes)."
Checkpoint: Run the Zap manually once. Verify the ChatGPT output is specific and actionable, not generic filler. If the output is vague, add more context to the prompt about your product and audience.
Common failure: Zapier's ChatGPT step returns an error or timeout. This usually means the input data is too large. Limit the Opportunities tab pull to 5 rows and the declining pages pull to 3 rows. Shorter inputs produce better, faster outputs.
Step 4: Add Competitor Movement Monitoring
You need to know when a competitor publishes something targeting your keywords. This doesn't require expensive tools.
Action: Go to Google Alerts. Create one alert for each of your top 3 target keywords. Set delivery to "once a week" and "only the best results." Create one additional alert for each competitor's brand name.
For deeper competitor analysis, set up a free Ahrefs Webmaster Tools account and check the "Competing domains" report monthly. Note which keywords competitors rank for that you don't. Add these to your Opportunities sheet manually.
Expected result: Weekly email digests showing new content in your keyword space. When a competitor publishes a guide targeting your keyword, you'll know within a week instead of discovering it three months later when your rankings drop.
Checkpoint: After creating alerts, you should receive your first digest within 7 days. If you get zero results, your keywords might be too niche. Broaden the alert terms slightly.
Step 5: Wire the Execution Loop Together
The four automations above generate inputs. This step creates your weekly execution ritual so those inputs actually become published content.
Action: Block one 30-minute window per week on your calendar. Label it "SEO Sprint." During this window, you do exactly three things:
Minutes 1-5: Read your automated content plan email. Pick the single highest-priority task.
Minutes 5-10: If it's a content refresh, open the declining page and update the intro, add a new section addressing the target keyword, and update the "last modified" date. If it's new content, paste the brief into your LLM and generate a first draft.
Minutes 10-30: Edit, add internal links, and publish. For a faster content creation workflow, you can follow a 45-minute content shipping sprint when you have more time.
If you're using a tool like heycatch, your daily growth plan already surfaces which SEO tasks to prioritize based on your current traction stage, which can replace or supplement the manual prioritization step above.
Expected result: One piece of SEO work ships every week. That's 52 pieces per year, which puts you ahead of 90% of solo founders who publish sporadically. Checkpoint: After 4 weeks, check Search Console. You should see impressions trending upward for at least one of your target keywords.
Step 6: Set Up Basic SEO Performance Tracking
You need to know if this system is working without spending time building dashboards. One automated report handles this.
Action: In your Content Audit Tracker Google Sheet, add a "Monthly Summary" tab. Each month, record these four numbers from Search Console:
Total clicks (last 28 days)
Total impressions (last 28 days)
Number of keywords in positions 1-10
Number of pages receiving at least 1 click
Set a monthly calendar reminder to spend 5 minutes updating these four cells. Over three months, you'll see clear trend lines. If clicks are flat but impressions are rising, your content is getting seen but needs better titles and meta descriptions. If both are rising, the system is working.
Common failure: Founders track too many metrics and get overwhelmed. Four numbers, once a month. That's it. Agencies save 12+ hours per week on SEO reporting through automation. You're not an agency. You need signal, not dashboards.
Configuration and Customization
Several variables in this system should be adjusted based on your situation. Here are the defaults and when to change them.
Position filter range (8-20): This is the default for the keyword opportunity alert. If your site is brand new with fewer than 20 indexed pages, widen this to 5-50. You'll have fewer "almost ranking" keywords and need a broader net.
Impressions threshold (50): Lower this to 10 if you're in a niche market. Raise it to 200 if you're in a competitive space and want to focus only on high-volume terms.
Decline threshold (-20%): This flags pages losing more than 20% of clicks. For newer sites with volatile rankings, set this to -35% to avoid false alarms.
Content plan frequency (weekly): If you can only publish twice a month, change your Zapier trigger to biweekly. The system adapts.
Number of content actions per week (2): Change this in the ChatGPT prompt. If you have a cofounder helping with content, bump it to 3. If you're deep in a product sprint, drop it to 1.
Must-change setting: Replace YOUR_EMAIL@gmail.com in the Apps Script with your actual email. Everything else works with the defaults for a typical early-stage SaaS site.
Verification and Testing
Run through this checklist to confirm everything is working before you rely on the system.
Test 1: Manually run the Apps Script
emailOpportunitiesfunction. Verify you receive an email within 2 minutes with at least 1 keyword listed.Test 2: Check your Content Audit Tracker. Confirm that at least one URL shows conditional formatting (red or green). If all cells are neutral, your site may be too new for meaningful change data.
Test 3: Run your Zapier workflow manually. Confirm the ChatGPT step produces a specific, actionable brief with titles and time estimates, not generic advice.
Test 4: Verify Google Alerts are active by visiting google.com/alerts and checking your alert list.
Edge case to verify: What happens when your Opportunities tab returns zero rows (no keywords in positions 8-20)? The Apps Script should still send an email, just with an empty list. Your Zapier workflow should still run, but the ChatGPT output will focus entirely on content refreshes. Confirm this works by temporarily clearing the Opportunities tab and running the Zap.
Common Errors and Fixes
"Apps Script authorization required" popup
Symptom: Script won't run, asks for permissions. Cause: Google requires you to authorize Apps Script the first time it accesses Gmail. Fix: Click "Review Permissions," select your Google account, click "Advanced" > "Go to [project name] (unsafe)," then "Allow." This only happens once.
Zapier ChatGPT step produces generic output
Symptom: The content plan says things like "Write about your product" without specifics. Cause: The input data from Google Sheets isn't being passed correctly into the prompt. Fix: In Zapier's ChatGPT step, click on the prompt field and verify the dynamic data fields (from Steps 2 and 3) are inserted. They should appear as blue tokens, not plain text placeholders.
Search Console shows zero data
Symptom: Exported sheets are empty. Cause: Your site was recently added to Search Console and hasn't accumulated data yet. Fix: Wait 5-7 days after verification. In the meantime, use Ahrefs Webmaster Tools for initial keyword data. Also confirm you verified the correct property (domain vs. URL prefix).
Google Alerts sending irrelevant results
Symptom: Alerts include news articles and forum posts unrelated to your niche. Cause: Alert terms are too broad. Fix: Use quoted phrases ("saas onboarding checklist" instead of saas onboarding checklist) and set the source filter to "Blogs" instead of "Automatic."
Content audit shows all pages declining
Symptom: Every page is flagged red. Cause: Seasonal traffic dip, Google algorithm update, or comparison period includes an anomalous spike. Fix: Compare against a 90-day window instead of 28 days. If the decline is real and site-wide, the issue is likely technical (check for indexing errors in Search Console's Pages report). For a deeper audit of whether your content pipeline is actually hurting revenue, review your automation setup for misconfiguration signals.
Next Steps and Extensions
With your three-task system running, you've eliminated the biggest time sink in solo-founder SEO: deciding what to do. Here's how to extend this foundation.
Add internal linking automation: Use Screaming Frog's free version (500 URL limit) to crawl your site monthly and identify orphan pages with zero internal links. Add linking tasks to your weekly content plan.
Layer in AI search optimization: As roughly 60% of searches now yield no clicks, optimizing for AI search citations becomes critical. Follow a structured approach to convert your build artifacts into AI-search-optimized content.
Scale to a 7-day growth system: Once SEO busywork is automated, expand your automation to cover outreach, community monitoring, and performance tracking with a full AI agent execution workflow.
The SEO automation tools market is projected to reach $1.5 billion by 2028. The tools will keep getting better. But the advantage isn't in the tools. It's in having a system that runs before you open your code editor, so your limited time goes to execution instead of planning.
Frequently Asked Questions
What is an AI SEO workflow and how does it work?
An AI SEO workflow connects your search performance data (from Google Search Console or similar tools) to an LLM like ChatGPT through an automation platform like Zapier. The AI analyzes your keyword positions, traffic trends, and content gaps, then produces a prioritized action plan. You execute the plan manually. The AI handles the analysis and prioritization that would otherwise take hours of spreadsheet work.
How much time does this SEO automation system actually save?
The initial setup takes about 90 minutes. After that, the system reduces your weekly SEO decision-making to roughly 5 minutes of reading automated reports, plus 25-30 minutes of execution. Without automation, most solo founders either spend 3-4 hours per week on SEO research and planning, or (more commonly) skip SEO entirely because the overhead feels too high. 65% of marketers now automate at least half of their SEO tasks, and solo founders benefit even more from this approach because their time is more constrained.
Do I need coding skills to set this up?
Minimal. The Google Apps Script in this tutorial is copy-paste. Zapier and Make.com use visual, no-code workflow builders. The only technical requirement is comfort with Google Sheets formulas like VLOOKUP and FILTER. If you've built a SaaS product, you have more than enough technical ability for this setup.
When is the best time to refresh SEO content using AI?
Refresh content when your Content Audit Tracker flags a page with a 20% or greater decline in clicks over 28 days. For proactive maintenance, refresh your highest-traffic pages every 90 days with updated statistics, new sections, and improved internal linking. The automated system in this tutorial surfaces declining pages automatically, so you don't need to guess timing.
What are the common pitfalls when implementing an AI SEO workflow?
The three most common mistakes are: automating too much at once (start with three tasks, not thirty), trusting AI output without editing (always review generated content briefs for relevance), and tracking too many metrics (four numbers monthly is sufficient for a solo founder). Another pitfall is automating execution before automating research. Get your data gathering and prioritization automated first, then consider automating content generation later.
Can this system work for a brand-new website with no traffic?
Partially. The keyword opportunity alerts require at least 4-6 weeks of Search Console data to surface useful results. The content audit tracker needs two comparison periods (about 8 weeks of data). For brand-new sites, start with the competitor monitoring (Step 4) and automated content planning (Step 3) using competitor keywords as input instead of your own Search Console data. The system becomes fully functional once your site has 60+ days of indexed history.