How to Automatically Log All Phone Calls in Google Drive Spreadsheet

0 Comments
[yasr_overall_rating] [yasr_visitor_votes]




This tutorial explains how to automatically log all phone calls in Google Drive Spreadsheet. Using this tutorial, whenever you make any call, a row will automatically be added to a Google Drive Spreadsheet, which will have all the details of the call. It lets you log phone number of call placed, name of contact, time at which call was placed, and duration of the call. This is essentially, all the information you need to log.

In addition to that, you can also log all the phone calls that you receive, including the calls that you answered and the calls that you missed.

This tutorial will work for Android and I will use my favorite tool IFTTT for that. It is completely free and very easy to setup. Let’s see how

Log Phone Calls in Google Spreadsheet

How to Log Phone Calls in Google Drive Spreadsheet:

Step 1: I have covered so many IFTTT tutorials by now that I hope you have a free account created by now. If not, do that. After that, let’s start by creating a new recipe. For that, click on “Create” in IFTTT, and then click on “this”. In the “Choose Trigger Channel” box, search for “Android Phone Call” channel. Select that in the search results.

IFTTT Android Phone Call

 

If you have not already activate this channel, you will be asked to do that now. For that you will need to install free IFTTT Android app on your Android phone. I have already downloaded this app when I was doing tutorial on how to mute Android phone when you reach office. So, it did not prompt me to activate again.

Step 2: Once you have activated the channel, it will ask you to choose a Trigger. Choose “Any Phone Call Placed”.

Step 3: After that, click on “Create Trigger” button.

Step 4: Click on “that”. Then, in “Choose Action Channel”, Search for “Google Drive”. Select it from search results.

IFTTT Google Drive

Step 5: Next it will ask you to choose an action. In our case, we want to add a row to Google Spreadsheet whenever a phone call is placed. So, choose the option of “Add row to spreadsheet”. It will add a single row whenever a call is placed. By default, IFTTT inserts only up to 2000 rows in a spreadsheet and automatically starts a new spreadsheet after that.

Step 6: In next step, you need to make all the settings. First of all, you need to provide name of Spreadsheet where all the phone call logs should be saved (if the spreadsheet does not exists, it will be created). After that, you can provide the sequence in which the fields can be saved. You can record phone number that you called, duration of the call, time at which call was placed, and name of the contact from your phone to whom you place the call. After that, you can also define the Folder path where the spreadsheet would be saved. By default, it would be saved under a folder called IFTTT / Phone Call. Click on “Create Action”.

IFTTT Action Fields

Step 7: In the last step, IFTTT will show you the recipe that you created. Click on “Create Recipe” button.

Now you are all set. Whenever you will make a phone call, a row will be entered in the Google Drive Spreadsheet that you specified. It records calls that were answered by your contact, as well as those calls that were not picked (it shows duration of call as 0 for those calls). Here is a snapshot of the log it created for me (the column headers have been added by me):

Log of Phone Calls Placed

One bug that I found is that the call time is logged as per EST time. I re-checked that my IFTTT profile had correct time settings, still the time was logged in EST. It seems like a bug in the IFTTT Android app. As the app is still pretty new, I am sure this bug would be killed soon.

Do note that the steps mentioned above will log only those phone calls that you place. In case you want to receive those phone calls also that you have received, then you will need to create another recipe using the same steps as mentioned above. In Step 2, choose “Any Phone Call Answered”, and everything else will remain same. You can give name of the same Excel, so that all calls are logged in same Excel.

Now, the above step will log the calls that you actually Answered. Want to log those calls as well that you missed? Create one more recipe, and this time, in Step 2, select “Any Phone Call Missed”, with rest of the steps remaining same.

So, with these three recipes, you will have a completely automatic log of all the phone calls that you placed, or answered, or missed.

My Opinion:

I believe IFTTT presents a very easy method to automatically log all the phone calls in a Google Drive Excel. It is very useful, not only for your personal tracking, but also to track phone calls made by official phones of your employees. The fact that the data goes in a spreadsheet means that you can easily create pivot tables etc. on this to do a deeper analysis.

What do you think of this tutorial? Are you using IFTTT? Let me know in comments below.

[yasr_overall_rating]
[yasr_visitor_votes]

Leave A Reply

What do you think?
  • 0
  • 0
  • 0
  • 0
  • 0
  • 0
21 Comments
  • Latest
  • Oldest
  • Hottest
Matthew Scicluna2017-07-28

For some reason the contact name field is not getting populated. Anyone having the same issue?

Hmmm…and I am assuming you have set recipes for received calls as well as missed calls…maybe IFTTT has something internal to prevent this type of situation… Or it could just be a bug (I have already reported another bug to IFTTT).

sulasno2014-05-30

Yes

That’s weird. Is the phone B logging anything on its own when it calls another number?

sulasno2014-05-29

I used Phone A to call and it was recorded in log A and there was no entry in log B (for Phone B)

Oh boy…that should really confuse IFTTT! For same IFTTT account for same Call, one incoming call IFTTT recipe would run and one outgoing call recipe would run. So total 4 recipe runs for 2 calls! Would love to see the results!

sulasno2014-05-29

I used A to call B and B to call A. Have not really looked into the files. Expect a response on Monday

How many images can I post?

Interesting. Bit surprised that it created two identical folders. What would happen if you remove one of the folder so that there is only one folder and one excel? Will both apps log calls in same excel in that case?

sulasno2014-05-29

Installed ifttt to 2 android devices and login using the same credentials. Installed the phone recipes to one device and they showed up in the other. Checked Google Drive and found identical folders created. No phone calls today but will check the contents over the weekend. My suggestion is not to use the same ifttt logins

sulasno2014-05-28

Got ifttt installed on 2 phones

Will run the recipe tomorrow since it is 2am and the lights are off

Powered by Waline v3.5.5