{"product_id":"n8n-workflow-weekly-vendor-update-emails-google-sheets-gmail","title":"n8n Workflow: Weekly Vendor Update Emails (Google Sheets + Gmail)","description":"\u003ch3\u003eAutomatically generate weekly vendor update emails from your Google Sheet—ready as Gmail drafts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow creates friendly weekly vendor update emails every Friday. It reads your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “Vendors” data, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to draft each message from your figures and notes, and saves everything as \u003cstrong\u003eGmail drafts\u003c\/strong\u003e—so nothing goes out unchecked.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled or on-demand:\u003c\/strong\u003e Runs every Friday at \u003cstrong\u003e9am\u003c\/strong\u003e (or you can run it manually using \u003cem\u003eExecute workflow\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads vendor listings:\u003c\/strong\u003e Pulls the current week’s viewings, enquiries, total viewings, feedback notes, and agent notes from a Google Sheet tab named \u003cstrong\u003eVendors\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters the right rows:\u003c\/strong\u003e Keeps only rows marked \u003cstrong\u003eactive\u003c\/strong\u003e and that include a \u003cstrong\u003evendor email address\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts the emails with OpenAI:\u003c\/strong\u003e Sends each listing to OpenAI with a short prompt to use only the provided figures\/notes, keep the tone friendly and brief, and \u003cstrong\u003eleave pricing and offers for the agent to discuss\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates drafts for approval:\u003c\/strong\u003e Adds your signature and saves each update as a \u003cstrong\u003eGmail draft\u003c\/strong\u003e for you to review and send—no automatic sending.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUK estate agencies sending consistent weekly updates to vendors who want visibility on viewings, enquiries, and feedback.\u003c\/li\u003e\n  \u003cli\u003eSmall property teams with multiple listings who want to avoid writing the same type of email every week.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up a controlled \u003cstrong\u003eGoogle Sheets + Gmail\u003c\/strong\u003e publishing workflow with human approval via drafts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Credentials:\u003c\/strong\u003e Google Sheets, OpenAI, Gmail (you add your own credentials in n8n; none included in the template).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes:\u003c\/strong\u003e set, code, gmail, filter, sticky note, google sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Paste your sheet URL into the “Read vendor listings” node; complete the Settings node (agency name, your name, signature).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomization:\u003c\/strong\u003e Edit the \u003cstrong\u003eSYSTEM_PROMPT\u003c\/strong\u003e in “AI instructions” to change tone\/length; choose a different model in “OpenAI chat model”; adjust the schedule (e.g., “Every Friday at 9am”).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244557914291,"sku":"N8N-21103","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/W9Ukk9hSnWaS3cph3ip0B_fGiQqNwc.png?v=1792401946","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-weekly-vendor-update-emails-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}