Complete Guide: How to Use Every Programmatic SEO Tool & Platform

1. SEOmatic: Automated Page Generation Platform

What is SEOmatic?

SEOmatic is the #1 programmatic SEO platform that generates thousands of SEO-optimized pages automatically using spreadsheet data, AI prompts, and templates. It's the easiest way to get started with programmatic SEO.

How to Use SEOmatic

Step 1: Prepare Your Data

1. Create a Google Sheet or Excel file with your data
2. Structure columns for each variable (city, product, price, etc.)
3. Include meta data columns (title, description, URL slug)

Step 2: Upload to SEOmatic

1. Sign up for SEOmatic account
2. Create new project
3. Upload your spreadsheet or connect Google Sheets
4. Map your columns to SEOmatic variables

Step 3: Build Your Template

Use SEOmatic's visual editor to create your page template:

• Variables: Insert {{city}}, {{product}}, etc. from your data
• AI Prompts: Use AI to generate unique content per page
• Spin Syntax: Create variations like {{great|excellent|amazing}}

Step 4: Configure SEO Settings

• Set meta title pattern: "{{service}} in {{city}} - Best Prices 2025"
• Meta description with variables
• URL structure: /{{city-slug}}/{{service-slug}}
• Add schema markup (automatically generated)

Step 5: Publish

• Choose platform: WordPress, Webflow, or Shopify
• Connect via plugin or API
• Bulk publish (gradual rollout recommended)

2. Whalesync: The Essential Data Synchronization Tool

What is Whalesync?

Whalesync is the connector that powers programmatic SEO for thousands of companies. It creates a two-way sync between your data source (Airtable, Notion, Google Sheets) and your website (Webflow, Bubble, Framer).

How to Use Whalesync

Complete Setup Tutorial: Airtable → Webflow

Step 1: Prepare Airtable Base

Create Airtable base with:
- Primary field (e.g., "City Name")
- Slug field (URL-friendly: "new-york")
- Content fields (description, features, etc.)
- Meta fields (title, description)
- Status field (Draft/Published)

Step 2: Set Up Webflow CMS

1. Create CMS Collection in Webflow
2. Add fields matching your Airtable structure
3. Design collection template page
4. Set collection to "Staged" initially

Step 3: Connect with Whalesync

1. Sign up at whalesync.com
2. Click "Create Sync"
3. Select Airtable as source
4. Authorize and select your base + table
5. Select Webflow as destination
6. Choose your CMS collection

Step 4: Map Fields

• Airtable "City Name" → Webflow "Name"
• Airtable "Slug" → Webflow "Slug"
• Map all content and meta fields
• Set Status field to control publishing

Step 5: Configure Sync Settings

• Sync Direction: Two-way (recommended)
• Sync Frequency: Real-time or scheduled
• Publishing: Auto-publish when Status = "Published"
• Handling Deletes: Archive or delete in Webflow

Step 6: Test & Launch

1. Add 5 test rows in Airtable
2. Wait for sync (usually <1 minute)
3. Check Webflow CMS - items should appear
4. Preview pages to verify template
5. Set Status to "Published" to go live

3. Byword.ai: AI-Powered Bulk Content Generation

How to Use Byword.ai

Step 1: Upload Your Keywords

• Create CSV with target keywords (one per row)
• Upload to Byword.ai dashboard
• System processes and groups related keywords

Step 2: Configure Article Settings

• Article Length: 1,000-3,000 words
• Tone: Professional, casual, or technical
• Language: 10+ languages supported
• Include Images: Royalty-free images auto-generated

Step 3: Bulk Generate

1. Review keyword list (up to 1,000 at once)
2. Click "Generate Articles"
3. Wait 10-30 minutes for completion
4. Review output in dashboard

Step 4: Export & Publish

• Export as WordPress XML
• Export as HTML files
• Or use API for custom integration

4. Webflow: Visual Development Platform

Webflow CMS for Programmatic SEO

Step 1: Create CMS Collection

1. Go to CMS tab in Webflow
2. Click "Create New Collection"
3. Name it (e.g., "City Pages")
4. Add fields:
   • Name (automatically created)
   • Slug (automatically created)
   • Rich Text fields for content
   • Plain Text for short descriptions
   • Number fields for data
   • Reference fields for relationships

