The Scenario
You inherited a Linkly workspace from the previous marketing manager. There are 80 links in it. You have no idea which ones have retargeting pixels attached, which UTM campaigns they're tagged to, or whether any of them still point at valid destinations. Your manager wants a configuration audit documented in a workbook before next week's agency handoff — everything: destination URL, UTM source, UTM medium, UTM campaign, pixel settings, click count.
The bad version:
- Open Linkly, click into the first link, write down the destination URL, UTM fields, and pixel setting in the workbook
- Back out, click into the second link, write those down
- Eighty links later, the workbook is full of data you transcribed by hand — some of it wrong because your attention drifted around link 55
This is the kind of work that makes people build their own data pipelines. It's also the kind of work that should take ten minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the link IDs you have, fetches the full configuration from Linkly for each one, and writes every field directly into the workbook — no clicking through the UI.
For each Linkly link ID in column A fetch the full link details and write the destination URL, UTM source, UTM medium, UTM campaign, and total clicks into the adjacent columns
What You Get
- Columns B through F fill with destination URL, UTM source, UTM medium, UTM campaign, and total click count — one row per link ID
- Fields that are empty in Linkly (no UTM source set, no retargeting pixel) are written as blank cells rather than causing the row to error
- The writeback is in the same row order as column A — no row shuffling to reconcile after
- If a link ID is invalid, column B gets an error note so you know exactly which IDs to investigate
What If the Data Is Not Quite Ready
You don't have the link IDs — you need to pull the full list from Linkly first
The only thing you have is access to the workspace. No spreadsheet of IDs yet.
List all links in my Linkly workspace and for each one write the ID, short URL, title, total clicks, UTM source, UTM medium, and UTM campaign into this workbook starting at row 2
The audit also needs the retargeting pixel IDs
The agency needs to know which links have pixels attached, because those pixels are owned by the client and need to be transferred.
For each Linkly link ID in column A fetch the full link details and write the destination URL, UTM source, UTM medium, UTM campaign, retargeting pixel ID, and total clicks into columns B through G — leave column G blank if no pixel is attached
The workbook already has some columns filled; only fill what's missing
Columns B and C are already populated from an earlier partial export. Only D, E, and F are blank.
For each Linkly link ID in column A, fetch the UTM campaign, total clicks, and creation date and write them into columns D, E, and F — do not overwrite columns B and C
Pull the full config, flag broken destinations, and sort by pixel presence
List all links in my Linkly workspace and for each one write the ID, short URL, destination URL, UTM source, UTM medium, UTM campaign, retargeting pixel ID, and total clicks into columns A through H; sort by whether a pixel is attached (pixel rows first), and flag any destination URL that returns a 404 in column I
The agency gets the workbook on Monday with everything they need to take over the workspace.
Try It
Open an Excel workbook and paste your Linkly link IDs (or let SheetXAI pull the full list for you), then Get the 7-day free trial of SheetXAI and run the configuration audit. If you also want to update destination URLs after the audit, bulk-updating link destinations is the next step. The hub overview covers all Linkly + Excel workflows.