← ClaudeAtlas

create-claims-database-entry-from-updated-sheet-rowslisted

Build a Zap on Zapier that copies each updated row of an insurance claims sheet into a Zapier Table as a claim record, once per claim ID, with a link back to the row. Use when a claims or intake team tracks claims in Google Sheets and wants a structured, deduplicated claims database in Zapier Tables without manual copying.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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