WordPress Blog Scraper Automation — Full Tutorial (Make.com + Google Sheets)

🚀 Automations & AI for businesses
📩 Get my free automations: [Giulianna’s Portfolio](https://www.notion.so/1d8187662ce4807...)
📬 Book a call for a free custom automation: https://calendly.com/giulianna17/30min

Want to export every post from any WordPress website automatically?
In this video, I show you step-by-step how to build a full WordPress scraper automation using Make.com, and send all the data into Google Sheets — including:

✔ Post ID
✔ Title
✔ Publish Date
✔ Slug
✔ URL
✔ Status
✔ Content
✔ Excerpt
✔ Author
✔ Categories
✔ Tags
✔ Yoast SEO title & description
✔ Format and type
… and more, all mapped automatically!

Using the WordPress REST API and Make.com's HTTP module, this automation can pull any public WordPress site’s posts and store them into a structured spreadsheet for:

Content planning
SEO analysis
Repurposing old posts
Creating AI training datasets
Building dashboards
Backups of client sites

The blueprint includes:
🔹 HTTP GET module requesting /wp-json/wp/v2/posts
🔹 Basic Feeder to loop through each post
🔹 Google Sheets Add Row to store all fields

Blueprint link:
https://drive.google.com/file/d/1H6x9...

Link to 2nd part video:
   • Scrape Any WordPress Blog to Google Sheets...  

If you want to automate blog management, content workflows, or AI-ready datasets, this tutorial gives you everything you need.