How to Backup Your Android Phone Logs and SMS to Google Drive Spreadsheets

Mihir Patkar 27-05-2014

Your Android smartphone only stores the last 30 days of phone calls made or received. Your text messages are also a mess after a point, especially with contacts you talk to often. If you want to keep this data safely backed up, the new IFTTT for Android will automatically store them forever in your Google Drive.


Of course, Titanium Backup is still the best backup solution for your Android smartphone How to Back Up Your Android Device Properly Here's how to completely back up your Android device by protecting your photos, SMS, contacts, and everything else. Read More , but remember that’s paid and only for rooted phones. Plus, it only keeps the data safely and doesn’t turn it into an easily searchable spreadsheet.

With the launch of IFTTT for Android, some users are already suggesting unusual automated recipes 5 Unusual IFTTT Recipes You May Not Have Thought Of You've got the folks at IFTTT who make web automation look like childs play. It's quite impressive. I decided to finally start digging through IFTTT to see if I could come up with a few... Read More for the app. The folks at I Love Free Software came up with the idea of backing up phone logs, and we decided to take it further and back up our text messages while at it.

How To Backup Phone Logs

The process to backup your phone logs is pretty simple. Fire up the IFTTT for Android app and create a new recipe. To backup all your phone logs, we will be creating three different recipes—one for missed calls, another for received calls, and the third for calls you place.


  1. Tap the channel for “IF”. Scroll to select “Android Phone Call” and tap the blue plus sign next to “Any phone call placed”.
  2. Tap the channel for “Then”. Scroll to select “Google Drive” and tap the blue plus sign next to “Add row to spreadsheet”.
  3. Choose whether you want to receive notifications or not when the recipe runs and hit Finish.

That’s it. Now every time you make a phone call from your Android smartphone, it will be automatically backed up as a row in a spreadsheet file in your Google Drive, which looks something like this:



As you can see, it logs the date and time, the phone number (blurred in above image), the contact, and the duration of the call. In the recipe’s settings, you can change these elements or their order.

Using the same method, you can also create new spreadsheets for phone calls answered and phone calls missed, selecting those in the first step.

Note that this only backs up the call logs and does not record the phone call itself. You need a different method to automatically record calls and never run out of space How to Automatically Record Calls on Android and Never Run out of Space Recording phone calls is a great way to keep data for your records. Let's compare some apps that will do this on your Android phone. Read More .


How To Backup Text Messages

Backing up your SMS is similar to how you backup phone logs.


  1. Tap the channel for “IF”. Scroll to select “Android SMS” and tap the blue plus sign next to “Any new SMS received”.
  2. Tap the channel for “Then”. Scroll to select “Google Drive” and tap the blue plus sign next to “Add row to spreadsheet”.
  3. Choose whether you want to receive notifications or not when the recipe runs and hit Finish.

And just like that, a new spreadsheet will be created for all the SMSes you get from now on. Note that it does not work with MMS media. In total, you will get five different spreadsheets—three for calls (answered, placed, missed) and two for text messages (received, sent).



This method does not cover older messages, but we have a workaround for that. Download and install SMS Backup & Restore from the Play Store, run it and follow the instructions to create a backup. Once that is done, you will find an option to export the backup as a CSV file. This CSV file can be opened in any spreadsheet app. Just copy and paste it into a Google Drive spreadsheet and you’re done!

Share Your IFTTT For Android Recipes

When it comes to the web, the ultimate IFTTT guide The Ultimate IFTTT Guide: Use the Web's Most Powerful Tool Like a Pro If This Then That, also known as IFTTT is a free web-based service to get your apps and devices working together. Not sure how to build your applet? Follow along with this guide. Read More covers most scenarios you will need. But the automation app is new to Android and people are still discovering its many potentials. So if you have some cool IFTTT for Android recipe, share it in the comments below!

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Nelleay
    February 13, 2017 at 9:21 am

    Actually, besides cloud services backup, you can also backup your data from your phone to pc, use some desktop backup tools, which allows you to transfer data from phone to pc directly and easily.
    I recommend MobiKin Assistant for Android, it allows you to backup your android phone data to pc.

  2. Anonymous
    July 22, 2015 at 8:27 am

    I can backup android phone contacts to computer with some application .So I do not worry phone data lost.When deleted data ,easy to recover from backup files.

    Sharing experience:

  3. piettro
    February 11, 2015 at 9:36 am

    I like it, but i have a small problem, i get the log duplicated, every phone call has written twice. I tried to erase rules and make it again, but it happens again. Any idea?

  4. Kumarapush
    August 31, 2014 at 7:09 am

    List of best Android Backup apps are also listed in this page.

    But still, the IFTTT is new term that I learnt from this page. Thank You.

  5. Kathirirajan
    June 16, 2014 at 4:34 pm

    Internet is must....

  6. Jemela W
    June 9, 2014 at 2:46 pm

    This is very cool. I'm always looking for new ways to backup my Android info, I'll definitely be trying this now.

  7. Jayendran
    June 4, 2014 at 9:28 am
  8. CoolHappyGuy
    June 1, 2014 at 7:50 pm

    Way Cool!! And to think that I paid $ for Tasker when this is way easier and (probably) more versatile! Thanks MUO.

  9. Maggi
    May 29, 2014 at 2:53 am

    Is there an app like this that doesn't want to have access to all your details before you can use it.

  10. Chaitra
    May 28, 2014 at 6:51 pm

    awesome ... just what I was looking for !

  11. Ziaur Rahman
    May 28, 2014 at 2:45 pm

    Awesome Article.

  12. Rajaa C
    May 28, 2014 at 9:15 am

    How can I do the same with WP8 Lumia phone and Onedrive Excel Office Web Apps?

    • Tony Karakashian
      May 28, 2014 at 5:21 pm

      One of the first apps I install when I get a new phone or re-ROM! Having my texts synced to my Gmail means I have all of my communication history in one spot, easily searchable. I also love that it'll put my call log into my calendar. Exactly where THAT should be, too!

  13. Mark
    May 28, 2014 at 3:08 am

    I have been desperately looking for a way to backup texts. My only question is, Is there a way to consolidate them into ONE spreadsheet in a semi threaded/response format? Such as what i say on one line, other persons response on next, then me, etc. I'm trying to find a way to do that as it would be far more useful than having two separate, one for sent and one for received.

    • Lorenzo S
      May 29, 2014 at 1:04 pm

      MySMS or MightyText can backup SMS and call log event to DropBox, Drive and EverNote... And if you have a flat data program on your smartphone, with these apps you can use web version and send SMS using a PC as you wrote them from your phone.

  14. Sam K
    May 27, 2014 at 6:15 pm

    thanks, will give it a try.