The Scenario
You are a QA engineer. A new Synthflow agent is going into production next week. You have defined 15 test scenarios in an Excel workbook in the Test Scenarios tab, one per row, with columns for ScenarioName and CallerPrompt.
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 from the workbook
- Each case requires switching between Excel and the Synthflow browser tab
- On case 8, you copy the wrong prompt from the row above
- You do not notice until the suite runs and case 8 fails for the wrong reason
- Sign-off is delayed by a day because one test case had the wrong prompt and the results are invalid.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that creates the simulation suite and adds all 15 test cases from the workbook in one pass, so you never have to switch between Excel and the Synthflow UI.
Open the SheetXAI sidebar and type:
Read the 'Test Scenarios' table in this workbook and create a Synthflow simulation suite for agent [MODEL_ID], then add a simulation case for each row using the ScenarioName and CallerPrompt columns. Write each returned case ID into the CaseID column.
SheetXAI creates the suite, iterates through all 15 rows, creates each simulation case, and writes the case IDs into the CaseID column. When it finishes, the suite is ready to run and the workbook is your test case registry.
What You Get
A completed simulation suite with 15 case IDs in the CaseID column:
- ScenarioName column — unchanged
- CallerPrompt column — unchanged
- CaseID column — returned Synthflow simulation case ID, or an error flag if creation failed
The workbook is the audit trail. 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 workbooks have gaps. SheetXAI handles them inline.
When some rows are missing caller prompts
A few scenarios are not fully defined yet.
Skip any row in the Test Scenarios tab where the CallerPrompt column is empty. For all other rows, create a Synthflow simulation case and write the returned case ID into the CaseID column. Write "SKIPPED — missing prompt" for any skipped row.
When you want to add expected outcome assertions per case
The ExpectedOutcome column has the result each scenario should produce.
For each row in the Test Scenarios tab, create a Synthflow simulation case using ScenarioName and CallerPrompt, and set the expected outcome from the ExpectedOutcome column as the assertion. Write the returned case ID into the CaseID column.
When you need to update existing cases instead of creating new ones
The suite already exists from a previous sprint and you want to update the caller prompts for 5 cases.
For each row in the Test Scenarios tab where the CaseID column already has a value, update the Synthflow simulation case with the revised CallerPrompt. Leave rows with no case ID unchanged.
When you need to create the suite, run it, and write back pass/fail results in one pass
You want the full create-run-review cycle without leaving Excel.
Create a Synthflow simulation suite for agent [MODEL_ID], add one case per row using ScenarioName and CallerPrompt, write each case ID into the CaseID column, then run the suite. When results are available, write the pass/fail status into the Result column for each case.
The pattern: test case creation is a spec sheet 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 workbook with test scenarios in a table, 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 in Excel or the Synthflow AI in Excel overview.