Step 2: Design Collection Template

1. Go to Pages → Collection Pages
2. Open your collection template
3. Design page using Webflow designer
4. Bind dynamic fields from CMS
5. Set up SEO settings (title, description, OG image)

Step 3: Configure SEO

• Meta Title: Use dynamic fields like "{{Name}} - Best Service 2025"
• Meta Description: Combine text + dynamic data
• URL Slug: Based on "Slug" field (auto-generated)
• Open Graph: Set social sharing image

Best Practices

• Limit to 10,000 CMS items per collection (Webflow limit)
• Use Whalesync for bulk data import from Airtable
• Enable staging before going live
• Use Webflow's built-in CDN for fast loading

5. Airtable: Database & Content Management

Airtable for Programmatic SEO

Recommended Base Structure

Table: "Pages"

Essential Fields:
1. Name (Single line text) - Primary field
2. Slug (Formula: LOWER(SUBSTITUTE(Name, " ", "-")))
3. Status (Single select: Draft/Review/Published)
4. Category (Single select or Link to another table)
5. Description (Long text)
6. Meta Title (Formula: Name & " - Company Name 2025")
7. Meta Description (Long text, 155-160 chars)
8. Publish Date (Date field)
9. Last Updated (Last modified time)

Content Fields:
10. Main Content (Long text)
11. Features (Long text or Multi-select)
12. Pricing (Number or Currency)
13. Images (Attachment field)

SEO Fields:
14. Target Keyword (Single line text)
15. Search Volume (Number)
16. Keyword Difficulty (Number 1-100)

Using Airtable AI

Airtable AI can generate content for each row:

1. Add AI field to your base
2. Configure prompt: "Write 200 words about {{Name}} in {{City}}"
3. Generate for all rows at once
4. Review and edit as needed

Views & Filters

• Published View: Filter Status = "Published"
• Draft View: Filter Status = "Draft"
• By Category: Group by Category field
• Recent Updates: Sort by Last Updated

6. Next.js: Developer Framework for Programmatic SEO

Next.js Static Site Generation (SSG) Tutorial

Step 1: Generate Paths

// app/[city]/[service]/page.tsx
import { getData } from '@/lib/data';

export async function generateStaticParams() {
  const data = await getData();

  return data.map((item) => ({
    city: item.citySlug,
    service: item.serviceSlug,
  }));
}

// This generates all URL combinations at build time

Step 2: Fetch Data

export default async function ServicePage({ params }) {
  const { city, service } = params;
  const pageData = await getPageData(city, service);

  return (
    <main>
      <h1>{pageData.title}</h1>
      <div dangerouslySetInnerHTML={{ __html: pageData.content }} />
    </main>
  );
}

Step 3: Add Metadata

export async function generateMetadata({ params }) {
  const { city, service } = params;
  const data = await getPageData(city, service);

  return {
    title: `${data.service} in ${data.city} - Best Prices 2025`,
    description: data.description,
    openGraph: {
      title: data.title,
      description: data.description,
    },
  };
}

Benefits of Next.js for Programmatic SEO

• Static generation = blazing fast performance
• Full control over templating and data
• Built-in image optimization
• Incremental Static Regeneration (ISR)
• Free hosting on Vercel

Conclusion

Each programmatic SEO platform serves different needs:

• Beginners: Start with SEOmatic or Whalesync + Webflow
• Content-focused: Use Byword.ai or Surfer AI
• No-code: Airtable + Webflow + Whalesync stack
• Developers: Next.js or custom solution

The key is choosing tools that match your technical skills and business needs. Start simple, then scale complexity as you grow.

Need Help Implementing These Tools?

I'm Claudio Tota, ex-Google consultant specializing in programmatic SEO. I've helped dozens of companies scale from 0 to millions of monthly visitors using these exact tools and strategies.

Book a FREE 30-minute consultation and I'll personally review your project, recommend the best stack, and show you exactly how to get started.

Schedule Free Consultation →

Claudio Tota

Ex-Google Consultant | Programmatic SEO Specialist

Published January 2025