The Scenario
The content manager is six months into the role. She inherited 150 blog articles across three Shopify blogs — some from the previous marketing manager, some from an agency, some with no author listed at all. She's never done a full content audit. The VP of Marketing asked for a content calendar for Q3, and she can't build one without knowing what already exists, what's stale, and what's missing an author.
There's no export function in the Shopify blog admin. The articles live one blog at a time, one page at a time.
The bad version:
- Open Shopify's first blog, scroll through the articles, note each one's title, status, author, and published date into a spreadsheet.
- Open the second blog. Repeat.
- Open the third blog. Repeat.
- Spend 90 minutes building a spreadsheet that should have taken 5 minutes.
The editorial calendar meeting is Tuesday. It's Friday. The audit needs to exist before the meeting so the content manager can prepare recommendations.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls all articles from all Shopify blogs in one operation and writes them into the workbook with the fields the content manager needs for her audit.
Pull all Shopify blog articles and paste into my Editorial Calendar Excel sheet — highlight in red any article where published date is more than 2 years ago
What You Get
- One row per article across all three blogs, with blog name, title, author, tags, publication status, and published date in labeled columns.
- Articles published more than two years ago highlighted in red automatically — no manual date comparison required.
- A complete editorial inventory the content manager can sort, filter, and use to build the Q3 calendar.
What If the Data Is Not Quite Ready
Articles with no author assigned should be flagged separately from the staleness flag
Pull all Shopify blog articles and write blog name, title, author, status, and published date into my Editorial Calendar Excel sheet — add a flag column that says 'no author' if author is blank and 'ok' otherwise — also flag 'stale' if published more than 2 years ago
The content manager only needs published articles, not drafts
Pull all published Shopify blog articles and write blog name, title, author, tags, and published date into my Editorial Calendar Excel sheet — exclude articles where published_at is null
Word count estimate is needed for prioritizing rewrites
Pull all Shopify blog articles and write blog name, title, author, status, published date, and approximate word count (from body text length) into my Editorial Calendar Excel sheet — highlight rows where word count is below 300
Full audit: all blogs, published and draft, staleness and author flags, word count estimate
Pull all Shopify blog articles from all blogs — write blog name, title, author, tags, status, published date, and word count estimate into my Editorial Calendar Excel sheet — add a 'stale' flag for articles more than 2 years old — add a 'no author' flag for articles with no author assigned — sort by published date ascending so oldest articles appear at the top
Running the sort and both flags alongside the pull means the content manager opens the workbook on Monday with an action-prioritized list, not a flat dump to organize herself.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook before the editorial calendar meeting, then ask SheetXAI to pull all 150 articles across all three blogs with staleness and author flags in one operation. Future quarterly content audits will use the same prompt. Also worth reading: how to export product data for a similar structured audit, or the hub overview for all Shopify workflows.