n8n Workflow: Auto Send Donation Receipts via Gmail + DeepSeek

Auto-send donation thank-you receipts from Google Sheets—powered by DeepSeek and Gmail

This n8n workflow monitors your Google Sheets “Donations” log, validates each new donation, generates a personalized thank-you receipt email using DeepSeek (via the OpenAI API), and sends it automatically through Gmail. It also keeps your team informed in Telegram and delivers a weekly donation digest.

What this workflow does

• Detects new donations: Triggers when a new row is added to the Google Sheets “Donations” worksheet (polled every minute).
• Normalizes & validates data: Creates a donation ID and timestamp, applies default values, then checks that donor name, donor email, and a positive amount are present.
• Handles invalid entries: If a row is invalid, it sends an alert to Telegram and emails a review notice via Gmail so the sheet can be corrected.
• Generates personalized receipt content: For valid donations, it uses a LangChain agent with the DeepSeek chat model plus a Google Sheets donor-history tool to produce JSON containing tier, subject, body, and a major-donor flag.
• Sends the thank-you/receipt: Logs details to the “ThankYouLog” worksheet and emails the donor via Gmail (including receipt details).
• Escalates major donations: If flagged as major (AI-flagged or amount ≥ 1,000,000), it posts a Telegram alert and emails the executive director via Gmail for personal outreach.
• Weekly reporting: Every Monday at 09:00, 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).

Use cases

• Nonprofits wanting automated donation receipt emails without manual follow-up.
• SaaS operators managing donation logs in Google Sheets and needing dependable Gmail delivery.
• Automation engineers building an auditable email + logging system with weekly summaries.

Technical details

• Trigger: New row added to Google Sheets “Donations” (polled every minute).
• Logic nodes: if, set, code, sticky note.
• AI integration: DeepSeek chat model using OpenAI API through a LangChain agent.
• Messaging: Gmail for donor emails + weekly digests; Telegram for alerts.
• Data storage: Google Sheets “ThankYouLog” for generated receipt/message logging.