Free sheet
Find the enquiries nobody answered.
The late enquiry sheet for your agency: a sheet template, three AI prompts and six steps. You end up with last month's Rightmove, Zoopla, OnTheMarket and website enquiries, when each one landed, how long it waited for a first reply, and which ones never got one.
Ashby Lane Estates is made up. So is every number and row here.
Get the late enquiry sheet
The template, the three prompts and the six steps to fill it from last month's enquiries.
This opens an email to us with your address in it. Press send and we'll reply with the sheet. Or write to leo@relign.co. Free. For owners and directors of independent sales and lettings agencies. Works in Google Sheets or Excel 365.Six steps, from emails you already have.
Every portal emails you each enquiry. Your team's replies sit in the sent folders or the CRM log. The sheet lines the two up. Buyers' names and phone numbers come out before anything goes into an AI tool.
1. Set up the sheet
A Google Sheet or Excel 365 workbook with four tabs. Copy the headers and formulas from the template, then type your real opening hours, Saturday included.
Weekday open09:00
Weekday close18:00
Saturday open09:00
Saturday close13:00
2. Pull 30 days of enquiry emails
Save every Rightmove, Zoopla, OnTheMarket and website form email from the shared inbox as one text file. Two find and replace runs strip the phone numbers and names. Then split it into one file per week.
RightmoveNew enquiry: 2 bed flat, Station Road · Sat 21:04
Nameremoved
Phone[phone removed]
3. Turn the emails into rows
Paste the first prompt and one week of emails into your AI tool. It gives back a table, one row per enquiry, that drops straight into the Enquiries tab. Its last line adds up, so you can check nothing went missing.
4. Pull the replies
The sent folders of everyone who answers enquiries, or the activity log from Reapit, Alto, Street or Jupix, which holds the calls too. The second prompt turns them into the Replies tab. Automatic "thanks for your enquiry" emails don't count.
5. Match each enquiry to its first reply
The sheet finds the earliest reply to each enquiry and counts the minutes it waited. If you took the email addresses out too, the third prompt matches by property and time, and flags the ones to check by hand.
=IF(H2="","",ROUND((H2-B2)*1440,0))
Minutes waited: 857, just over 14 hours (made up)
6. Read the summary
Enquiries by hour, day and source, how many landed after hours, and the middle wait in and out of hours. Filter Status to "No reply" and you have the list of people nobody answered, each with the property.
Landed after hours78
Got a reply within an hour71
Waited until the next day or later41
Never got a reply23
Then see them answered in about a minute.
Your leads weren't bad. They were late. Relign answers every enquiry that lands after your office shuts, in about a minute, from your own listings. For the first month, a person approves every message the AI sends.
Get a free AI employee for a week. We build it on your own agency, with your listings and your team, and it works for seven days. Then you decide.
Get the late enquiry sheet.
Leave your email and we'll send you the template, the three prompts and the six steps to fill it from last month's enquiries.
This opens an email to us with your address in it. Press send and we'll reply with the sheet.
