Content Audit Workflow

Automatically audit your website content at scale

What you’ll build

A workflow that automatically audits all pages on your website, analyzing content quality, SEO elements, and providing AI-powered recommendations.

Time to build: 15 minutes

Nodes used: Web Scraper, Loop, LLM, Google Sheets

The problem

Manual content audits are time-consuming:

• Crawling hundreds or thousands of pages
• Extracting titles, metas, headings
• Analyzing content quality
• Compiling results into a spreadsheet

This workflow automates the entire process.

Workflow overview

graph LR
    A[URL List] --> B[Loop]
    B --> C[Web Scraper]
    C --> D[LLM Analysis]
    D --> E[Google Sheets]

Step-by-step guide

Step 1: Prepare your URL list

First, gather the URLs you want to audit.

Option A: Use a Google Sheet with your URLs

Option B: Scrape your sitemap

For this guide, we’ll use a Google Sheet with URLs in column A.

Step 2: Create the workflow

1. Click New Workflow in the Studio
2. Name it “Content Audit”

Step 3: Add the data source

Step 4: Set up the loop

Step 5: Scrape each page

The Web Scraper extracts:

• Page title
• Meta description
• All headings (H1-H6)
• Main content text
• Word count

Step 6: Analyze with AI

Analyze this webpage for SEO and content quality.

URL: {{$url}}
Title: {{$title}}
Meta Description: {{$metaDescription}}
Word Count: {{$wordCount}}
Content: {{$content}}

Provide:
1. SEO Score (1-10)
2. Content Quality Score (1-10)
3. Key Issues (bullet points)
4. Recommendations (bullet points)

Format as JSON:
{
  "url": "",
  "seo_score": 0,
  "content_score": 0,
  "issues": [],
  "recommendations": []
}

Step 7: Save results

[[
  "{{url}}",
  "{{seo_score}}",
  "{{content_score}}",
  "{{issues}}",
  "{{$recommendations}}"
]]

Complete workflow

Your final workflow should look like this:

Google Sheets (URLs) 
    → Loop 
        → Web Scraper 
        → LLM Analysis 
        → Google Sheets (Results)

Sample output

Customization options

Add more metrics

Extract additional data:

H1 count: {{$h1Count}}
Image count: {{$imageCount}}
Internal links: {{$internalLinks}}
External links: {{$externalLinks}}

Use competitor analysis

Add a Semrush node to compare with top-ranking pages:

graph LR
    A[Web Scraper] --> C[LLM Compare]
    B[Semrush Top URLs] --> C
    C --> D[Results]

Check YourTextGuru scores

Add content optimization scoring:

Loop → Web Scraper → YourTextGuru Score → LLM → Sheets

Best practices

Rate limiting

When scraping many pages:

1. Add delays between requests (2-3 seconds)
2. Respect robots.txt
3. Process in batches of 50-100

Error handling

Add a Conditional node to handle:

• 404 pages
• Timeout errors
• Empty content

If WebScraper_0.status != 200
  → Log error and continue
Else
  → Process normally

Scheduling

Set up weekly audits:

1. Go to Workflow Settings
2. Enable Schedule
3. Set to run weekly (e.g., Monday 6 AM)

Results you can expect

Next steps