n8n Magic: How I Automated My Content Inventory in 60 Minutes

As a content strategist, I’ve spent years preaching the importance of a clean content inventory. But as the founder of BestSaaS AI, I hit a wall: the more I reviewed, the more my manual “tracking spreadsheet” fell behind.

I was spending more time logging URLs than actually testing software.

So, I decided to stop being a spectator of the AI revolution and start being a builder. I didn’t want a complex, expensive enterprise tool. I wanted a Content Inventory Agent that worked while I slept. Here is the grounded, no-fluff journey of how I built it using n8n and WordPress.

The Problem: The “Inventory Tax”

Every time I hit “Publish” on a new SaaS review or a strategy piece, I had a manual checklist:

  1. Copy the URL.
  2. Open Google Sheets.
  3. Paste the Title, Date, and Category.
  4. Format the row.

It only takes 3 minutes, but 3 minutes multiplied by hundreds of posts is a theft of creative energy. I needed a “digital twin” to handle the clerical work.

The Stack: Simple, Free, and Scalable

I chose a stack that keeps my overhead at zero while I scale to my goal of 4,000 vetted reviews:

  • n8n Cloud (Free Tier): The “brain” that connects my apps.
  • WP Webhooks: The “voice” that tells the brain when a post is live.
  • Google Sheets: The final destination for my data.

The “Aha!” Moment (and the Hurdles)

Building an agent isn’t a straight line. I spent thirty minutes staring at a “[NO CONTENT FOUND]” error. Why? Because I had the “ears” of my agent (the Webhook) set to listen for a GET request, while WordPress was shouting in POST.

The second I switched that toggle to POST, the data flooded in. Seeing the JSON code of my latest blog post appear in the n8n dashboard wasn’t just a technical win—it was the moment I realized I could automate anything.

The Result: A Living Inventory

Now, the workflow is elegant:

  1. Trigger: I publish a post on bestsaasai.com.
  2. Action: A Webhook fires instantly to my n8n agent.
  3. Outcome: A new row is appended to my Google Sheet with the Title, URL, and Category perfectly mapped.

Why This Matters for BestSaaS AI

This isn’t just about a spreadsheet. It’s about leverage. By automating the “inventory tax,” I’ve freed up hours every month to focus on higher-level content strategy and deeper AI testing.

If you’re building a content-heavy site, stop doing the manual labor. Build the agent. The 14-day trial is enough time to change how you work forever.

Leave a Comment

Your email address will not be published. Required fields are marked *