Generate pool service visit reports with Google Sheets, Gemini, Gmail, Slack, and Telegram
Needs changesWhat this workflow does
This AI workflow has 32 nodes and runs when someone submits an n8n form (“Pool Service Visit”) (plus 2 other triggers). Along the way it connects Google Sheets, Telegram, Google Gemini Chat Model and Gmail and 1 more.
How it runs
Trigger: When someone submits an n8n form (“Pool Service Visit”) (plus 2 other triggers).
- Fetch Customer Details (Google Sheets): uses Google Sheets
- Fetch Open Work Orders (Google Sheets): uses Google Sheets
- Send Error Alert to Telegram (Telegram): uses Telegram
- If: checks a condition and branches into true / false
- Compile Daily Digest (Code): runs custom JavaScript code
- Fetch Visit History (Google Sheets): uses Google Sheets
- Send Unknown Customer Alert (Telegram): uses Telegram
- Send Digest to Telegram (Telegram): uses Telegram
- Prepare Agent Context (Code): runs custom JavaScript code
- Structure Notes Agent (AI Agent): runs an AI agent, with model: Google Gemini Model; output parser: Parse Structured Output
…plus 17 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Structure Notes Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Structure Notes Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (13)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow collects pool service visit notes via an n8n Form, looks up customer and history in Google Sheets, uses Google Gemini to structure the notes into a report, logs visits and work orders back to Sheets, and sends alerts via Gmail,…