{"product_id":"n8n-workflow-segment-donors-personalize-emails-sheets-ollama","title":"n8n Workflow: Segment Donors \u0026 Personalize Emails (Sheets + Ollama)","description":"\u003ch3\u003eAutomatically segment your donors and personalize emails using Google Sheets + Ollama (Llama 3.1)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads donor data from your Google Sheets, validates and segments donors with JavaScript-based RFM + behavioral rules, then generates tailored donor messages using a local Ollama model (Llama 3.1)—and writes the results back to your “Donor Data” sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManually triggered donor processing:\u003c\/strong\u003e Run the workflow on demand to process all donor rows in your Google Sheets document.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize, deduplicate, and validate:\u003c\/strong\u003e It standardizes key fields (email, donation amount, donation date), deduplicates exact duplicate rows, and flags each row as \u003cem\u003evalid\u003c\/em\u003e or \u003cem\u003einvalid\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrack invalid rows:\u003c\/strong\u003e Invalid donor rows are appended or updated in a separate \u003cstrong\u003e“Invalid Rows”\u003c\/strong\u003e sheet for follow-up.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRFM + behavioral segmentation:\u003c\/strong\u003e For valid donors, it calculates \u003cstrong\u003eRFM\u003c\/strong\u003e (recency, frequency, monetary) scores, assigns an RFM segment, and adds behavioral tags based on events attended and prior communications.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersonalized prompt + local AI drafting:\u003c\/strong\u003e Each combined segment maps to a treatment plan (tone, ask type, channel, cadence), builds a per-donor prompt, and sends it to \u003cstrong\u003eOllama (Llama 3.1)\u003c\/strong\u003e to draft a short message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQuality checks + fallback:\u003c\/strong\u003e It validates the draft and falls back to a segment-based template when the model output fails checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites back to Google Sheets:\u003c\/strong\u003e Updates each “Donor Data” row with the \u003cstrong\u003ePersonalized Message\u003c\/strong\u003e, segment tags, and review flags for tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProduce donor outreach for fundraising campaigns from a live Google Sheets list without manual segmentation.\u003c\/li\u003e\n  \u003cli\u003eGenerate consistent, on-brand email content with local LLM support via Ollama.\u003c\/li\u003e\n  \u003cli\u003eMaintain data quality by automatically routing problematic records to an “Invalid Rows” sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n + integrations)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual Trigger\u003c\/strong\u003e to start processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for reading and writing “Donor Data” and “Invalid Rows”.\u003c\/li\u003e\n  \u003cli\u003eCore logic with \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003emerge\u003c\/strong\u003e nodes (plus documentation via \u003cstrong\u003esticky note\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLocal AI\u003c\/strong\u003e generation using \u003cstrong\u003eOllama (Llama 3.1)\u003c\/strong\u003e, with validation and template fallback.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978917601459,"sku":"N8N-19358","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bjuACBXCaqb06eMpc3Rpq_hvR6kYhj.png?v=1788858665","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-segment-donors-personalize-emails-sheets-ollama","provider":"N8N Commerce","version":"1.0","type":"link"}