Telegram bot for tennis court booking with Google Sheet

This automation streamlines tennis court reservations: users send requests via Telegram, and the AI-powered system parses the message, checks time slot availability in Google Sheets, confirms the booking, and sends a confirmation email. It reduces admin workload and improves user experience.

## Who it´s for
- Sports club administrators managing court bookings
- Coaches and players who want to book slots without manual coordination
- Owners of private tennis clubs aiming to automate customer service

## What the automation does
- Receives booking requests from Telegram
- Uses LangChain and Google Gemini to extract date, time, name, and email from messages
- Checks slot availability in Google Sheets
- Saves confirmed reservations upon approval
- Sends response back in Telegram and delivers confirmation email via Gmail
- Stores conversation history in PostgreSQL to maintain context across interactions

## What´s included
- Ready-to-use n8n workflow
- Trigger and message handler logic
- Integrations with Telegram, Google Sheets, Gmail, and PostgreSQL
- Basic text guide for launch and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Access to Telegram Bot API
- Google account with enabled Sheets API
- Gmail account with sending permissions
- PostgreSQL database access

## Benefits and outcomes
- Fully automated booking process without staff intervention
- Reduced errors from manual entry
- 24/7 request processing
- User-friendly interface via Telegram
- Centralized data storage in Google Sheets and conversation logs
- Scalable to multiple courts and locations

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via в чате.