Track grant deadlines and spend down with OpenAI, Google Sheets, Gmail and Telegram
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 58 nodes and runs when an HTTP POST request hits its webhook URL (plus 3 other triggers). Along the way it connects OpenAI Chat Model, Google Sheets, Gmail and Telegram.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 3 other triggers).
- Normalize award record (Edit Fields (Set)): sets 13 fields: award_id, funder, program…
- Normalize spend entry (Edit Fields (Set)): sets 6 fields: spend_id, award_id, amount_spent…
- Read deadlines for sweep (Google Sheets): uses Google Sheets
- Read awards for review (Google Sheets): uses Google Sheets
- Validate award fields (If): checks a condition and branches into true / false
- Validate spend entry (If): checks a condition and branches into true / false
- Compute deadline risk (Edit Fields (Set)): sets 11 fields: deadline_id, award_id, funder…
- Combine award portfolio (Aggregate): combines items into one
- AI plan reporting calendar (AI Agent): runs an AI agent, with model: Grant calendar model
- Build rejected award alert (Edit Fields (Set)): sets 8 fields: error_id, source, reason…
…plus 40 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 (12)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram - Split Out
n8n-nodes-base.splitOut - Limit
n8n-nodes-base.limit - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Aggregate
n8n-nodes-base.aggregate
From the author
Grant deadlines and budgets that chase you instead of the other way around. This workflow logs awards and spend-downs in Google Sheets, turns award terms into a reporting calendar, drafts reminders and finance notes with AI, and keeps the grant lead in the…