← ClaudeAtlas

create-clean-disposition-rows-in-master-sheet-fastlisted

Build a Zap on Zapier that watches a campaign spreadsheet for updated disposition text, normalizes it to one of a fixed set of labels with AI, and appends a clean row to a master sheet. Use when campaign or call-log sheets record freeform outcomes ("call back Tuesday", "not interested") and reporting or fulfillment needs one consistent label per record in a central sheet.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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