The Scenario
You are an email strategist. A new client has just hired you. Their Kit account has been running for two years. You want to pull subscribers who have not opened any email in the last 90 days into an Excel workbook so your client can decide whether to suppress or reactivate them.
The bad version of this engagement audit:
- You go to Kit and look for a "zero opens in 90 days" filter
- Kit's filter UI shows broad segments, not that specific date window
- You export the closest match and get a large CSV with no clear date window confirmation
- You spend an hour in Excel trying to reconstruct the logic manually
- You hand the client a list you cannot fully vouch for.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI calls Kit's subscriber API with the engagement filter you specify and writes the results into the workbook.
Open the SheetXAI sidebar and type:
Pull all Kit subscribers who have not opened any email in the last 90 days. Write their email in column A, subscriber ID in column B, and created date in column C into this workbook. Sort by created date ascending so the oldest unengaged subscribers appear first.
SheetXAI calls Kit's API with the engagement filter, pulls the matching subscribers, and writes the table. Your client gets a list they can act on.
What You Get
A targeted low-engagement segment ready for a suppression or reactivation decision:
- Email — the subscriber address for any follow-up action
- Subscriber ID — the Kit identifier needed for bulk unsubscribe or tag operations
- Created date — how long they have been on the list, which shapes the decision
The oldest unengaged subscribers appear first. Someone who joined 18 months ago and has never opened anything is a different case from someone who joined 10 days ago.
What If the Data Is Not Quite Ready
Engagement exports have definitional edge cases. SheetXAI handles them inline.
When you need to adjust the engagement window or metric
Pull all Kit subscribers who have not clicked any email in the last 60 days. Write email in column A, subscriber ID in column B, and last click date (or "never" if no clicks) in column C. Sort by subscriber ID ascending.
When you want to split the export by subscriber age into separate tabs
Pull all Kit subscribers with zero opens in the last 90 days. For those created in the last 30 days, write them to the New Subscribers tab. For those created more than 30 days ago, write them to the Lapsed Subscribers tab. Include email and subscriber ID in both.
When you want to cross-reference against an existing suppression list in another tab
Pull all Kit subscribers with zero opens in the last 90 days. Write email, subscriber ID, and created date to columns A through C. Check column A against the emails in the Suppression tab. For any email already there, write "ALREADY SUPPRESSED" in column D. Leave column D blank for net-new low-engagement subscribers.
When you want the full audit: pull, segment, and recommend in one pass
Pull all Kit subscribers with zero opens in the last 90 days and write the list to the Low Engagement tab — email, subscriber ID, created date. In the Summary tab, write: total count, percentage of the full list, breakdown by subscriber age (0-30 days, 31-90 days, over 90 days), and a two-sentence recommendation on suppress vs. reactivate based on the age distribution.
The pattern: pull the data, segment it, and interpret it in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask SheetXAI to pull your low-engagement Kit subscribers into it. The Kit integration is included in every SheetXAI plan. For the bulk action that follows, see how to mass unsubscribe Kit contacts from an Excel workbook or the Kit in Excel overview.