Score and review nonprofit grant opportunities with Google Sheets
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 workflow has 21 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Read New Grants from Sheets (Google Sheets): uses Google Sheets
- Execute Grant Validation Code (Code): runs custom JavaScript code
- Check Validation Status (If): checks a condition and branches into true / false
- Read Organization Profile from Sheets (Google Sheets): uses Google Sheets
- Build Validation Update Data (Edit Fields (Set)): sets 4 fields: status, validation_status, validation_errors…
- Read Existing Grants from Sheets (Google Sheets): uses Google Sheets
- Log Validation Error in Sheets (Google Sheets): update
- Identify Duplicate Grants (Code): runs custom JavaScript code
- Check Duplicate Status (If): checks a condition and branches into true / false
- Build Duplicate Grant Update (Edit Fields (Set)): sets 4 fields: status, duplicate_reason, website…
…plus 9 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 (6)
- If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow monitors a Google Sheets grant queue, validates and de-duplicates new grant opportunities, scores each grant against an organization profile, generates a structured recommendation summary, then appends the scored record to a grant…