{"product_id":"n8n-workflow-segment-donors-draft-personal-messages","title":"n8n Workflow: Segment Donors \u0026 Draft Personal Messages","description":"\u003ch3\u003eInstantly segment your donors and generate personalized message drafts in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e automatically pulls donor records from Google Sheets, validates and segments them using \u003cstrong\u003eRFM + engagement signals\u003c\/strong\u003e, then generates a \u003cstrong\u003epersonalized outreach draft\u003c\/strong\u003e using a local \u003cstrong\u003eOllama (Llama 3.1)\u003c\/strong\u003e model. It writes the final \u003cstrong\u003e“Personalized Message”\u003c\/strong\u003e back to your sheet—and logs any bad rows to an \u003cstrong\u003eInvalid Rows\u003c\/strong\u003e tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually or on a monthly schedule\u003c\/strong\u003e and reads donor rows from your Google Sheets spreadsheet (e.g., the \u003cem\u003eDonor Data\u003c\/em\u003e tab).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e such as \u003cstrong\u003eName\u003c\/strong\u003e and \u003cstrong\u003eEmail\u003c\/strong\u003e, normalizes donation amount\/date, \u003cstrong\u003ededuplicates identical rows\u003c\/strong\u003e, and tags each row as valid or invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends\/updates invalid entries\u003c\/strong\u003e into a separate Google Sheets tab called \u003cstrong\u003eInvalid Rows\u003c\/strong\u003e for easy review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates RFM scores\u003c\/strong\u003e (recency, frequency, monetary), assigns an \u003cstrong\u003eRFM segment\u003c\/strong\u003e, and adds latest donation details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePerforms behavioral segmentation\u003c\/strong\u003e based on event attendance and pre-donation communications, then maps each combined segment to a \u003cstrong\u003etone and ask strategy\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates draft outreach per donor\u003c\/strong\u003e via Ollama using \u003cstrong\u003eLlama 3.1\u003c\/strong\u003e, validates the output, and uses a predefined template fallback if the draft is empty\/malformed\/too long.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the original sheet\u003c\/strong\u003e with the final personalized message and review flags.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNonprofits or SaaS operators wanting \u003cstrong\u003etargeted donor follow-ups\u003c\/strong\u003e without manual segmentation work.\u003c\/li\u003e\n  \u003cli\u003eTeams refreshing donor outreach monthly with \u003cstrong\u003eRFM-based prioritization\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a reliable pipeline that \u003cstrong\u003ehandles bad spreadsheet data\u003c\/strong\u003e automatically.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuilt in n8n using nodes such as \u003cstrong\u003eManual Trigger\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003emerge\u003c\/strong\u003e (plus documentation\/sticky notes).\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOllama (Llama 3.1)\u003c\/strong\u003e to draft messages from segment-specific tone\/ask strategy.\u003c\/li\u003e\n  \u003cli\u003eValidates model output and falls back to a predefined template when needed.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008720523443,"sku":"N8N-19509","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OK8gpEji1DJ3Wt4-gj76B_jU8z4BF2.png?v=1789203887","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-segment-donors-draft-personal-messages","provider":"N8N Commerce","version":"1.0","type":"link"}