The Scenario
You are a privacy compliance manager at an EU company. Every month you receive a batch of GDPR erasure requests. This month's batch has 45 email addresses in an Excel workbook.
The 30-day deadline from the request date is in eight days. MailerLite's "forget subscriber" endpoint permanently erases all personal data. You need to run all 45 before the deadline.
The bad version:
- You log into MailerLite and go to each subscriber's profile
- You find the "Forget subscriber" option, confirm the erasure, note it on paper, move to the next subscriber
- On subscriber 12 you are not sure whether you clicked confirm or just previewed — so you redo it
- You finish and have no timestamped audit log to show if you are challenged
- You discover on subscriber 38 that the email was never in MailerLite — and you have no record of the outcome per request.
The fast version runs all 45 in one prompt and writes FORGOTTEN, NOT_FOUND, and timestamps back into the workbook as the audit log.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the MailerLite forget subscriber endpoint for each row and writes the outcome and timestamp back — so you have a per-request audit trail without manual record-keeping.
Open the SheetXAI sidebar and type:
For each email in column A, call MailerLite forget subscriber to permanently erase their data — write FORGOTTEN or NOT_FOUND into column B and the timestamp into column C.
SheetXAI reads every row, calls the MailerLite API for each email, and writes the outcome and a timestamp into columns B and C. If an email was never in MailerLite, NOT_FOUND lands in column B.
What You Get
A completed GDPR erasure batch with per-request outcomes:
- FORGOTTEN in column B for every email successfully erased
- NOT_FOUND in column B for emails not in MailerLite
- Timestamp in column C for every row — your audit trail
- No manual record-keeping — the workbook is the log
The NOT_FOUND outcome is compliance-critical. If a data subject challenges the erasure and their email was never in MailerLite, you can show that you attempted it and the system confirmed no record existed.
What If the Data Is Not Quite Ready
GDPR erasure batches from legal teams are never clean. SheetXAI handles variations in the same prompt.
When the email column has extra whitespace or mixed case
The legal team copied emails from a PDF form and some have trailing spaces or uppercase letters.
Trim whitespace from column A and convert to lowercase before processing. Then for each email, call MailerLite forget subscriber — write FORGOTTEN or NOT_FOUND into column B and the timestamp into column C.
When you want to distinguish NOT_FOUND from API errors
There is a difference between "email not in MailerLite" and "the API returned an unexpected error."
For each email in column A, call MailerLite forget subscriber. Write FORGOTTEN if the erasure succeeded, NOT_FOUND if MailerLite confirmed no subscriber record exists, or ERROR with the error message if the API returned an unexpected response. Write the timestamp into column C.
When you only want to process emails that have not been processed yet
This is a running log — some rows from last month were already processed.
For each email in column A where column B is blank, call MailerLite forget subscriber — write FORGOTTEN or NOT_FOUND into column B and the timestamp into column C. Skip rows where column B already has a value.
When you want a summary of the batch outcomes
The compliance report needs total processed, forgotten, not found, and errors.
For each email in column A, call MailerLite forget subscriber — write FORGOTTEN or NOT_FOUND into column B and the timestamp into column C. After processing all rows, add a summary section showing: total processed, count of FORGOTTEN, count of NOT_FOUND, and count of ERROR outcomes.
The pattern: run the erasure and write the audit log in the same prompt. The workbook is the compliance record.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with email addresses that need to be forgotten in MailerLite, then ask it to run the erasure batch and write outcomes back. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to export bounce and unsubscribe records for a deliverability audit in Excel or the MailerLite in Excel overview.