{"product_id":"n8n-farm-box-share-harvest-email-automation-with-gpt-and-gmail","title":"n8n Farm Box Share \u0026 Harvest Email Automation with GPT and Gmail","description":"\u003ch3\u003eCatch every CSA box change—then confirm, log, and notify automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Farm Box Share \u0026amp; Harvest Email Automation\u003c\/strong\u003e workflow turns member box change requests into fast confirmations: it classifies each request with \u003cstrong\u003eGPT\u003c\/strong\u003e, drafts the message, logs it to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails the member. It also runs your \u003cstrong\u003eweekly harvest newsletter\u003c\/strong\u003e every Thursday and sends \u003cstrong\u003eMonday balance reminders\u003c\/strong\u003e to keep your farm inbox in sync.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses Box Change Request Form submissions\u003c\/strong\u003e (skip, pause, pickup swap, box size change, or other changes) submitted by CSA members.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates requests\u003c\/strong\u003e by mapping form fields, stamping \u003cem\u003ereceived_at\u003c\/em\u003e, and generating a request_id (example: \u003ccode\u003eREQ-20261005\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses GPT (gpt-6-luna)\u003c\/strong\u003e to classify the request and draft a short member confirmation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs completed requests\u003c\/strong\u003e to the \u003cstrong\u003eRequests\u003c\/strong\u003e tab in Google Sheets, while \u003cstrong\u003eincomplete requests\u003c\/strong\u003e are routed to the \u003cstrong\u003efarm inbox\u003c\/strong\u003e instead of being saved.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends every Thursday at 07:00\u003c\/strong\u003e a harvest newsletter to \u003cem\u003eactive members\u003c\/em\u003e, based on the member roster and this week’s harvest list—with each send logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends every Monday at 08:00\u003c\/strong\u003e friendly balance reminders to members with an amount due, including a farm summary reported to the farm inbox.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA member updates their delivery schedule last minute (pause\/skip\/pickup swap) and needs an immediate, accurate confirmation.\u003c\/li\u003e\n  \u003cli\u003eYour admin team wants a reliable audit trail of all box changes without manual copy\/paste into Sheets.\u003c\/li\u003e\n  \u003cli\u003eWeekly harvest updates and Monday balance sweeps should run on schedule and reach the right recipients automatically.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow scheduler:\u003c\/strong\u003e Thursday 07:00 newsletter; Monday 08:00 balance sweep.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eForm trigger + normalization:\u003c\/strong\u003e Form submission mapped in a normalization step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGPT classification + drafting:\u003c\/strong\u003e \u003cem\u003egpt-6-luna\u003c\/em\u003e classifies request type and drafts confirmation text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail:\u003c\/strong\u003e \u003cstrong\u003eGmail\u003c\/strong\u003e integration sends member confirmations and newsletters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogging:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e records request outcomes and newsletter send activity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes noted:\u003c\/strong\u003e if, set, code, gmail, sticky note, form trigger.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eLast updated: October 2026.\u003c\/em\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192879173811,"sku":"N8N-20443","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/J65wZSKNGHA4_Fy35GN78_npifOLmS.png?v=1791538224","url":"https:\/\/buyflowscripts.com\/products\/n8n-farm-box-share-harvest-email-automation-with-gpt-and-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}