Check Which Excel workbook Prospects Are Already in LGM

The Scenario

Your RevOps analyst exported 80 prospects from HubSpot and dropped them into an Excel workbook. Before anyone imports them into LaGrowthMachine, someone needs to check which ones are already in LGM and in which audiences — because if you import duplicates, the same contacts get sequenced twice and you burn your LinkedIn reputation with people who've already heard from you.

Nobody volunteered to do this check. It landed on your plate at 4 PM.

The bad version:

• Go into LGM's search UI, paste each email from the workbook one at a time, read the result, go back to the workbook, type "In LGM – Audience: Q1 Outbound" into column B, repeat.
• After 20 minutes you've done 15 rows and you're already miscounting which rows you've checked.
• Give up on the per-row approach, decide to just import everyone and hope LGM's dedup catches it — which it sometimes does and sometimes doesn't, and you find out three days later when a lead replies "you already contacted me last month."

The check itself is simple. The problem is that LGM has no "bulk lookup" UI for a list of emails. You're either doing it one at a time or not doing it at all.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent inside your Excel workbook. It reads your prospect list, queries LaGrowthMachine for each email, and writes the results back into your workbook — so the dedup check that normally takes an hour takes about 30 seconds.

Open the SheetXAI sidebar with your 'HubSpot Prospects' worksheet active and paste this:

For each email in column A of the 'HubSpot Prospects' worksheet, search LGM for a matching lead and write the returned lead_id and audience membership to columns B and C — write 'Not found' in column B if no match exists

What You Get

• Column B: the LGM lead_id for each matched contact, or "Not found" for contacts not yet in LGM.
• Column C: the audience name(s) each matched contact belongs to, so you can see immediately if they're in an active sequence.
• The check runs across all 80 rows in one pass — not one row at a time through a search UI.
• You now have a clean flag column you can filter on before deciding what to import.

What If the Data Is Not Quite Ready

Copy the "Not found" rows to a new worksheet for import

After the lookup, you want to isolate the contacts who aren't in LGM yet and move them somewhere clean for import.

Using the 'HubSpot Prospects' worksheet, copy all rows where column B is 'Not found' to a new 'New to LGM' worksheet so they can be imported without duplication

Check by LinkedIn URL instead of email

Your prospect workbook has LinkedIn URLs in column C but email isn't always populated. You want to match against LGM using URL as the primary key.

For each LinkedIn URL in column C of the 'HubSpot Prospects' worksheet, search LGM for a matching lead by linkedinUrl and write the returned lead_id to column D and audience membership to column E — write 'Not found' in column D if no match

Flag contacts who are in an active campaign (not just any audience)

Being in an LGM audience doesn't mean someone is currently being sequenced. You want to know if they're in an audience attached to a live campaign.

For each email in column A of 'HubSpot Prospects', search LGM for a matching lead — if found, check whether their audience is linked to any campaign with status 'active' and write 'Active sequence' or 'Inactive' to column D, along with the campaign name in column E

Full reconciliation and readiness check in one pass

You want the LGM lookup, the "not found" filter, a new import-ready worksheet, and a summary count — all in one prompt.

For each email in column A of 'HubSpot Prospects', search LGM for a match — write lead_id to column B and audience membership to column C, or 'Not found' if no match — then copy all 'Not found' rows to a new 'Import Ready' worksheet — then in cell E1 write a count of how many were found vs not found

The dedup check, the clean list, and the summary number — all in one instruction instead of three separate steps.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook with a prospect list you're about to push into LaGrowthMachine, then ask it to cross-check against LGM before you import. Also worth reading: how to bulk import prospects into LGM from an Excel workbook and the full LaGrowthMachine + Excel overview.