# Generate pool service visit reports with Google Sheets, Gemini, Gmail, Slack, and Telegram

> 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, Slack, and Telegram. How it works 1. Receives a pool service visit submission from an n8n Form with customer ID, technician notes, and optional water readings. 2. Looks up the customer in Google Sheets and sends a Telegram alert if the customer ID is unknown. 3. Pulls the customer’s recent visit history from Google Sheets and combines it with the new readings to generate rule-based flags for out-of-range chemistry and high filter pressure. 4. Sends the combined context to Google Gemini to extract structured fields (condition, issues, actions, follow-up, summaries) and validates the response against a strict JSON schema. 5. Builds a visit record with an HTML customer report, calculates urgency, priority, and next visit date, and appen

- **Domain**: `n8n-workflow-20429.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20429
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20429.n8n.io
- Documentation: https://n8n.io/workflows/20429