The Scenario
Your marketing ops manager sent a message at 8 AM: "Can you pull a list of all our active Hyperise templates with their IDs, dimensions, and preview URLs? We're doing a Q2 audit and I need it by EOD."
You have access to Hyperise. You know the templates are in there somewhere. What you don't have is any way to get them out of the Hyperise dashboard and into a workbook without clicking through each one individually.
The bad version:
- You open Hyperise, navigate to the Templates section, click the first template, note the name and image hash, screenshot the preview URL from the network tab, write it all down in a workbook row, and click back.
- There are 35 templates. You're on template 4 and it's already been 20 minutes.
- You realize the image hash isn't visible in the UI — you'd need to go into the API docs to figure out how to get it programmatically, and now this has become an afternoon project.
The audit is about deciding which templates to retire and which to lean into for the next quarter. That's the actual work. Cataloging them is a prerequisite — not the job.
The cognitive overhead of this task has nothing to do with why you were hired.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your instructions, calls the Hyperise API, and writes the structured results directly into your workbook — field by field, row by row.
Retrieve all active Hyperise image templates and populate this workbook starting at row 2, with template name in column A, image hash in column B, width in column C, height in column D, preview URL in column E, and creation date in column F.
What You Get
- Rows 2 onward fill with one template per row.
- Column A has the human-readable template name, column B has the image hash you'd use in API calls, columns C and D have the pixel dimensions, column E has the preview image URL you can open directly, and column F has the creation timestamp.
- Row 1 is untouched — you can add headers yourself or ask SheetXAI to add them.
- The workbook reflects what's currently active in your Hyperise account at the moment of the run.
What If the Data Is Not Quite Ready
You want to filter to templates created in the last 90 days
You're only auditing recent templates, not the full library going back to year one.
Retrieve all active Hyperise image templates created in the last 90 days and populate this workbook starting at row 2, with template name in column A, image hash in column B, width in column C, height in column D, preview URL in column E, and creation date in column F.
The workbook already has partial data from a previous pull
Rows 2 through 20 have template data from two weeks ago. You want to refresh without losing your annotations in column G.
Retrieve all active Hyperise image templates and update the workbook starting at row 2: match on the image hash in column B and update columns A, C, D, E, and F if the template already exists. Add new templates at the bottom for any hashes not already in the workbook. Leave column G untouched.
You want a second worksheet with just the dimensions for a design review
Your design team wants a simpler view — just names and dimensions — in a separate worksheet.
Retrieve all active Hyperise image templates and populate the "Template Catalog" worksheet with template name in column A and dimensions formatted as WxH (e.g. 600x315) in column B. Also add the full data — name, hash, width, height, preview URL, creation date — to the "Raw Data" worksheet starting at row 2.
Kill chain: pull templates, flag small ones, and identify which are in active use
You want the full catalog, but you also want to flag templates below 400px wide (likely outdated) and cross-reference against a list of template hashes currently used in campaigns on the "Campaigns" worksheet.
Retrieve all active Hyperise image templates and populate columns A through F starting at row 2 (name, hash, width, height, preview URL, creation date). In column G, write "small" for any template with a width below 400 pixels, and in column H, write "in use" for any template whose hash appears in column B of the "Campaigns" worksheet.
One pass — you get the catalog, the flags, and the cross-reference in a single operation.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, ask it to list your Hyperise templates, and you'll have your audit starting point in under a minute. From there, see how the template hashes connect to generating personalized short links or head back to the Hyperise + Excel overview for the full integration picture.