Track government grants with OpenRouter AI, RSS feeds, Google Sheets & Gmail
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.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - RSS Read
n8n-nodes-base.rssFeedRead - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail
What it does
How it works This workflow automatically fetches the latest public grant information from the Ministry of Health, Labour and Welfare (MHLW) RSS feed. It uses AI to summarize and structure each grant post into a clear format, stores the results in Google Sheets, and sends a formatted HTML summary via Gmail. Workflow summary 1. Schedule Trigger – Runs the flow daily or weekly. 2. RSS Feed Reader – Fetches the latest MHLW news and updates. 3. Text Classifier (AI) – Categorizes the item as “Grant/Subsidy”, “Labor-related”, or “Other”. 4. AI Agent – Extracts structured data such as title, summary, deadline, amount, target, and URL. 5. Google Sheets – Appends or updates the database using the grant title as the key. 6. Code Node – Builds an HTML report summarizing new entries. 7. Gmail – Sends a daily digest email to your inbox. --- Setup steps 1. Add your OpenRouter API key as a credential (used in the AI Agent). 2. Replace the Google Sheets ID and sheet name with your own. 3. Update the recipient email address in the Gmail node. 4. Adjust the schedule trigger to match your preferred frequency. 5. (Optional) Add more RSS feeds if you want to monitor other sources. --- Ideal for - Consultants or administrators tracking subsidy and grant programs - Small business owners who want automatic updates - Anyone who wants a daily AI-summarized government grant digest --- ⚙️ Note: Detailed explanations and setup hints are included as Sticky Notes above each node inside the workflow.