Черновики еженедельных писем поставщикам из Google Sheets с помощью OpenAI и Gmail

## Weekly vendor update drafts (Google Sheets + OpenAI + Gmail) Free starter template by Burnt & Toast Kits, for UK estate agents. What it does: every Friday morning it reads your vendor listings sheet, asks OpenAI to write a short, friendly weekly update for each active vendor from that week's viewings, enquiries and feedback, and saves each one as a Gmail draft for you to check and send. It never sends anything by itself. Setup (10 minutes) 1. Make a Google Sheet with a tab called Vendors and these columns: vendor_name, vendor_email, property_address, status, viewings_this_week, enquiries_this_week, total_viewings, feedback_notes, agent_notes. 2. Add credentials: Google Sheets (read node), OpenAI (chat model), Gmail (draft node). 3. Paste your sheet URL into Read vendor listings. 4. Fill in Settings (agency name, your name, signature). 5. Run it once with Execute workflow, check the drafts in Gmail, then activate. Only rows with status active and a vendor email are drafted. Want the full version? Vendor Update Autopilot adds tuned prompts, a UK compliance checklist, matching your agency's voice, edge cases such as offers and price concerns routed to a person, and a step-by-step setup guide: https://kits.burntandtoast.com/estate-agents/kits/vendor-update-autopilot