The Scenario
You're a growth lead running eight active LGM campaigns. It's the end of the month and you need to brief your director on sending capacity before three new sequences go live next week. You need one workbook that shows every campaign name, its linked audience, the audience size, and which identity is assigned — so you can spot overlap and rebalance before you launch.
That data exists inside LGM. But there's no single view that shows all of it at once.
The bad version:
- Open each of the eight campaigns in LGM one at a time, note down the audience name, click into the audience to find the size, go back, find the assigned identity, copy it — and do this eight times into a manually formatted workbook.
- Realize halfway through that two campaigns share the same audience, which means your contacts are getting sequenced twice, and you have to go back and untangle which sends have already gone out.
- Spend 45 minutes building the table that should have taken two minutes to export.
There's no "export everything" button in LGM that gives you this combined view. The data is real — the tool just doesn't surface it in the shape you need.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It connects to LaGrowthMachine and pulls back exactly the data you ask for, written directly into the workbook in the columns you specify.
Open the SheetXAI sidebar and paste this:
List all campaigns from my LGM account and write them to a 'Campaign Overview' worksheet with columns: campaign_id, campaign_name, status, created_date
Then follow it with:
List all audiences in LGM and write them to an 'Audiences' worksheet with columns: audience_id, audience_name, size, source_url, type — then in column F write 'Large' for any audience with size greater than 500
What You Get
- A 'Campaign Overview' worksheet with one row per campaign, columns for ID, name, status, and creation date.
- An 'Audiences' worksheet with one row per audience, including size — so you can immediately see which audiences are large enough to cause overlap risk.
- Column F flags audiences over 500 contacts, giving you a quick scan before you brief your director.
- Both worksheets update in seconds with live data from LGM — no manual entry, no stale numbers.
What If the Data Is Not Quite Ready
You need campaigns and their audiences joined in one view
LGM stores campaigns and audiences as separate objects. You want a single worksheet that shows campaign name alongside audience name and size.
List all campaigns from my LGM account and write them to 'Campaign Overview' with campaign_id and campaign_name — then list all audiences and write them to 'Audiences' with audience_id, audience_name, size — then in 'Campaign Overview' add a column D 'audience_name' by matching each campaign's audience ID to the Audiences worksheet
Only show active campaigns
Your account has paused and completed campaigns you don't need in the analysis. You want only the ones currently running.
List all campaigns from my LGM account where status is 'active' and write them to a 'Live Campaigns' worksheet with campaign_id, campaign_name, status, created_date — skip any campaign with status 'paused' or 'completed'
Flag audiences that appear in more than one campaign
You want to know which audiences are shared across campaigns — a sign that the same contacts are being sequenced multiple times.
List all campaigns from my LGM account and write them to 'Campaign Overview' with campaign_id, campaign_name, audience_id — then in column D write 'OVERLAP' for any audience_id that appears more than once in column C
Full capacity audit in one prompt
You want campaigns, audiences, sizes, identity assignments, and overlap flags — all written to separate worksheets, all in one go.
List all LGM campaigns and write to 'Campaigns' worksheet with campaign_id, campaign_name, status, audience_id, identity_name — list all audiences and write to 'Audiences' worksheet with audience_id, audience_name, size, type — in the 'Campaigns' worksheet, add column F 'audience_size' by matching audience_id to the Audiences worksheet, and add column G 'overlap_flag' writing 'OVERLAP' for any audience_id appearing more than once
One prompt, four worksheets' worth of reporting, done before the next calendar invite.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull your LGM campaign and audience data into a structured overview. Also useful: building LGM audiences from LinkedIn URLs in your workbook and the full LaGrowthMachine + Excel overview.