Rewrite web content with exact character counts using GPT-4.1 and Google Sheets

Created by

isaWOW

Last update

Last update 5 days ago

Description

An AI-powered content rewriter that maintains exact character counts line-by-line while rewriting web pages for SEO. Fetches reference URL content, preserves layout-critical formatting, and logs detailed comparisons to Google Sheets—perfect for agencies rewriting competitor content while maintaining design consistency.

What this workflow does

This workflow solves a unique SEO challenge: rewriting web content while preserving exact character counts on every single line. When you need to rewrite a competitor's page or update your own content without breaking the layout, this automation fetches the reference URL, converts it to Markdown, and uses GPT-4.1 to rewrite marketing text, headings, and CTAs while maintaining the exact same character count as the original—down to the letter. The AI intelligently decides what to keep unchanged (form labels), what to skip entirely (URLs, footers), and what to rewrite (marketing content). A second AI agent then compares the original and rewritten versions line-by-line, verifying character counts and logging everything to Google Sheets for quality control.

Perfect for SEO agencies, content teams, and web developers who need to rewrite content without disturbing page layouts, CSS styling, or design templates that depend on specific text lengths.

Key features

Exact character count preservation: Every rewritten line matches the original's character count precisely—no approximations, no +/- 1 character deviations. If the original has 47 characters, the rewrite will have exactly 47 characters.

Smart content classification: The AI automatically categorizes each line into three actions: KEEP (form labels like Name, Email, Phone remain unchanged), SKIP (URLs and footers excluded entirely from output), or REWRITE (marketing content, headings, CTAs rewritten with exact length).

Line-by-line comparison analysis: A second AI agent compares original vs. rewritten content, creates structured JSON showing each change, verifies character and word counts match, and flags any discrepancies.

Google Sheets quality tracking: All comparisons logged to Google Sheets with columns for Old Text, AI Suggested Text, Old Text Length, and AI Suggested Text Length—enabling manual review and quality control.

Layout-safe rewriting: Preserves Markdown structure, maintains spacing, keeps technical elements intact—ensures the rewritten content fits perfectly into existing page designs and CSS frameworks.

Form-based workflow: Simple form interface with Client ID, Service Page Keyword, Instructions, and Reference URL—no coding needed to submit rewrite requests.

Dual GPT-4.1 agents: Uses two independent AI agents (rewriter and comparator) with GPT-4.1 for maximum accuracy and quality verification at every step.

How it works

1. Submit rewriting request via form

User fills a simple form with:

Client ID: Project identifier for tracking
Service Page Keyword: Target SEO keyword (optional)
Instruction: Specific rewriting guidance (e.g., "make it more professional")
Reference URL: The webpage to fetch and rewrite

2. Fetch reference webpage content

The workflow sends an HTTP POST request to the provided URL and retrieves the complete HTML source code of the page.

3. Convert HTML to Markdown

The HTML is converted to clean Markdown format, removing unnecessary tags while preserving structure, headings, lists, and text content. This makes it easier for the AI to process line-by-line.

4. AI rewrites content with exact character matching

The first AI Agent (powered by GPT-4.1) receives the Markdown content and processes it with ULTRA-STRICT rules:

Character counting rules:

Counts everything: letters, spaces, numbers, symbols, punctuation
Spaces are characters
Line breaks don't count
Case doesn't affect count

Decision logic for each line:

