How I Bulk-Updated 200 Webflow CMS Items Using Claude MCP

Two hundred CMS items. Missing SEO meta titles. Inconsistent slugs. Excerpts that were either empty or copy-pasted from the first paragraph of each post. A client asked us to fix it before their site relaunch. Manual approach: two full days of work. Actual time taken using Claude MCP: 90 minutes.

This is the exact workflow. You can apply it to any bulk CMS operation on Webflow.

Key Takeaways

• Claude MCP can read your entire CMS schema and item list in seconds — no manual export needed
• Prompt Claude to audit, generate, and stage updates before committing any changes
• The review-then-push workflow keeps you in control while eliminating the manual grind
• This approach works for SEO metadata, slug standardisation, excerpt generation, field population, and content freshness sweeps
• 90 minutes replaced what would have been 2 full days of copy-paste work

The Problem: What 200 Messy CMS Items Looks Like

The client had a property listings site built on Webflow CMS. Two hundred listings, each with a name, description, location, and price field. The site had been managed by an in-house team who added listings manually over two years — different people, no naming conventions, no SEO discipline.

The issues: SEO meta titles were either blank or duplicated the listing name without any keyword optimisation. Slugs were inconsistent — some used hyphens, some had underscores, some had random numbers appended. Excerpts were blank on 60% of items. The client needed all of it fixed before a relaunch campaign.

Step 1: Let Claude Read the Schema

The first prompt is always the same for any CMS audit task. Open Claude Desktop with Webflow MCP connected and type:

"List all CMS collections on this site and show me the field schema for the Listings collection, including all field names, types, and slugs."

Claude calls the Webflow Data API, returns the full schema in seconds. You now have a complete picture of every field, its type, and its slug — the technical names you'll need to reference in subsequent prompts.

Step 2: Pull All Items Into Context

Next prompt:

"List all items in the Listings collection. For each item, show me the item ID, name, current slug, current SEO meta title, current SEO meta description, and whether the excerpt field is populated."

Claude fetches and formats the full item list. With 200 items, it returns them in batches. You now have a complete audit of the current state — without opening a single spreadsheet.

Step 3: Generate the Updates

This is where the real leverage is. Instead of writing 200 SEO titles manually, you prompt Claude to generate them:

"For each listing item, generate an SEO meta title that follows this format: '[Listing Name] — [Location] Property | [Client Brand]'. Keep each title under 60 characters. If the listing name plus location exceeds the limit, abbreviate the location. Return the results as a table with: item ID, current title, proposed title, character count."

Claude generates the full table. You review it. You look for anything that doesn't read right — abbreviations that lost meaning, titles that sound robotic, edge cases. You flag them, ask Claude to revise specific rows, and approve the rest.

Same approach for excerpts:

"For all items where the excerpt field is empty, write a 2-sentence excerpt based on the listing name, location, and description fields. Make each excerpt feel warm and specific — like a helpful introduction, not a keyword dump."

Step 4: Push the Updates

Once you've reviewed and approved the proposed changes, push them:

"Update the SEO meta title and excerpt fields for all items in the approved list. Use the values from the table we just reviewed. Create updates as staged changes — don't publish yet."

Claude runs through the update calls. For 200 items it takes a few minutes. When it's done, you get a confirmation with the count of items updated and any errors flagged.

Then you do a spot check in the Webflow Designer — open 5–10 random items, verify the fields look right — and publish when you're satisfied.

Step 5: Standardise the Slugs

Slug standardisation is more careful work because changing slugs breaks existing URLs. We handled it with a staged approach:

"Review all item slugs in the Listings collection. Identify any that contain underscores, uppercase letters, or trailing numbers that appear to be system-generated rather than intentional. For each flagged slug, propose a cleaned version using only lowercase letters and hyphens. Return as a table with item ID, current slug, proposed slug, and a flag for whether a 301 redirect will be needed."

Claude returned 47 items needing slug cleanup. We reviewed, confirmed the redirect plan with the client, and pushed the changes with the redirect rules staged separately.

What This Workflow Replaces

The manual version of this task involves: exporting all CMS items to a spreadsheet, writing or editing 200 SEO titles one by one, writing 120 excerpts from scratch, copy-pasting updates back into Webflow one item at a time, and checking every slug manually.

Experienced estimate: 14–16 hours of focused work. With Claude MCP: 90 minutes of mostly review time while Claude does the generation and pushing.

That's not a marginal improvement. It's a different category of work. The human job shifts from execution to oversight — which is exactly where the valuable judgment should sit.

Frequently Asked Questions

Does Claude MCP work on CMS sites with hundreds of items?

Yes. The Webflow API supports pagination and Claude handles batching automatically. We've run this workflow on collections with 500+ items without issues.

Can Claude accidentally overwrite good content?

Only if you tell it to. The workflow above stages all changes for review before pushing. Claude never writes to your CMS without explicit instruction in that prompt.

Do I need a developer to run this workflow?

No. If you can connect Claude Desktop to Webflow (a 10-minute setup), you can run this workflow. It's plain English prompts against your live CMS.

Ready to run this on your own Webflow site? We offer MCP workflow sessions where we set up and run bulk operations with you, so you learn the process while the work gets done.