AI SEO content for every listing
New properties in Copper CRM are researched with an Apify scraper, written up by Claude as an SEO blog post and saved to WordPress as a ready draft.
- client
- Property manager and brokerage, San Diego
- duration
- 2–3 weeks
- built with
- Zapier, Copper CRM, Apify, Claude, WordPress API
- trigger
- Deal reaches “Pre Move In Complete”
- 1Deal stage changesCopper CRM, “Pre Move In Complete”done
- 2Scrape the listingCustom Apify actor, Zillow data by addressdone
- 3Wait, then fetch the dataA delay lets the scraper finishdone
- 4Keep the key detailsJavaScript filters the raw outputdone
- 5Write the SEO packageClaude: post, meta title, meta description, excerptdone
- 6Create the draft postWordPress /build-post endpointsent
content generated in minutes, not hours
pieces of SEO content: post, meta title, meta description, excerpt
sections built from the AI output: intro, body, FAQs
systems connected, from CRM update to blog draft
Every listing needed its own post
Each new property needed a unique, SEO-optimized blog post. Someone had to gather the property data, research keywords, write the copy and publish it to WordPress by hand. That took a lot of time and limited how fast the marketing team could promote new listings.
From CRM update to blog draft
- 01CRM triggerThe Zap starts when a deal in Copper reaches the “Pre Move In Complete” stage.
- 02Property researchA custom Apify actor scrapes Zillow using the property address; the Zap waits, then fetches the structured data.
- 03AI copywritingClaude, prompted as an expert real estate content creator, writes the blog post, meta title, meta description and social excerpt.
- 04WordPress publishingA code step parses the output and a custom API endpoint creates a formatted draft with sections, FAQs and metadata.
How it works
CRM trigger, Zillow scraping, AI writing, WordPress publishing. Every post lands as a draft ready for review.
- triggerCopper CRMdeal stage update
- scrapeApifyZillow data
- AIClaudeSEO content
- publishWordPresspost via API
- resultDraft postready for review
Technical highlights
Data extraction and AI prompting
- Asynchronous scraping: the Zap starts an Apify actor and waits for the Zillow data to be collected.
- Data filtering: a JavaScript step keeps only the property details the AI needs.
- Expert prompt: a detailed system prompt casts Claude as a real estate content creator for structured output.
Automated publishing
- Custom WordPress endpoint: a custom /build-post API endpoint handles the post creation.
- Content parsing: JavaScript turns the Markdown output into HTML for the intro, body and FAQs.
- Full draft: title, content, SEO meta title and description, excerpt and featured image are all set.
More with Claude and Apify
Zillow property and agent scraper
A custom Apify actor that collects listings by ZIP code and finds agent contacts.
1000slistings per runsame CRM · onboardingGravity Forms to Copper CRM
Single-unit onboarding into Copper with person and opportunity matching.
80+fields mappedClaude writes · docsConfluence docs for Zapier workflows
Zapier exports turned into technical documentation by Claude.
95%faster documentationNeed a content pipeline like this?
Scraping, AI copywriting and automated publishing: tell me what you write by hand today and I'll reply within a business day.