The Scenario
You are a QA engineer. A new Synthflow agent is going into production next week. You have defined 15 test scenarios in a Google Sheet, one per row, with columns for scenario name, caller prompt, and expected outcome.
All 15 need to be created as Synthflow simulation cases and the full suite needs to run before sign-off.
The slow version:
- You open the Synthflow simulation UI
- You create a suite, then start adding cases one by one
- Each case requires typing the scenario name and pasting the caller prompt
- On case 9, the browser tab crashes
- You reopen Synthflow, try to figure out which cases were saved
- Sign-off is delayed by a day because you spent the afternoon re-entering test cases.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that creates the simulation suite and adds all 15 test cases from the sheet in one pass, so you never have to click through the Synthflow simulation UI row by row.
Open the SheetXAI sidebar and type:
Create a Synthflow simulation suite for agent [MODEL_ID], then create one simulation case per row in this sheet using the scenario name from column A and the caller prompt from column B. Write each returned case ID into column C.
SheetXAI creates the suite, iterates through all 15 rows, creates each simulation case, and writes the case IDs into column C. When it finishes, the suite is ready to run and the sheet is your test case registry.
What You Get
A completed simulation suite with 15 case IDs in column C:
- Column A — scenario name (unchanged)
- Column B — caller prompt (unchanged)
- Column C — returned Synthflow simulation case ID, or an error flag if creation failed
The sheet is the audit trail for your test suite. You can share it with the team, reference case IDs in tickets, and rerun specific cases by ID without digging through the Synthflow UI.
What If the Data Is Not Quite Ready
Test scenario sheets have gaps. SheetXAI handles them inline.
When some rows are missing caller prompts
A few scenarios are not fully defined yet.
Skip any row where column B is empty. For all other rows, create a Synthflow simulation case using column A and column B, and write the returned case ID into column C. Write "SKIPPED — missing prompt" into column C for any skipped row.
When you want to add expected outcome assertions per case
Column C has the expected outcome you want each scenario to hit.
Create a Synthflow simulation suite for agent [MODEL_ID], then for each row in this sheet, create a simulation case using scenario name from column A, caller prompt from column B, and expected outcome from column C as the assertion. Write the returned case ID into column D.
When you need to update existing cases, not create new ones
The suite already exists from a previous run and you want to update the caller prompts for 5 cases.
For each row where column C has a case ID, update the Synthflow simulation case with the caller prompt from column B. Leave rows with no case ID unchanged.
When you need to create the suite, run it, and write back the pass/fail results in one go
You want the full create-run-review cycle in one prompt.
Create a Synthflow simulation suite for agent [MODEL_ID], add one case per row using column A and column B, write each case ID into column C, then run the suite. When results are available, write the pass/fail status into column D for each case ID.
The pattern: test case creation is a list operation, not a click-through task. Fifteen rows, one prompt, full case ID tracking.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with test scenarios in columns A and B, then ask it to create your Synthflow simulation suite. The Synthflow integration is included in every plan. For related workflows, see how to pull call transcripts for QA review or the Synthflow AI in Google Sheets overview.