The Scenario
You're a front-end developer on a three-person team. ScreenshotOne is part of your visual regression pipeline — you use it to capture pages at specific device profiles before and after deploys. The problem: every time someone writes a batch screenshot prompt, they guess at the device slug. Last sprint, two captures used the wrong device ID and the comparison was useless. Your tech lead suggested keeping a reference workbook of all supported device IDs, widths, and heights so the team can look up the right slug before writing any prompt.
You've been asked to create that reference workbook before tomorrow's sprint kickoff.
The bad version:
- Find the ScreenshotOne documentation page listing supported devices.
- Manually copy each device ID, width, and height into a new Excel workbook — one row at a time.
- Realize partway through that the documentation doesn't sort devices by width, so the workbook is in an arbitrary order that's hard to scan.
- Spend an hour on data entry that should take thirty seconds.
This is pure reference data. The time it takes to build a lookup workbook manually is time not spent on anything that actually moves the sprint.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the context, calls ScreenshotOne's device list endpoint through its built-in integration, and writes the full device catalog — IDs, widths, heights — into a new worksheet in the correct order. One prompt.
List all supported ScreenshotOne devices and write each device ID, width, and height into a new sheet called 'Devices' starting at row 2.
SheetXAI calls the ScreenshotOne device list endpoint, creates a 'Devices' worksheet if it doesn't exist, writes a header row, and populates the data starting at row 2 — one row per device.
What You Get
- A new 'Devices' worksheet with column headers: Device ID, Width, Height.
- One row per supported device, pulled directly from the ScreenshotOne API response.
- Data is live — not copied from a documentation page that might be out of date.
- The worksheet is immediately usable as a lookup reference when writing batch screenshot prompts.
What If the Data Is Not Quite Ready
The team wants it sorted by width for easier scanning
The raw device list isn't sorted in a useful order for picking viewports quickly.
Fetch the ScreenshotOne device list and write device ID in column A, width in column B, and height in column C of the 'Device Reference' sheet — sort by width ascending.
The reference worksheet already exists and needs to be refreshed
The 'Devices' worksheet was created last quarter and may be out of date. You want to overwrite it with the current list.
Pull the current ScreenshotOne device list and overwrite the 'Devices' sheet — clear everything below row 1, then write the fresh device IDs, widths, and heights starting at row 2.
The team wants a "common" flag on frequently-used viewports
Some devices (iPhone 14, standard desktop, iPad) are used in 90% of captures. A flag column would let the team filter quickly.
Fetch the full ScreenshotOne device list and write device ID in column A, width in column B, height in column C — then in column D, write "common" for any device with a width of 375, 390, 768, 1280, 1440, or 1920, and leave column D blank for all others.
Kill chain: fetch, sort, flag common devices, and add a summary count in one shot
You want the full reference worksheet built, sorted by width, with the common flag, and a summary section showing how many devices fall into each width category.
Fetch the ScreenshotOne device list, write it into 'Device Reference' with device ID in column A, width in column B, height in column C, sorted ascending by width — mark "common" in column D for widths 375, 390, 768, 1280, 1440, 1920 — then in a summary section starting at F1, count how many devices fall into each width category.
One prompt builds the full reference worksheet your team can actually use.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask SheetXAI to pull the full ScreenshotOne device list into a 'Devices' sheet sorted by width. Also see how to build a multi-viewport grid or the ScreenshotOne overview.