← ClaudeAtlas

create-contractor-bid-emails-from-updated-sheet-rowslisted

Build a Zap on Zapier that, when a bid request row in a project sheet is updated, creates a draft email to the contractor with the project details and marks the row as drafted so it is not drafted twice. Use when a construction or renovation business tracks bid requests in a Google Sheet and wants contractor bid emails drafted for review, not sent automatically.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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