{"product_id":"n8n-workflow-auto-send-donation-receipts-via-gmail-deepseek","title":"n8n Workflow: Auto Send Donation Receipts via Gmail + DeepSeek","description":"\u003ch3\u003eAuto-send donation thank-you receipts from Google Sheets—powered by DeepSeek and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your Google Sheets “Donations” log, validates each new donation, generates a personalized thank-you receipt email using \u003cstrong\u003eDeepSeek (via the OpenAI API)\u003c\/strong\u003e, and sends it automatically through \u003cstrong\u003eGmail\u003c\/strong\u003e. It also keeps your team informed in \u003cstrong\u003eTelegram\u003c\/strong\u003e and delivers a weekly donation digest.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects new donations\u003c\/strong\u003e: Triggers when a new row is added to the Google Sheets “Donations” worksheet (polled every minute).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes \u0026amp; validates data\u003c\/strong\u003e: Creates a donation ID and timestamp, applies default values, then checks that donor name, donor email, and a positive amount are present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles invalid entries\u003c\/strong\u003e: If a row is invalid, it sends an \u003cstrong\u003ealert to Telegram\u003c\/strong\u003e and emails a \u003cstrong\u003ereview notice via Gmail\u003c\/strong\u003e so the sheet can be corrected.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates personalized receipt content\u003c\/strong\u003e: For valid donations, it uses a \u003cstrong\u003eLangChain agent\u003c\/strong\u003e with the \u003cstrong\u003eDeepSeek chat model\u003c\/strong\u003e plus a \u003cstrong\u003eGoogle Sheets donor-history tool\u003c\/strong\u003e to produce JSON containing tier, subject, body, and a major-donor flag.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the thank-you\/receipt\u003c\/strong\u003e: Logs details to the “ThankYouLog” worksheet and emails the donor via Gmail (including receipt details).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates major donations\u003c\/strong\u003e: If flagged as major (AI-flagged or amount ≥ 1,000,000), it posts a Telegram alert and emails the \u003cstrong\u003eexecutive director\u003c\/strong\u003e via Gmail for personal outreach.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly reporting\u003c\/strong\u003e: Every Monday at \u003cstrong\u003e09:00\u003c\/strong\u003e, it reads “ThankYouLog,” calculates weekly donation stats, generates an AI digest, and sends it via Gmail and Telegram (or sends an all-clear if none).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNonprofits wanting automated donation receipt emails without manual follow-up.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing donation logs in Google Sheets and needing dependable Gmail delivery.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an auditable email + logging system with weekly summaries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger\u003c\/strong\u003e: New row added to Google Sheets “Donations” (polled every minute).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic nodes\u003c\/strong\u003e: if, set, code, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI integration\u003c\/strong\u003e: DeepSeek chat model using \u003cstrong\u003eOpenAI API\u003c\/strong\u003e through a LangChain agent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging\u003c\/strong\u003e: Gmail for donor emails + weekly digests; Telegram for alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage\u003c\/strong\u003e: Google Sheets “ThankYouLog” for generated receipt\/message logging.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865764847795,"sku":"N8N-18361","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1BDw7g2Z245IN8kPnD19q_A3QUK0tk.png?v=1787044551","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-send-donation-receipts-via-gmail-deepseek","provider":"N8N Commerce","version":"1.0","type":"link"}