← ClaudeAtlas

create-end-to-end-test-scripts-from-sheet-user-storieslisted

Build a Zapier Next Gen Zap that reads a changed user story row in a Google Sheet, asks ChatGPT for structured test cases and a runnable TypeScript end-to-end test script, and writes both back to an output tab for QA review. Use when a QA or product team keeps user stories in a sheet and wants test cases and scripts generated for each story without copy and paste.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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