KEEP AS-IS: Simple form labels (Name, Email, Phone, Message), generic system messages, technical single words
SKIP COMPLETELY: All URLs (https://, http://, www.), all footers (copyright, legal links, disclaimers), navigation URLs, image paths
MUST REWRITE: Headings, marketing text, CTAs, service descriptions, menu items

Character-matching techniques:

Too short → Add words, expand contractions
Too long → Use shorter synonyms, use contractions
Exact match → Swap equal-length words

Verification checklist:

Every rewritten line matches original character count
All simple labels kept exactly
All URLs skipped
All footers skipped (no rewrite or modification)
Markdown structure preserved

If even 1 line has mismatched characters, the AI retries until it's perfect.

5. Compare original vs. rewritten content

A second AI Agent (also GPT-4.1) compares the original Markdown input with the rewritten output:

Breaks down both texts into individual sentences or meaningful phrases
Matches each line from original with its corresponding rewritten version
Verifies character and word counts match for each pair
Notes any skipped content (URLs, footers) with markers like "[SKIPPED - Footer/URL]"
Outputs structured JSON with comparison array

6. Parse comparison to structured format

The Structured Output Parser ensures the comparison JSON is valid and properly formatted:

{
  "comparisons": [
    {
      "old_text": "exact sentence from original",
      "ai_suggested_text": "corresponding sentence from rewritten version",
      "Old_text_count": "47",
      "ai_suggested_text_Count": "47"
    }
  ]
}

7. Split comparison into individual rows

The Split Out node takes the comparisons array and creates a separate item for each comparison, preparing it for Google Sheets insertion.

8. Log comparison to Google Sheets

Each comparison is written to Google Sheets as a new row with columns:

Old Text: Original line
AI Suggested Text: Rewritten line
Old Text Length: Character count of original
AI Suggested Text Length: Character count of rewritten

This creates a complete audit trail for manual review and quality verification.

Setup requirements

Tools you'll need:

Active n8n instance (self-hosted or n8n Cloud)
Google Sheets with OAuth access for comparison tracking
OpenAI API key (GPT-4.1 and GPT-4o-mini access)
Target website URL to rewrite

Estimated setup time: 20–25 minutes

Configuration steps

1. Connect Google Sheets

In n8n: Credentials → Add credential → Google Sheets OAuth2 API
Complete OAuth authentication
Create a tracking Google Sheet with columns:
- Old Text
- AI Suggested Text
- Old Text Length
- AI Suggested Text Length
Open "Log Comparison to Google Sheets" node
Select your Google Sheet and correct sheet tab
Verify column mapping matches your sheet structure

2. Add OpenAI API credentials

Get API key: https://platform.openai.com/api-keys
In n8n: Credentials → Add credential → OpenAI API
Paste your API key
Configure three OpenAI Chat Model nodes:
- "OpenAI GPT-4.1 Rewriting Model": Set to gpt-4.1, timeout 100000ms
- "OpenAI GPT-4.1 Comparison Model": Set to gpt-4.1, timeout 100000ms
- "OpenAI GPT-4o-mini Parser Model": Set to gpt-4o-mini
Verify all three nodes use your OpenAI credential

3. Copy form URL

Open "Submit Content Rewriting Request" node
Copy the Form URL
Share this URL with your team or clients for submitting rewrite requests

4. Customize AI rewriting rules (optional)

Open "Rewrite Content with Exact Character Count" node and edit the system message to:

Add more content types to KEEP unchanged
Define additional SKIP rules (e.g., specific footer patterns)
Adjust rewriting tone (formal, casual, technical)
Modify character-matching techniques

5. Test the workflow

Activate the workflow (toggle to Active)
Open the form URL
Fill in test data:
- Client ID: TEST_001
- Service Page Keyword: SEO services
- Instruction: Make it more professional
- Reference URL: https://example.com
Submit the form
Wait 1-3 minutes for processing (depends on content length)
Check Google Sheets for comparison results
Verify:
- All rewritten lines have matching character counts
- URLs and footers are skipped
- Form labels remain unchanged
- Marketing content is rewritten

6. Review and refine

Open your Google Sheets comparison log
Review the Old Text vs. AI Suggested Text columns
Check character count columns match
If any lines failed validation, review the AI's decision logic
Adjust the system prompt if needed for your specific use case

Use cases

SEO agencies rewriting competitor content: Analyze top-ranking competitor pages and rewrite them for your clients while preserving the exact layout that works. Character-count matching ensures the rewritten content fits perfectly into the same design templates.

Web designers updating legacy sites: Modernize old website copy without breaking existing CSS layouts that depend on specific text lengths. Maintain pixel-perfect designs while refreshing the message.

Content teams A/B testing variations: Create multiple versions of the same page with different wording but identical character counts. Test messaging changes without layout shifts affecting results.

Translation agencies adapting content: When translating from one language to another requires matching specific character limits (billboards, app interfaces, fixed-width layouts), this workflow helps maintain constraints.

E-commerce product descriptions: Rewrite product copy for different brands or markets while keeping descriptions at exact character counts required by platform templates or PIM systems.

Landing page optimization: Test different headlines, CTAs, and value propositions while ensuring each variation maintains the original's character count—preventing layout breaks on mobile or desktop.

Customization options

Adjust character count strictness

If your use case allows minor variations (+/- 2-3 characters), edit the rewriting agent's system message:

Change "EXACT SAME CHARACTER COUNT" to "within 3 characters"
Update verification rules to accept small deviations
Modify the comparison agent to flag only major discrepancies

Add more content types to KEEP

In the rewriting agent system message, expand the "KEEP AS-IS" list:

Company names
Product names
Legal disclaimers
Technical specifications
Date formats

Change output format

Instead of Google Sheets, route comparison data to:

Notion database (via HTTP Request to Notion API)
Airtable (via Airtable node)
Email report (via Email node with HTML table)
Slack notification (via Slack node with formatted message)

Add batch processing

Modify the form to accept multiple URLs at once:

Add a Text Area field for URL list (one per line)
Insert a Split Out node after form submission
Loop through each URL sequentially
Aggregate all comparisons into a single Google Sheet

Implement approval workflow

Add human review before finalizing rewrites:

After comparison analysis, send results to project manager via email
Include approve/reject buttons (using n8n Webhook URLs)
Only log approved rewrites to final Google Sheet
Store rejected versions in a separate "Needs Revision" sheet

Troubleshooting

Character counts don't match

AI struggling with specific lines: Some sentences are difficult to rewrite at exact length. Check the Google Sheets log to identify which lines failed. Manual rewrite may be needed for complex technical content.
Special characters counted wrong: Ensure the AI is counting all special characters, emojis, and Unicode symbols. Edit the system prompt to emphasize counting everything.
Markdown formatting interfering: Markdown syntax (**, ##, etc.) shouldn't be counted as characters. Verify the AI understands to count only visible text.

URLs or footers appearing in rewritten output

SKIP rules not working: The AI didn't recognize a URL or footer pattern. Edit the system prompt to add specific patterns to the SKIP list (e.g., "Privacy Policy", "Terms of Service").

Comparison agent fails to parse output

Invalid JSON format: The comparison agent must output pure JSON with no markdown. Check the "Compare Original vs Rewritten Content" node's system message emphasizes "Output ONLY the JSON object—no markdown, no extra text."
Structured parser timeout: Large content with 100+ comparison pairs may exceed timeout. Increase timeout in "OpenAI GPT-4o-mini Parser Model" node or split content into smaller chunks.

Google Sheets not updating

OAuth expired: Re-authenticate Google Sheets credentials in n8n.
Sheet permissions: Verify the connected Google account has edit access.
Column names mismatch: Ensure sheet column headers exactly match the node mapping (case-sensitive).
Row limit reached: Google Sheets has a 10 million cell limit. Create a new sheet if approaching limits.

Rewriting takes too long

Timeout errors: Large webpages (10,000+ words) may exceed the 100-second timeout. Increase timeout in both GPT-4.1 model nodes or split content into sections.
OpenAI API rate limits: If processing many requests simultaneously, you may hit rate limits. Add a delay between submissions or upgrade OpenAI plan.

Form labels being rewritten incorrectly

AI not recognizing labels: Add specific examples to the KEEP list in the system prompt (e.g., "Full Name", "Phone Number", "Email Address").
Context confusion: If form labels are embedded in marketing text, the AI may rewrite them. Improve the prompt to emphasize preserving all form-related text.

Resources

Support

Need help or custom development?

📧 Email: [email protected]
🌐 Website: https://isawow.com/