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 sheet 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 Google Sheet. It reads the LinkedIn URL from your sheet, creates the LGM audience through the API, and writes the returned audience ID back to your sheet — so you have the ID ready for the next step without going near the LGM interface.
With your recruitment sheet 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' sheet 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 sheet now has the audience ID — no copying from the LGM URL bar.
- The 'Audience Check' sheet 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 Google Sheets 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' sheet 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 sheet doesn't match what's in LGM
You wrote "Berlin Recruiter" in your sheet 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' sheet 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' sheet.
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' sheet 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 Google Sheet 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 a sheet and the full LaGrowthMachine + Google Sheets overview.