Send donor thank-you receipts and weekly digests with Google Sheets, DeepSeek, Gmail and Telegram
Ready for 3.0What this workflow does
This AI workflow has 26 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Google Sheets, Telegram, Gmail and OpenAI Chat Model.
How it runs
Trigger: On Google Sheets events (row added) (plus 1 other trigger).
- Normalize Donation (Edit Fields (Set)): sets 10 fields: donation_id, received_at, donor_name…
- Read Thank You Log (Google Sheets): uses Google Sheets
- Validate Donation (If): checks a condition and branches into true / false
- Build Weekly Donor Stats (Code): runs custom JavaScript code
- AI Donor Thank You Writer (AI Agent): runs an AI agent, with model: DeepSeek Donor Model; 1 tool (Donor History Tool)
- Telegram: uses Telegram
- If: checks a condition and branches into true / false
- Parse AI Thank You (Edit Fields (Set)): sets 11 fields: tier, subject, body…
- Email Invalid Donation Notice (Gmail): uses Gmail
- Email No Donation All Clear (Gmail): uses Gmail
…plus 11 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code
From the author
Every donor thanked, every gift receipted, automatically. This workflow watches your Google Sheets donations log, validates new entries, and has AI draft personalized thank-you emails with receipt details. Big gifts get flagged for personal outreach, and…