How to log call results in Google Sheets: columns, rules and formulas
Sado AI team · · 4 min read
In short
Without a CRM, Google Sheets is enough for call results: one call, one row. Columns: date and time, phone, name, need, outcome, next step and owner. Always write numbers in one format, make the outcome column a drop-down list, freeze the header and share the sheet only with staff. A simple formula gives you the daily numbers. With an AI operator connected, every request is written to the sheet automatically, and the operator calls the customer in each new row itself.
When a sheet is enough
One or two staff, dozens of calls a day and a simple sales process: Google Sheets will do. It’s free, opens on a phone, and everyone sees the same sheet.
Once you have more managers, work with one customer for months, or need reminders and tasks, it’s time for a CRM. The difference: CRM call logging.
The columns
For example, for Salqin Uy, a company that installs air conditioners:
| Column | Example | Note |
|---|---|---|
| Date and time | 05.11.2026 14:20 | Date and hour in one format |
| Phone | +998 XX XXX XX XX | Always the same way, or search won’t work |
| Name | Gulnora | Leave blank if unknown |
| Need | Install 2 air conditioners | One short phrase |
| Outcome | Booked | From the list only: Booked, Thinking, Declined, No answer |
| Next step | Thursday 11:00, installation | With a date |
| Owner | Bekzod | Who does it |
Rules that keep the sheet tidy
- One call, one row. Don’t delete old rows: if the customer calls again, add a new one.
- Give the Outcome column a drop-down list (data validation in the Data menu). Free text like “ok”, “fine”, “later” breaks the counts.
- Freeze the first row and turn on the filter, so you find every “No answer” in one click.
- Share only with staff work accounts. Remove anyone who leaves at once, and never share the sheet by public link.
- Write only what you need: name, phone, need. Passport or card details never go into the sheet.
Fifteen minutes a week: reviewing the sheet
- Filter the “No answer” rows: call them back or send a text.
- Among the “Thinking” rows, find those whose next-step date has passed, and call today.
- Hand out rows with an empty Owner: a row without an owner is a forgotten customer.
- Look for repeated numbers: someone who called three times in a week never got an answer.
Formulas for the daily count
- Total calls: =COUNTA(B2:B), the number of filled cells in the phone column.
- Booked: type the word “Booked” into cell H1, then =COUNTIF(E2:E;H1).
- Share: =COUNTIF(E2:E;H1)/COUNTA(B2:B), with the cell set to percent format.
- Depending on the sheet’s locale, you may need a comma instead of a semicolon: if the formula errors, swap the separator.
For example, 140 calls in a week, 42 marked “Booked”: 42 ÷ 140 = 30%. These numbers are only an example. Note the share every week, and you’ll see the difference when your ads or script change.
When an AI operator fills in the sheet
Sado’s operator answers the call and asks your questions, and every request is written to the sheet, so nobody copies anything by hand. Our team makes the first Google Sheets connection with you.
It works the other way too: if your website or form writes requests to the sheet, the operator calls the customer in each new row and writes the result back into the same sheet. The recording and full transcript stay in the Sado portal, and results also download to Excel. More: AI outbound calls, an AI operator for incoming calls and calling a list from Excel or Google Sheets. Try it live or call 78 778 01 23.
Questions
Is it hard to connect Google Sheets to Sado?
No. Sado’s team makes the first connection with you; no code is needed on your side.
Can staff fill in the sheet from a phone?
Yes, in the Google Sheets app. Drop-down lists work on phones too, so outcomes are still written with the same words.
A sheet or a CRM: which do I need?
With few calls and one or two staff, a sheet is enough. Once you have more managers and need reminders, move to a CRM; Bitrix24 has a ready connection, for example.
May we keep customer details in the sheet?
Yes, but only what’s needed, and never share the sheet by public link. Uzbekistan has a law on personal data; if in doubt, ask a lawyer.