Triage construction project risk with Google Sheets, Open-Meteo, Gemini, and Gmail

by iamvaar ✓ · 3 views · created 2026-10-05 · Project Management, AI Summarization

What this workflow does

This AI workflow has 17 nodes and runs on a schedule (cron 0 7 * * 1-5). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.

How it runs

Trigger: On a schedule (cron 0 7 * * 1-5).

1. Read Projects from Sheets (Google Sheets): uses Google Sheets
2. Fetch Weather Forecast (HTTP Request): calls an HTTP API
3. Read Budget from Sheets (Google Sheets): uses Google Sheets
4. Read Procurement Details (Google Sheets): uses Google Sheets
5. Read Labor Data Sheets (Google Sheets): uses Google Sheets
6. Read Site Reports Sheets (Google Sheets): uses Google Sheets
7. Read Disputes from Sheets (Google Sheets): uses Google Sheets
8. Calculate Risk Scores (Code): runs custom JavaScript code
9. Limit: keeps the first few items
10. Execute Decision Making Chain (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat; output parser: Parse Structured Output

…plus 4 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Gemini Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Filtern8n-nodes-base.filter
• Gmailn8n-nodes-base.gmail
• Limitn8n-nodes-base.limit

From the author

Quick overview Youtube Video: https://youtu.be/Fh0QR48f9is This workflow runs every weekday morning, reads active construction projects and related data from Google Sheets, pulls a 7-day forecast from Open-Meteo, computes delivery and cost risk scores, and…

View the original on n8n.io → Check your own copy