create-contractor-bid-emails-from-updated-sheet-rowslisted
Install: claude install-skill zapier/awesome-zaps
# Create contractor bid emails from updated sheet rows
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/create-contractor-bid-emails-from-updated-sheet-rows. Read the files there if this skill was installed on its own.
## What it does
1. **Trigger:** an existing row in the tracker worksheet is updated (`google-sheets`, `updated_row_only`, Updated Spreadsheet Row). New rows do not trigger it.
2. **Filter:** the run stops if the row has no contractor email, or if its Drafted column already says `Yes`. The second check is what stops the row's own update from drafting it again.
3. **Gmail** creates a draft to the contractor's email. The subject is the project reference and location. The body has the project reference, location, details, description and a billing notice.
4. **Google Sheets** updates the same row: Drafted becomes `Yes` and Drafted At gets the time.
The Zap only creates drafts. It never sends an email; a coordinator reviews each draft in Gmail before sending.
## 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 | What goes there |
| ------------------------ | ------------------------------------------------------------------------------------------------------ |
| `REPLACE_SPREADSHEET_ID` | The Google Sheet that ho