AI, content & data · content automation

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”
One new propertyexample
  1. 1
    Deal stage changesCopper CRM, “Pre Move In Complete”
    done
  2. 2
    Scrape the listingCustom Apify actor, Zillow data by address
    done
  3. 3
    Wait, then fetch the dataA delay lets the scraper finish
    done
  4. 4
    Keep the key detailsJavaScript filters the raw output
    done
  5. 5
    Write the SEO packageClaude: post, meta title, meta description, excerpt
    done
  6. 6
    Create the draft postWordPress /build-post endpoint
    sent
writing time
−98%

content generated in minutes, not hours

per property
4

pieces of SEO content: post, meta title, meta description, excerpt

post structure
3

sections built from the AI output: intro, body, FAQs

pipeline
4

systems connected, from CRM update to blog draft

the challenge

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.

what I built

From CRM update to blog draft

  1. 01CRM triggerThe Zap starts when a deal in Copper reaches the “Pre Move In Complete” stage.
  2. 02Property researchA custom Apify actor scrapes Zillow using the property address; the Zap waits, then fetches the structured data.
  3. 03AI copywritingClaude, prompted as an expert real estate content creator, writes the blog post, meta title, meta description and social excerpt.
  4. 04WordPress publishingA code step parses the output and a custom API endpoint creates a formatted draft with sections, FAQs and metadata.
architecture

How it works

CRM trigger, Zillow scraping, AI writing, WordPress publishing. Every post lands as a draft ready for review.

  1. triggerCopper CRMdeal stage update
  2. scrapeApifyZillow data
  3. AIClaudeSEO content
  4. publishWordPresspost via API
  5. resultDraft postready for review
under the hood

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.
ZapierCopper CRMApifyAnthropic (Claude)WordPress APICustom JavaScript
keep reading

More with Claude and Apify

Need 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.

more work

Related case studies

This site uses cookies for analytics. Necessary ones are always on. Read the privacy policy