If your bookings live in an Excel tracker, an AI phone agent can answer the calls about them: a guest quotes their booking reference or is recognised by the number they are calling from, and hears their own dates, room, session or pickup time read back. Two things are worth separating from the start. Looking up an existing booking comes from your imported sheet. Taking a new booking is a different job, and a booking made on a call arrives with you as a booking and an email; it is not written back into your spreadsheet.
Guesthouses, holiday rentals, driving schools, studios, course providers and equipment hire all end up with the same file: one row per booking, columns for the guest, the dates, what they booked, a deposit, maybe a note about a late arrival.
The bookings themselves are not the problem. The calls around them are, and they are almost all confirmations: what time does my course start, which room am I in, is my deposit received, can I check in late, what was the address again. The guest has the confirmation email somewhere and cannot find it, so they ring, and the answer is in a row you cannot reach while you are changing a bed or teaching.
Out of season and out of hours it is worse. A call at nine in the evening about tomorrow's arrival is exactly the call worth answering, and exactly the one that goes to voicemail.
With PhoneMyAgent you upload the tracker (.xlsx, .csv or .json) on the Data page. The import asks which column callers quote, a booking reference in most trackers, and what the agent should say back, in a sentence you approve: "Booking B-204 for two nights from 14 August, arrival from 3pm, deposit received." Columns you do not map, the rate you gave them, a note about a previous stay, are stored but never spoken.
On a call the agent looks up exactly the reference given. If your sheet has a phone column, a guest ringing from the number on their booking is recognised without quoting anything. If a guest has several bookings, it reads the five most recent and says there are more. If nothing matches, it says so and takes a message rather than improvising a date, which is the failure that would actually cost you a guest. You can test the whole thing on your own number with 45 free minutes and no card.
Where a booking sheet earns its keep is dates. When your tracker has a date column, lookups come back newest first, so a returning guest hears about the stay coming up rather than the one from March.
This is the distinction worth understanding before you set it up, because it decides what your morning routine looks like.
So for a week where you take new reservations by phone, the sheet is still yours to maintain. What the agent removes is the confirmation traffic, which is the larger and duller half of the calls.
| Voicemail | Confirmation email | Online booking system | Excel tracker on the phone | |
|---|---|---|---|---|
| Answers "what time is mine" | No | If they find it | If they log in | Yes, on the first ring |
| Works for a guest with no email to hand | No | No | Rarely | Yes |
| Covers evenings and the season peak | Message only | Yes | Yes | Yes |
| Migration needed | None | None | Yes, all of it | None, upload the sheet |
| Cost | Cheap | Free | Monthly, per property | A monthly plan |
It reads back the booking in the caller's own row, takes messages, books when you allow it, and transfers on request. It will not move or cancel a booking in your spreadsheet, will not guess between two possible rows, will not speak unmapped columns, and does not handle emergencies or give regulated advice. Callers hear at the start that they are speaking with an AI assistant, and every lookup is recorded on the call log next to the transcript.
There is no live sync with Excel or Google Sheets: import is an upload, export is a download, and you can pull the whole table back into a spreadsheet whenever you like. For a tracker that changes a few times a day this is a small habit. For a system that changes every few minutes, it is the wrong tool and better said now.
Hotels and guesthouses that also field rate and availability questions may want the small hotel walkthrough alongside this, and the overview of the different spreadsheet agents is in which kind of Excel AI agent you need.
Yes. You import the tracker, choose the column guests quote (usually a booking reference), and approve the sentence the agent reads back. On a call it looks up that exact booking and reads back only the columns you mapped, or takes a message if nothing matches.
Yes, if you switch booking on, but it works separately from your spreadsheet. New bookings come to you as bookings plus the after-call email; they are not written into your imported Excel file. Looking up existing rows and taking new bookings are two different capabilities and you can use either or both.
No. Lookups are read-only, and your original file is never touched at all. Rows change only when you edit them in the dashboard or upload a new version of the sheet, and you can export the table back to Excel at any time.
If your tracker has a phone column, a guest calling from the number on their booking is recognised automatically. Otherwise the agent asks, and if they cannot produce a reference, it takes a message with their number and what they wanted so you can call back with the answer already in hand.
Yes. The agent reads back the five most recent and says there are more rather than presenting a partial list as if it were complete. Where your sheet has a date column, the most recent come first, so the upcoming stay is what a guest hears about.
Any business whose bookings sit in a spreadsheet rather than a booking system: guesthouses and holiday rentals, driving schools and course providers, studios, salons that keep a paper-style diary in Excel, and equipment hire. The requirement is only that each row belongs to one customer and can be identified by a reference or their number.
Never miss another call
An AI agent answers your business phone, knows your documents, and emails you what happened after every call. 45 free minutes to try, no card required.
Try PhoneMyAgent free