Monthly villa rental calculator with requests to Telegram
A calculator for letting villas and apartments for a few months: property, length of stay, season, guests and services, with the monthly price multiplied by the stay. A placed request becomes a message for the managers' bot and a row in the sheet. A demo built for this portfolio; the company is made up.
Demo calculator, it runs on this page
Monthly rental, Quiet Bay villas
The company is made up, the price list is a placeholder and the total is shown in price-list units. The order goes nowhere: once you place it, the message for the staff bot and the row for the sheet appear below, exactly as Telegram and Google Sheets would receive them.
Message in the staff Telegram bot
The buttons under the message work: press one and the status changes in the message and in the sheet row. In the real setup n8n changes it.
Row in the orders sheet
| Created | Order | Name | Contact | Items | Total | Date | Status |
|---|---|---|---|---|---|---|---|
What the calculator sends to the n8n webhook
- What it counts
- Monthly price × stay, season as a factor
- Managers' bot
- Request with Accept, Ask and Decline buttons
- Sheet
- One row per request, status set by a button
- Stack
- Astro, JavaScript, n8n, Telegram, Google Sheets
-
How it works: the calculator sends the request to an n8n webhook, n8n checks the total against the price lines, posts a message with buttons to the managers' Telegram bot and appends a row to Google Sheets. A pressed button changes the status in that same row.
What it counts. The stay in months is the multiplier. The property, the extra-guest charge, the cleaning and the scooter are multiplied by it, while the transfer, early check-in and the cot are counted once. The arrival season adjusts the total by a factor. The lines under the total show which part is counted per month and which part once.
How it works. On “Place order” the calculator sends the chosen property, the stay, the services, the price lines, the total and the guest’s contacts to an n8n webhook. n8n recalculates the total from the lines and flags the request if it does not match, assigns a number and posts a message to the managers’ chat with Accept, Ask and Decline buttons. A row is then appended to Google Sheets. The manager who presses the button takes the request, and the status changes in the message and in the sheet row.
Download. The n8n workflow for this chain imports through Import from File. The Telegram and Google credentials are connected after the import. The last node can be swapped for a CRM such as HubSpot or Pipedrive, where the request lands in the pipeline.
This is a demo. The company, the properties, the price list and the requests are made up; the calculator was built for this portfolio. Nothing is sent: the message and the row are shown as the bot and the sheet would receive them.
How I work. You send the list of properties, the seasons and the services; I build the calculator and the chain on your n8n, Telegram and Google accounts, show it on test requests and hand it over with a short guide. Communication in writing.