Guides › Content & Writing
Sort and tag all your old blog posts
A spreadsheet of every past post with consistent categories, tags and a note on which ones need updating or merging.
When to use it
Once a year, or before a website refresh
Step by step
List your posts
Most blog platforms can export a list of posts, or you can copy titles and links from your blog's archive page. Paste them into Google Sheets with columns: Title, Link, Date, Short description.
Decide your categories
Pick 5 to 8 broad categories that match what your readers care about. Fewer is better.
Ask the AI to tag them
Copy the sheet rows into your AI assistant with this prompt (do it in batches of about 50).
Prompt to copyHere is a list of blog posts: [paste Title, Date, Short description]. My categories are: [list]. For each post, give: Title | Best category | 3 tags (lowercase, reuse the same tags across posts where possible) | Status: Keep, Update (if it looks dated or thin), or Merge (if it overlaps another post, say which). Output as a table in the same order.Paste back and apply
Paste the results into new columns next to your list, then update the categories and tags in your blog editor, starting with the most-visited posts.
What you get
'10 spring garden jobs' (2019) | Seasonal guides | spring, planting, lawn | Update: mentions a product no longer sold. 'Spring lawn care tips' (2021) | Seasonal guides | spring, lawn | Merge with '10 spring garden jobs'.
Tips
- Keep tag lists short; 20 to 30 tags across a whole blog is usually plenty.