Programmatic SEO 101
One template → hundreds of pages, automatically
Traditional SEO means writing one article at a time. Programmatic SEO means building a system: define a template, feed it keywords from a spreadsheet, generate hundreds of optimized pages automatically. Used by Tripadvisor, Zapier, and NerdWallet to dominate search results. Now any solo founder can do the same thing — with AI.
Time
45 min
Level
Intermediate
Outcome
A working keyword → article pipeline
What programmatic SEO actually is
Normal SEO: 1 keyword, 1 article. Programmatic SEO: 1 template × N keywords = N pages. Instead of writing each page by hand, you build a system that generates them from a pattern. Here is what that looks like at scale.
Zapier
"[App A] + [App B] integration"
Thousands of pages, one for every app combination in their ecosystem. Each page answers the same question for a different pair of tools.
NerdWallet
"Best credit cards for [type of person]"
Hundreds of audience-specific comparison pages. Same template, different audience segment, different ranking opportunity.
Tripadvisor
"Best restaurants in [city]"
Location-based pages for every city in the world. One content structure scaled to cover virtually unlimited geography.
You do not need their scale.
Even 50–200 pages on a tight niche can drive significant organic traffic. The strategy is the same whether you publish 100 pages or 100,000.
When to use it — and when not to
Programmatic SEO is powerful for the right use case. It is the wrong tool for others.
Good fit
Repeatable content with variable slots
- ✓Local service businesses (lawn care, plumbing, cleaning)
- ✓SaaS products with many integrations or use cases
- ✓E-commerce with location or category combinations
- ✓Comparison sites and directory-style content
- ✓"Best X for Y" content with many audience segments
Not a fit
Content that needs a unique human take
- ×Personal brands and thought leadership content
- ×News, opinion, or timely editorial content
- ×Products that require a unique human narrative
- ×Anything where the value is in a single expert voice
What you will need
Four things. No code required.
A keyword pattern
"Best [X] for [Y]", "[Tool] alternatives", "[City] [Service]" — a repeatable structure with at least one variable slot.
A data source
Google Sheets, Airtable, or a simple CSV. Each row becomes one page. You do not need a database.
A content template
A Claude prompt that takes a row of data and generates a complete, useful article. One prompt, many outputs.
A publishing method
WordPress, Webflow CMS, Notion export, or a Next.js static site. Any system that can ingest content from a spreadsheet.
Five steps from keyword to published page
Follow these in order. Do not skip step 1 — the keyword pattern is the foundation everything else is built on.
Find your keyword pattern
The template that everything else depends on
The core of programmatic SEO is a repeatable keyword structure. You need a pattern with at least one variable — a slot that changes for each page while the surrounding phrase stays the same. Use Claude to discover which patterns fit your niche and estimate their traffic potential.
Prompt for Claude →
I have a [type of business/website]. Help me find a programmatic SEO keyword pattern. Tell me: 1. Three keyword patterns that would work for my niche (format: "[Variable A] + [fixed phrase] + [Variable B]") 2. An example of 5 keywords each pattern would generate 3. Estimated search volume range (low/medium/high) and competition level for each pattern 4. Which pattern you recommend I start with and why My niche: [describe your business or content focus] My target audience: [who they are]
Build your keyword spreadsheet
One row = one page
Once you have a pattern, list every variation in a spreadsheet. Each row becomes one published page. Google Sheets works perfectly — you do not need a database. Here is an example structure for a local lawn care business:
City | Service | Modifier | Target slug -----------+------------+--------------+----------------------------- Austin | lawn care | affordable | /lawn-care-austin-affordable Dallas | lawn care | best | /lawn-care-dallas-best Houston | lawn care | same-day | /lawn-care-houston-same-day San Antonio| lawn care | organic | /lawn-care-san-antonio-organic Fort Worth | lawn care | residential | /lawn-care-fort-worth-residential
Start with 20–50 rows to test your template before scaling to hundreds.
Write your content template
The Claude prompt that generates each article
Your template is a Claude prompt that takes one row of spreadsheet data and generates a complete, useful article. The variables (in curly braces) get replaced with the actual values from each row. Here is an example for the lawn care pattern:
Content template prompt →
Write a 600-word SEO article for the following page:
Target keyword: [City] lawn care services
City: {{City}}
Modifier: {{Modifier}}
Business name: [Your Business Name]
Requirements:
- H1: Include the target keyword naturally
- H2 subheadings: 3–4 covering: why choose local, what to look for, cost expectations, how to get started
- Each section: 100–120 words
- Tone: helpful, local, trustworthy — like a knowledgeable neighbor
- Include: one mention of the city's climate or geography
- End with: a clear call to action to contact [Business Name]
- No fluff, no keyword stuffing. Write for the reader first.
Output: Full article in markdown format.Generate your pages
Manual for testing, automated for scale
Two ways to run the pipeline. Start manual to validate your template, then automate when you are confident it works.
Manual
Paste 10–20 rows into Claude, fill in the template variables, and generate articles one at a time. Best for validating that your template produces good output before investing in automation.
Automated
Use n8n or Make to loop through spreadsheet rows, hit the Claude API with your template, and save each output to a Google Doc or Notion page automatically.
Ready to automate? See the n8n + Claude automation guide →
Publish and index
Getting pages live and discovered by Google
Publishing at scale requires a CMS that can ingest content in bulk. Once live, indexing speed matters — the sooner Google finds your pages, the sooner they can rank.
- Use a CMS with CSV import (Webflow, WordPress) or generate static HTML files with a build script
- Submit your sitemap to Google Search Console immediately after publishing
- Internal link between related pages (city A to city B, category to subcategory)
- Add schema markup (LocalBusiness or Article) — Claude can write this for you in seconds
SEO checklist for every page
Run every generated page through this before you publish. Build it into your content template so Claude handles most of it automatically.
- ✓
Target keyword in H1 (naturally, not stuffed)
- ✓
Target keyword in meta title and meta description
- ✓
At least one H2 with a related secondary keyword
- ✓
400–800 words of genuinely useful content
- ✓
Internal link to at least one related page
- ✓
Image with alt text containing the keyword
- ✓
Page load time under 2 seconds
- ✓
Mobile-friendly layout
Realistic timeline
Programmatic SEO is not a quick win. Here is what to expect.
Month 1–3
Indexing
Google crawls and indexes your pages. Little traffic. This phase feels like nothing is working. It is.
Month 3–6
Early traction
Pages start ranking for long-tail keywords. Traffic trickles in. You will see your first organic visitors.
Month 6–12
Compounding growth
If the template works, you see compounding growth. Some pages climb to page one. The system pays off.
Programmatic SEO is a slow burn that pays off.
Most people quit too early — usually around month two when traffic is flat and patience runs thin. Give it six months. If your template produces genuinely useful content and your keyword pattern has real demand, the compounding will come.
What to explore next
Programmatic SEO pairs well with these guides and tools.
Build alongside
other marketers.
Ask questions, share what you're building, and get unstuck faster. The community moves at the pace of people who are actually shipping.
Ask anything
No question too basic
Share your builds
Real feedback from peers
Early access
New guides first
Free to join · No credit card · Unsubscribe any time