The Scenario
It's the end of the quarter and your head of content has asked for a review of everything published over the last three months. You open DotSimple — there are 200-plus posts across multiple accounts, some published, some still sitting in draft. The export button gives you a CSV that's missing the author column and cuts off at 100 rows.
The bad version:
- Open DotSimple, click through posts one page at a time, and manually copy post ID, snippet, status, and author into an Excel workbook row by row.
- Realize the built-in export stops at 100 rows and go back to get the rest, resetting your place in the list each time.
- Spend 90 minutes assembling a worksheet that's already incomplete before the first formula runs.
This is a review that's supposed to inform next quarter's content strategy. Showing up to that conversation with a half-built workbook built from memory-and-paste isn't an option.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Excel workbook. It reads your workbook, connects to DotSimple through its built-in integration, and fetches the data you need — without a CSV download, without a manual copy loop, without a 90-minute setup.
Pull every post from my DotSimple workspace and paste post ID, status, and created date into the "Content Inventory" Excel tab.
What You Get
- The "Content Inventory" sheet populated with one row per post.
- Columns: Post ID, Status, Created Date — in the order you asked.
- All posts returned — published and draft — not just the first 100.
- If a post is missing a field, that cell is left blank and the row is still written.
What If the Data Is Not Quite Ready
The content snippet is truncated and I need the full body
Pull all posts from my DotSimple workspace and write the full post body (not truncated) into column B of the "Content Inventory" tab alongside post ID, status, author, and created date.
I only want posts from the last 90 days
Pull all DotSimple posts created in the last 90 days and write post ID, content snippet, status, author, and created date into the "Q1 Audit" worksheet. Leave out anything older.
I need published posts and drafts in separate worksheets
Pull all DotSimple posts and write published posts into a "Published" worksheet and drafts into a "Drafts" worksheet, with columns: post ID, content snippet, author, and created date.
Full cleanup + categorize + export in one shot
Pull all DotSimple posts from the last 90 days. For any post where status is "draft" and created date is older than 60 days, mark it as "Stale Draft" in a new Status column. Then write all rows — including the stale draft flag — into the "Q1 Content Review" worksheet sorted by created date descending.
The pattern: pull and categorize in a single prompt rather than exporting first and reformatting second.
Try It
If you have an Excel workbook where you track editorial calendars or content output, Get the 7-day free trial of SheetXAI and ask it to fetch your DotSimple post library into a ready-to-review table. Then check out how to bulk-create tags from a workbook or get an overview of all your DotSimple integration options.