The Scenario
Last week you submitted 20 3D modeling jobs to Modelry. You have the request IDs in column A of your tracking sheet, entered when you placed the orders. Your operations director asked for an updated status report this morning — not a dashboard screenshot, a spreadsheet with the current percentage for each job.
The bad version:
- Open Modelry, find each request by ID (which means searching or scrolling), read off the status and completion percentage
- Paste those values into the sheet for each of the 20 rows
- Get to row 12 and realize you misread the percentage on row 9, go back and fix it
- Spend 45 minutes on a task that should take 90 seconds
You've already done this once. You'll probably do it again next week. There is no version of the manual approach that stops being annoying.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the request IDs already in your data and fetches the live status from Modelry for each one. You don't have to open the Modelry dashboard at all.
For each modeling request ID in column A of my sheet, fetch the current status and completion percentage from Modelry and write the status into column B and the completion percentage into column C
What You Get
- Column B updates with the current Modelry status for each request ID in column A
- Column C updates with the completion percentage as a number
- All 20 rows processed in a single pass — no clicking, no searching, no copy-pasting
- If a request ID in column A doesn't exist in Modelry, column B gets "not found" so you know which ones to investigate
What If the Data Is Not Quite Ready
Some request IDs in column A have leading spaces or formatting characters
For each request ID in column A, trim any whitespace before querying Modelry — then write the current status into column B and completion percentage into column C; if the ID doesn't return a result write "lookup failed" in column B
You want to add a timestamp showing when you last refreshed the data
For each request ID in column A, fetch the current status from Modelry and write it into column B and completion percentage into column C — then write today's date and time into column D for each row that was successfully updated
Some jobs may be complete and you want to flag them separately
For each modeling request ID in column A, fetch status from Modelry and write it into column B and completion percentage into column C — then in column D write "done" if the status is "completed," "in progress" if it's any other active status, and "check manually" if Modelry returns an error
Refresh all statuses, flag anything that hasn't moved in 72 hours, and calculate the average completion across all jobs in one prompt
For each request ID in column A, fetch current status from Modelry and write status into column B and completion percentage into column C — then in column D write "stalled" for any job where status is not "completed" and the completion percentage is the same as the value currently in column C (meaning no change), and in cell E1 write the average completion percentage across all 20 jobs
One prompt handles the bulk refresh, the staleness flag, and the aggregate calculation simultaneously.
The point is that you don't have to run a refresh and then run the analysis as two separate operations. Everything you want to know about the status of this batch can come out in one ask.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you're tracking your Modelry modeling batch by request ID, then ask it to pull current status and completion percentage for every row. For related tasks, see pulling all active Modelry modeling requests into a sheet or the full Modelry integration overview.