The Scenario
You're a recruiter. You ran a LinkedIn Sales Navigator search for "Senior Engineers in Berlin" and got a results URL. You want to turn that search into an LGM audience and launch an outreach sequence — but before you launch, you need to confirm the audience actually populated with a reasonable number of candidates. Your hiring manager is expecting a count by end of day.
The tool split that should take 60 seconds takes 20 minutes because it spans three different UIs.
The bad version:
- Copy the Sales Navigator URL, open LGM, navigate to Audiences, click "Create audience," paste the URL, name the audience, assign an identity, save.
- Wait for the crawl to finish — LGM processes LinkedIn URLs asynchronously and doesn't tell you how long it will take.
- Refresh the audience list repeatedly trying to spot when the count updates.
- Realize you need to write the audience ID back to your workbook so you can reference it later in the campaign setup, so you copy it manually from the LGM URL bar.
None of these steps are hard. But you also have four other requisitions open and you shouldn't be spending brain cells on UI navigation to move a URL from one tab to another.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the LinkedIn URL from your workbook, creates the LGM audience through the API, and writes the returned audience ID back to your workbook — so you have the ID ready for the next step without going near the LGM interface.
With your recruitment workbook open and the Sales Navigator URL in cell B2 and the identity name in cell B3, open the SheetXAI sidebar and paste:
Create a new LGM audience called 'Senior Engineers Berlin' by importing the LinkedIn Sales Navigator URL in cell B2, using the identity name in cell B3 — write the returned audience ID to cell B4
Then follow up to confirm the audience is populating:
List all audiences in my LGM account and write them to an 'Audience Check' worksheet with audience_id, name, size, and type — then write 'New' in column E for any audience created in the last 24 hours
What You Get
- Cell B4 in your workbook now has the audience ID — no copying from the LGM URL bar.
- The 'Audience Check' worksheet shows all your audiences with sizes, so you can see whether the crawl has completed and what count came back.
- Column E flags anything created in the last 24 hours so the new audience is instantly visible in a list that might have dozens of entries.
- Your hiring manager gets a count. You didn't have to leave Excel to get it.
What If the Data Is Not Quite Ready
You have multiple search URLs across different rows
You ran four different Sales Navigator searches — different titles, different cities — and you want to create four LGM audiences in one pass, one per row.
For each row in the 'Searches' worksheet where column A is the audience name and column B is a LinkedIn Sales Navigator URL, create an LGM audience using column A as the name and column B as the URL — write the returned audience_id to column C
The identity name in your workbook doesn't match what's in LGM
You wrote "Berlin Recruiter" in your workbook but the actual LGM identity name is "Berlin Recruiter (LinkedIn)." You need to verify the exact identity name first.
List all connected identities in my LGM account and write them to an 'Identities' worksheet with identity_id, name, type, and status — then look up the identity whose name contains 'Berlin' and write its exact name to cell B3
Check audience size after crawl completes
You created the audience an hour ago and want to pull the current size.
Find the LGM audience with audience_id matching cell B4 and write its current size to cell B5, and write its status to cell B6
Full create-verify-log sequence in one prompt
Create the audience, wait for confirmation it was created, check that it appears in the audience list with the correct name, and log the result to a 'Recruitment Log' worksheet.
Create a new LGM audience called 'Senior Engineers Berlin' using the LinkedIn URL in cell B2 and the identity in cell B3 — write the returned audience_id to cell B4 — then list all audiences and write them to 'Audience Check' with audience_id, name, size, type — then add a row to the 'Recruitment Log' worksheet with today's date, the audience name 'Senior Engineers Berlin', and the audience_id from cell B4
Create, verify, and log — done before the crawl even finishes.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you track LinkedIn search URLs for sourcing or outreach, then ask it to spin up the LGM audience and write back the ID. Also useful: how to export all LGM campaigns and audiences to an Excel workbook and the full LaGrowthMachine + Excel overview.