The Scenario
You are an email strategist. A new client has just hired you. Their Kit account has been running for two years, 500-something subscribers, and they believe the list is healthy.
You want to identify subscribers who opened zero emails in the last 90 days and pull them into a Google Sheet. Your client needs to decide whether to suppress, reactivate, or delete these contacts before the next campaign goes out.
The bad version of this engagement audit:
- You go to Kit and filter subscribers by engagement
- Kit's filter UI shows broad segments, not a specific "zero opens in 90 days" filter
- You export the closest match and get a 4,000-row CSV with no way to confirm the date window
- You spend an hour in the sheet trying to reconstruct the logic manually
- You hand the client a list you are not confident in.
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 directly into the sheet.
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 sheet. 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 to the sheet. 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 reactivation vs. suppression decision
The oldest unengaged subscribers appear first. A subscriber who joined 18 months ago and has never opened anything is a different case from one who joined 10 days ago and just has not had a chance yet.
Once this table is in the sheet, you can feed the subscriber IDs back into SheetXAI to bulk-untag, suppress, or enroll in a re-engagement sequence — all in follow-up prompts against the same sheet.
What If the Data Is Not Quite Ready
Engagement exports from email platforms have definitional edge cases. SheetXAI handles them.
When you need to adjust the engagement window
Your client wants 60 days instead of 90, or they want to see zero clicks rather than zero opens.
Pull all Kit subscribers who have not clicked any email in the last 60 days. Write their 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
Newly joined subscribers who have not yet opened are different from long-lapsed subscribers. You want them in 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 tabs.
When you want to cross-reference against a suppression list you already have
Your client sent you a previous suppression sheet. You want to exclude those emails from this export.
Pull all Kit subscribers with zero opens in the last 90 days. Write them to column A through C — email, subscriber ID, created date. Then check column A against the emails in the Suppression tab. For any email that already appears in the Suppression tab, 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
Your client wants an actionable output, not a raw list.
Pull all Kit subscribers with zero opens in the last 90 days. Write the full list to the Low Engagement tab with email in column A, subscriber ID in column B, and created date in column C. In the Summary tab, write a short analysis: total count of low-engagement subscribers, percentage of total list they represent, breakdown of how many were created in the last 30 days vs. 30-90 days vs. over 90 days, and a two-sentence recommendation on whether to suppress or 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 sheet, 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 often follows this export, see how to mass unsubscribe Kit contacts from a sheet or the Kit in Google Sheets overview.