The Scenario
Your team just wrapped a project delivery sprint. Forty Process Street workflow runs — one per deliverable — are fully checked off inside the platform. The runs are done. The tasks are done. But Process Street still shows them as "In Progress" because nobody marked the runs themselves as Completed. That's a batch action, and the platform wants you to do it one at a time. You have a Google Sheet with all 40 run IDs in column A. You've been asked to clean up the dashboard before the client retrospective this afternoon.
The bad version:
- Open Process Street, search for run ID one, click into the run, find the "Complete" button, confirm.
- Realize you don't have a "Complete" button — you have to mark the final task done first, then it auto-completes. Two extra clicks per run.
- Forty runs at roughly three minutes each is two hours. The retrospective is at 3 PM.
You're the one holding the run IDs. The work itself is done. There's no reason this should cost you the rest of your morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data and talks to Process Street on your behalf — it can iterate through every run ID in the sheet and mark each one Completed without you touching the platform.
For each workflow run ID in column A of this sheet, mark the workflow run as Completed in Process Street and write 'done' or the error message into column B.
What You Get
- Every run ID in column A processed sequentially.
- "done" written into column B when the run is successfully marked Completed.
- The specific error message written into column B when a run fails — so you know which IDs need attention and why, rather than discovering a silent failure later.
- The sheet becomes a completion log you can share with the client or archive.
What If the Data Is Not Quite Ready
Some runs are already completed and you want to skip them
You don't want to send a Completed call to runs that are already closed — that might error or create duplicate state.
For each run ID in column A, check the current status in Process Street. If it's already Completed, write 'already done' in column B. If it's In Progress, mark it Completed and write 'done' in column B. Write errors to column B.
The run IDs have trailing spaces or formatting issues
The IDs were pasted from a different system and some have leading/trailing whitespace or line breaks embedded.
For each value in column A, trim any whitespace, then mark the corresponding Process Street workflow run as Completed. Write 'done' or the error into column B.
You want to complete runs in batches and pause between them
The list has 200 IDs and you're worried about rate limits — you want to process 50 at a time and get a status after each batch.
Complete the Process Street workflow runs in rows 2 through 51 of this sheet (column A). Write 'done' or the error into column B for each row. Stop after row 51 — I'll run the next batch separately.
Full kill chain: validate, complete, and summarize
You want to verify each run is genuinely fully checked before marking it done, complete the ones that qualify, flag the ones that don't, and produce a summary count.
For each run ID in column A, check whether all tasks in the Process Street run are marked done. If yes, mark the run Completed and write 'done' in column B. If not, write 'incomplete tasks' in column B. After processing all rows, write a summary in cell D1: total completed, total flagged, total errors.
One prompt validates, acts, and reports — you walk into the retrospective with a clean dashboard and a documented completion log.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of Process Street run IDs, then ask it to mark them all Completed and record the results. Link to sibling: Pull data set records into a sheet | Process Street integration overview