The Scenario
You inherited this campaign from someone who left the team two weeks ago. The sheet has 150 rows, each with a Hyperise account ID in column A. There's a sticky note on your monitor that says "use template ABC123, destination URL is in the brief doc." You've found the brief. You have the template hash. You have the destination URL.
What you don't have is 150 personalized short links — which are the actual thing you need to paste into the LinkedIn message tool before this campaign goes out Monday.
The bad version:
- You open Hyperise, find the "Generate Personalized Link" section, paste in the account ID from row 1, enter the template hash, enter the destination URL, click generate, copy the link, go back to the sheet, paste it into column B, and repeat.
- Around row 20 you realize you've been copying the link with a trailing space that will break the URL in the message tool.
- By row 60 you've lost the cadence and accidentally generated two links for the same account ID because you clicked ahead.
You're supposed to be doing campaign strategy. Instead you're doing this.
The report going to your VP on Tuesday will ask how the campaign is performing — not how efficiently you copy-pasted links for three hours on Sunday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that sits inside your Google Sheet. It reads your data, calls the Hyperise API, and writes the results back to the correct cells — row by row, without you touching the dashboard.
For each Hyperise account ID in column A, generate a personalized short link using the image template hash in cell C1 and the destination URL in cell D1, and write the generated link to column B.
What You Get
- Column B fills with personalized short links, one per prospect, matched to the correct account ID.
- The template hash and destination URL are read from the fixed cells C1 and D1 — the same values apply to every row.
- Links are clean — no trailing spaces, no truncation.
- Rows that already have a link in column B are left alone, so you can safely re-run the prompt if you add more prospects later.
What If the Data Is Not Quite Ready
Some account IDs are missing
Column A has blanks scattered across it — some prospects were never provisioned with a Hyperise account.
For each row where column A has a Hyperise account ID, generate a personalized short link using the template hash in cell C1 and destination URL in cell D1 and write the link to column B. For rows where column A is blank, write "missing account ID" to column B.
Different rows need different destination URLs
Your campaign has three landing page variants. Column C has the destination URL for each row.
For each row where column A has a Hyperise account ID, generate a personalized short link using the template hash in cell D1 and the destination URL from column C for that row, and write the generated link to column B.
Link generation failed partway through a previous run
Column B has links for rows 1 through 47 and is blank from row 48 onward. You want to resume without re-generating the rows that already have links.
For each row where column A has a Hyperise account ID AND column B is blank, generate a personalized short link using the template hash in cell C1 and destination URL in cell D1, and write the link to column B.
Kill chain: create accounts, generate links, and build a preview report in one shot
Your sheet has company names and websites in columns A and B but no account IDs or links yet. You want the whole thing done before your 9 AM sync.
First, for each row where column A has a company name and column B has a website URL, create a Hyperise client account and write the account ID to column C. Then for each row that now has an account ID in column C, generate a personalized short link using the template hash in cell E1 and destination URL in cell F1, and write the link to column D. Finally, write a summary to cell A1 showing how many accounts were created and how many links were generated.
One prompt does the provisioning and the link generation in sequence.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet that has Hyperise account IDs sitting next to a blank column, then ask it to generate the personalized links before your next campaign send. You can also look at how this connects upstream to bulk-creating prospect accounts or head to the Hyperise + Google Sheets overview to see the full picture.