The Scenario
You took over the email marketing account from someone who's no longer at the company. There's a Sendloop account with — you're not sure how many lists. Twelve? Maybe fifteen? And campaigns stretching back eighteen months. Your job is to figure out what's still active, what's been sitting dormant, and what should be archived before your next send.
The bad version:
- Log into Sendloop, click into Lists, and write down each list ID and name in a blank doc — then switch to Campaigns and do the same thing, campaign by campaign, copying names and statuses into a second column.
- Build the comparison table yourself in Google Sheets, trying to line up which campaigns belong to which lists because there's no combined view in the Sendloop dashboard.
- Go back to Sendloop twice more because you forgot to note whether three of the campaigns were "sent," "draft," or "paused," and the statuses matter for the decision on what to archive.
Nobody budgets time for this kind of inherited archaeology. You're supposed to be planning next quarter's sends, not reverse-engineering what your predecessor set up.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you're working with, and through its built-in Sendloop integration it can pull your lists and campaigns for you — structured exactly how you describe them.
List all my Sendloop subscriber lists and write each list's ID and name into columns A and B of this sheet, then list all my campaigns below that with their IDs, names, and statuses
What You Get
- Column A: list IDs for every subscriber list in the account
- Column B: list names, one row per list
- Below that section: campaign IDs in column A, campaign names in column B, campaign statuses in column C
- Every row populated in a single pass — no gaps, no missing statuses
What If the Data Is Not Quite Ready
The lists and campaigns are in separate tabs
List all Sendloop subscriber lists and write each list's ID and name into columns A and B of the 'Lists' tab, then list all campaigns and write their IDs, names, and statuses into columns A through C of the 'Campaigns' tab
Some campaigns have no status returned
List all Sendloop campaigns and write their IDs, names, and statuses into columns A through C — if any campaign has no status, write "unknown" in column C for that row
You want to see the lists sorted by name
Get all Sendloop subscriber lists and write their IDs and names into columns A and B, sorted alphabetically by name
The full combined audit in one shot
Get all Sendloop subscriber lists and all campaigns, write lists into the 'Lists' tab with ID in column A and name in column B, then write campaigns into the 'Campaigns' tab with ID, name, and status — flag any campaign with status "draft" by writing "REVIEW" in column D
The pattern: describe the audit shape you want, including the exception logic, and SheetXAI handles the fetch, the structuring, and the flagging in one pass.
Try It
Open a blank Google Sheet, then Get the 7-day free trial of SheetXAI and ask it to pull your Sendloop lists and campaigns into the structure above. From there, check out how to export subscribers from a specific list or return to the Sendloop integration overview.