The Scenario
The campaign ran. Forty-five people replied "unsubscribe," "please remove me," or just "stop." Your demand gen manager screenshotted the reply threads, extracted the emails and lead IDs into an Excel workbook, and dropped it in your shared drive with a message that said "can you clean these up in LGM."
It's Wednesday. You have a new campaign going live Friday. If these contacts aren't removed before then, you're hitting people who explicitly asked you not to — which is a compliance problem and a reputation problem.
The bad version:
- Open LGM, go to the audience for each of the three campaigns these unsubscribes came from, search for each contact, click "Remove from audience," confirm.
- 45 contacts × 3 audiences = 135 clicks if you're lucky, more if a contact appears in multiple places.
- Around contact 20, you realize you're not sure if LGM's "remove from audience" is permanent or just for this campaign. You stop to check the docs. You lose your place in the list.
- Finish two hours later, discover you missed 6 contacts because the workbook had some IDs with a leading zero that you didn't notice.
The work is mechanical. The consequence of getting it wrong is not.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your unsubscribe list, calls the LaGrowthMachine API to remove each contact from the specified audiences, and writes the outcome of each removal back to your workbook — so you have an audit trail and you know exactly which ones succeeded and which ones flagged an error.
Open the SheetXAI sidebar with your 'Unsubscribes' worksheet active and paste this:
For every lead ID in column A of the 'Unsubscribes' worksheet, remove that lead from the LGM audience IDs listed in column B and write 'Removed' or the error message to column C
What You Get
- Column C shows "Removed" for every successful removal, or the specific error message if LGM returned one (e.g., "Lead not found in audience" or "Invalid audience ID").
- The workbook becomes your audit record — timestampable, shareable, checkable.
- 45 contacts processed in the time it would have taken you to manually remove the first five.
- No clicks inside the LGM UI, no chance of losing your place in the list.
What If the Data Is Not Quite Ready
You have emails, not lead IDs
Your unsubscribe list came from a reply tracker that only captured email addresses. You need to look up the LGM lead ID first before removing.
Search LGM for each email in column A of the 'Bounced' worksheet — for any match found, remove the lead from all audiences and write the lead_id and status ('Removed' or 'Not found') to columns B and C
Contacts need to be removed from all audiences, not just one
Some contacts appeared in multiple campaigns. You want to remove them from every audience they're currently in, not just the one listed.
For each lead ID in column A of the 'Unsubscribes' worksheet, find all audiences that lead belongs to in LGM, remove them from every audience, and write the list of removed audience IDs to column C and 'Fully removed' or the error to column D
Some rows have blank lead IDs — look them up by email first
Your workbook has lead IDs in column A for 30 contacts, but 15 rows have a blank column A and only an email in column B. You need to handle both.
For rows in 'Unsubscribes' where column A is not blank, remove that lead_id from the audience in column B — for rows where column A is blank, search LGM by the email in column B, then remove the found lead from the audience in column B — write 'Removed' or the error to column C for every row
Full compliance sweep in one shot
Look up every email, remove from all audiences, flag any "Not found" rows for manual review, and write a summary count to the workbook.
For each email in column A of 'Unsubscribes': search LGM for a matching lead — if found, remove from all audiences and write lead_id and 'Removed from N audiences' to columns B and C — if not found, write 'Not found' to column B — then write a summary in cell E1: total processed, total removed, total not found
Clean list, clean record, done before lunch.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of unsubscribed or bounced contacts you need to clean out of LaGrowthMachine, then ask it to handle the removals and write back the status. Also useful: how to check which prospects are already in LGM before importing and the full LaGrowthMachine + Excel overview.