create-clean-disposition-rows-in-master-sheet-fastlisted
Install: claude install-skill zapier/awesome-zaps
# Create clean disposition rows in master sheet fast
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/create-clean-disposition-rows-in-master-sheet-fast. Read the files there if this skill was installed on its own.
## What it does
1. **Trigger:** a row in the source worksheet is updated (`google-sheets`, `updated_row_only`, "Updated Spreadsheet Row"). Brand-new rows do not trigger it.
2. **AI by Zapier** reads the disposition text and returns one of the allowed labels, or `NO MATCH`. A row with empty disposition text is skipped.
3. **Google Sheets** appends one row to the master sheet: record reference, normalized disposition, the raw text, a needs-review flag, the source's updated time, and the time the row was imported. Unmatched text is written as `Needs review` with the flag set to `yes`.
The Zap only reads the source sheet. It never changes it.
## Ask the user
Each `REPLACE_…` value is set per person. Resolve names to IDs with the user's own connections; don't ask them to paste an ID you can look up.
| Setting | Where | What goes there |
| ------------------------------- | ----------- | ------------------------------------------------------------------------------------ |
| `REPLACE_SOURCE_SPREADSHEET_ID` | `config.ts` | The campaign spreadsheet whose disposition rows are watched. Also set on the trigger |
| `REPLACE_MASTER_SPREADSHEET_ID