create-end-to-end-test-scripts-from-sheet-user-storieslisted
Install: claude install-skill zapier/awesome-zaps
# Create end to end test scripts from sheet user stories
## What it does
1. **Trigger:** a story row is updated in the stories worksheet (Google Sheets, Updated Spreadsheet Row).
2. **ChatGPT (OpenAI)** writes structured test cases for the story: Test ID, Test Case Name, Purpose, Preconditions and steps.
3. The workflow pulls the Test IDs, names and blocks out of that text, in plain code.
4. **ChatGPT (OpenAI)** writes a runnable TypeScript end-to-end test script from those blocks.
5. **Google Sheets** looks up the output row whose Story ID matches. It updates that row if found, otherwise adds a new one, with Story ID, Test IDs, a test case summary and the script.
## Build it
**Check the fields first:** with the user's own connections, inspect each action's input fields (`inspect_zapier_actions`) and make sure every key and value in `workflow.ts` matches before the first test run.
**How to build:** with Zapier MCP, load the `zapier:build-workflows` skill (`list_zapier_skills`, then `get_zapier_skill`) and follow it to create, test and publish the workflow. This file says _what_ to build; that skill says _how_, and has the current tool names.
**Source:** the files in this folder are the whole zap. `workflow.ts` is the workflow. It imports its settings from `config.ts` and each account from `connections/<alias>.ts`, and `triggers/` holds what starts it.
- **With the zap CLI:** `npx zap-pack add awesome-zaps/create-end-to-end-test-scripts-from-sheet-user-stories` (it make