create-claims-database-entry-from-updated-sheet-rowslisted
Install: claude install-skill zapier/awesome-zaps
# Create claims database entry from updated sheet rows
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/create-claims-database-entry-from-updated-sheet-rows. Read the files there if this skill was installed on its own.
## What it does
1. **Trigger:** a row in your claims sheet is updated (`google-sheets`, `updated_row_only`, "Updated Spreadsheet Row").
2. **Filter:** if the row has no Claim ID, the run stops and writes nothing.
3. **Zapier Tables** looks for a record whose Claim ID matches. If one exists, the run stops: the claim is already in the table.
4. **Zapier Tables** creates a record with the claim ID, claimant name, policy number, claim amount, status, received-at time, and a link to the sheet row.
The Zap only skips duplicates. It never updates or deletes a claim record that already exists.
## 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 |
| ----------------- | ----------- | -------------------------------------------------------------------------- |
| `SPREADSHEET_ID` | `config.ts` | The claims spreadsheet, looked up from the user's Google Sheets connection |
| `CLAIMS_TABLE_ID` | `config.ts` | The Zapier Table that receives the claims, taken from its URL |
Also review the defaults with them: `WOR