Every phone call, in your CRM by itself

Calls you make, calls you receive, calls you miss. New numbers become leads, known ones get the call on their request, missed calls become call-backs. Set up once with IFTTT and Google Sheets.

November 22, 2026 โ€ข 5 min read โ€ข By eKTextAI
A call placed on an Android phone goes through IFTTT into a Google Sheet, then into the eKTextAI CRM and the Requests page ๐Ÿ“ฑ Call placed 98xxx xxx87 12:31 pm ยท 8 s โšก IFTTT placed ยท answered ยท missed โ†’ add row ๐Ÿ“„ Google Sheet time ยท number ยท name ยท seconds CRM lead new, or notes updated Request ๐Ÿ“ž call on the activity
One applet on the phone, one script in the sheet. After that, nobody types a call log again.

Your counsellor called eleven parents this morning, and four more called her back. Your sales lead called six prospects between meetings and missed two calls while driving. Ask either of them on Friday who they spoke to on Tuesday, and you will get a scroll through a phone's call history and a best guess.

Calls are the follow-up that matters most, and they are the one thing that almost never reaches the CRM. Nobody has the time to open a laptop after every call and type "called, 2 minutes, will visit Saturday".

So let the phone write the call log for you.

What happens to each call

With the new ๐Ÿ“ž Phone calls (IFTTT) template in eKTextAI, every call made, received or missed on an Android phone arrives in your workspace within minutes, and lands where your team already works:

The number you calledWhat eKTextAI does
Not in the CRM yetAdds them as a new lead (source Phone call, tag source:phone-call), with the call and any other columns of the row in the notes. Makes a request on the Requests page with the call on its activity.
Already a lead, with an open requestAdds the call to the lead's notes and to the activity of their open request: ๐Ÿ“ž Phone call made on 22 Nov 2026, 12:31 pm ยท 0.13 min (8 s).
Already a lead, nothing openAdds the call to their notes and opens a new request, so the follow-up has a place to live.
๐Ÿ“ต A call you missedGoes on the activity as Missed call ยท call back. From a number with no open request, it makes a Call back request, so nobody who rang you is left waiting.

Each call is marked for what it was: ๐Ÿ“ž Phone call made, ๐Ÿ“ฒ Incoming call answered or ๐Ÿ“ต Missed call. An answered call, made or received, moves a New request to In progress, just as logging "Reached" by hand would. A call of 0 seconds is shown as not answered and leaves the request where it was. The same row is never recorded twice, and nobody gets a WhatsApp welcome message after a call: you have just spoken to them.

Your only job after a call: one note

After every call, the entry is already made for you: the person is in the CRM, there is a request on the Requests page, and the call is on its activity with the time and the length. Nobody types any of that.

What eKTextAI cannot know is what was said. So the one thing your team does is this:

  1. Open eKTextAI, Requests, and the request the call made (it is at the top, with ๐Ÿ“ž on it).
  2. Add a note with what was discussed: "Wants Class 3, visiting Saturday 11 am", "Asked for the price list, send by email", "Not interested this year".
  3. Update the request: its status, and the follow-up date if there is a next step.

Thirty seconds per call turns a call log into information you can decide with.

With those notes in place, the owner sees which campaigns bring real conversations, which counsellor or salesperson converts, what people keep asking about, and who is waiting for a call back, without asking anyone.

Personal calls stay personal

Not every call is business. Calls to family, friends and the electrician should not become leads, and nobody should have to explain them in a report.

  • Every call asks first, once per number. Outgoing, incoming or missed, a call's request shows โ“ Personal or business? The owner, or any team member who can see the request, answers with one tap. A number said to be business is not asked again.
  • Business keeps the lead and the request.
  • Personal deletes the lead the call made, the request and the call log. Calls with that number are never recorded again.
  • Team, partners and vendors are ignored too. Mark a person in the CRM (their card, Counted as) as Internal, Partner, Vendor or Personal, and their calls are left out: no lead, no request, nothing in your reports.

๐Ÿ’ก Tip: use a business number. Where you can, give the team a business phone or a second SIM for customer calls, and set IFTTT up on that phone. You get fewer personal calls to sort, and customers keep the same number when someone leaves.

Set it up in 15 minutes

You need an Android phone, an IFTTT account (free to start; see the costs below) and a Google account. Everything else is in eKTextAI.

๐Ÿงฎ What IFTTT costs. IFTTT runs on credits. Its free plan gives 1,000 credits a month, and logging one call uses about 15 credits (the applet shows its exact cost when you create it): roughly 66 calls a month free. Unused credits do not roll over, and when they run out IFTTT pauses the applets: calls made while paused are not logged.

IFTTT planCredits a monthCalls a month, at 15 creditsPrice
Free1,000about 66$0
Starter5,000about 333$2.09 / month, billed yearly
Pro20,000about 1,333$5.49 / month, billed yearly
Pro+100,000about 6,666$13.99 / month, billed yearly

From IFTTT's plans page on 22 November 2026; see it for monthly prices and current terms, and how IFTTT credits work. eKTextAI charges nothing extra for the calls it receives. To make free credits last, log only the calls you make.

See IFTTT plans โ†’
  1. In eKTextAI: open Lead sources, Google Forms and Sheets. Choose ๐Ÿ“ž Phone calls (IFTTT): the name Phone calls is filled in for you, or type your own. Press Add a form or sheet. The page shows the steps and your script with your private address already in it.
  2. On the phone: install IFTTT from Google Play and sign in.
  3. Create one applet for each kind of call, all adding rows to the same sheet. If This: Android Phone Call and the trigger. Then That: Google Sheets, then Add row to spreadsheet. Spreadsheet name: Phone calls (or the name you chose in eKTextAI: use the same one in both places). Formatted row, exactly:
    TriggerFormatted row
    ๐Ÿ“ž Any phone call placed{{OccurredAt}} ||| {{ToNumber}} ||| {{ContactName}} ||| {{CallLength}} ||| Outgoing
    ๐Ÿ“ฒ Any phone call answered{{OccurredAt}} ||| {{FromNumber}} ||| {{ContactName}} ||| {{CallLength}} ||| Incoming
    ๐Ÿ“ต Any phone call missed{{OccurredAt}} ||| {{FromNumber}} ||| {{ContactName}} ||| 0 ||| Missed
    Start with the first one if you only want the calls you make; add the others any time. eKTextAI shows each row with a Copy button.
  4. Give the permissions. Allow IFTTT the Phone, Call logs and Contacts permissions, and connect your Google account so it can write to Google Drive. Then in Android settings, Apps, IFTTT, set Battery to Unrestricted, or Android may put IFTTT to sleep and calls are missed.
  5. Place one short test call. A new sheet appears in Google Drive, in the IFTTT/Android Phone Call folder, with one row.
  6. Paste the script. In that sheet: Extensions, Apps Script. Delete what is there, paste the script from eKTextAI, press Save, choose setup and press Run. Allow what Google asks. That's it.

Each row IFTTT writes has five columns: the date and time, the number, the contact's name, the length in seconds, and whether the call was outgoing, incoming or missed. Already keep a call log in a Google Sheet from another app? Use it as it is: the script recognises each column by what is in it, in any order, and skips a heading row or a minutes column. The script sends new rows every 5 minutes, hides two columns it uses to remember what it has sent, and tries again by itself if the internet drops. eKTextAI converts the seconds to minutes and keeps the exact time of the call.

Who uses it

  • School admissions offices: every call to or from an enquiring parent is on the enquiry's request, and a parent who rang during assembly becomes a call-back instead of a lost admission. Pair it with our 7-day WhatsApp follow-up plan.
  • Sales and service teams: calls to new numbers become leads without anyone typing them in, and the manager's Requests page shows who was called today.
  • A team on several phones: set the applet up on each phone. Use one sheet per phone, or the same sheet for all.

Stop asking "did anyone call them?"

The phone-call template is in every eKTextAI workspace, under Lead sources, Google Forms and Sheets. Want to see it working first? We will set it up with you on a call.

Questions teams ask

Is IFTTT free?

Up to a point. IFTTT's free plan gives 1,000 credits a month and logging a call uses about 15 credits, so roughly 66 calls a month are free. More calls need a paid plan: Starter (5,000 credits), Pro (20,000) or Pro+ (100,000); see IFTTT's plans page. When credits run out, IFTTT pauses the applets and calls made meanwhile are not logged. Logging only the calls you make, not every incoming and missed call, makes the free credits last longer.

Does this work on iPhone?

No. IFTTT's phone call triggers are available on Android only, because iPhone does not let apps read the call log.

Will the same call or the same person be added twice?

No. Each row is recorded once, even if the script sends it again. A number already in the CRM is never added as a second lead: the call is added to their notes and to their open request.

Do incoming and missed calls work too?

Yes. Add an applet for Any phone call answered and one for Any phone call missed, writing to the same sheet. A missed call from a new number makes a lead and a Call back request.

Will my personal calls end up in the CRM?

Only until you say so. Every call you make, receive or miss asks Personal or business? on its request, once per number; Personal deletes the lead the call made, the request and the call log, and that number is ignored from then on. A request that came another way, such as a WhatsApp chat, stays: only the calls are taken off it. People marked Internal, Partner, Vendor or Personal in the CRM are ignored from the start. Agents can answer the question too, not only the owner.

What does the team still have to do?

One thing: after the call, open the request in eKTextAI and add a note with what was discussed, then set the status or the next follow-up date. The CRM entry, the request and the call on its activity are already there.

What about numbers that are not in my phone's contacts?

IFTTT writes the number itself as the name. eKTextAI notices and keeps the lead without a name, so you can add it after the call.

I already send a Google Sheet to eKTextAI. Can I switch it to phone calls?

Yes. Under the sheet in Google Forms and Sheets, choose ๐Ÿ“ž Phone calls (IFTTT). The address stays the same; replace the script in the sheet with the phone-call script and run setup once.

A call did not arrive. What do I check?

In order: the applet ran (IFTTT, the applet, View activity); a row was added to the sheet; the script ran (Extensions, Apps Script, Executions). If rows are in the sheet but not in eKTextAI, run setup again.

Related reading