Backup SMS Messages From Your Android Phone to a Google Sheet

If you are looking to backup all your incoming and outgoing SMS messages and preserve them for future reference, then you can do that with IFTTT, a simple service that lets you connect different services together. IFTTT is short for If This Then That, which works on a simple method of trigger and action.

IFTTT consists of Applets, which contains the trigger and the action. Today, we will be using two applets, one will log the Received messages, and the other will log the Sent messages. Please note that these messages cannot be restored back to your mobile phone using this method.

Pre-requisite

  1. IFTTT app on your Android phone
  2. A Gmail account.

How to Setup SMS Backup on Android

  1. First install the IFTTT app on your Android device.

  2. Next, login to the app with your Google account.

  3. Once logged in, open the IFTTT website on your PC. Now login with the same Google account with which you signed in on your mobile.
  4. Now open Received messages applet and click the “Turn on” button.

  5. Do the same thing with Sent messages as well.
  6. Now open the IFTTT app on your mobile, and go to the My Applets section.
  7. You will see both the applets there, and your text messages will start backing up on Google Sheets. Everytime you receive or send an SMS, it will be added to the bottom of the Google sheet.

Benefits of using IFTTT to Backup SMS Messages

  1. Seamless: It is an install and forget service. Once you have set-up the backup, you can just leave everything to the service.
  2. Other Features: The app backups up your text messages beautifully, but don’t think it can do only that. IFTTT consists of hundreds of great applets and there are dozens of them only for your Android device. Just dive in and explore. You can even upload files to Dropbox via Email using IFTTT.
  3. Immediate Backup: Your SMS messages are backed up as soon as you receive them. The only condition is to have a working internet connection on your Android mobile.
  4. Searching – You can search for a message, a number, or a contact very easily. Just press the Ctrl + F keyboard shortcut, and type what you are looking for.
  5. Monthly Archives: IFTTT saves messages on Google Sheets. By just changing the sheet name, you can make it backup messages in a new sheet. This way, you can create a new sheet at the start of every month and you will have your messages archived by month.
  6. Filters: The power of filtering comes with Google Sheets. You can filter the messages on the basis of contact/number. You can even use the Import Range and Query functions to get messages from a particular person/number in a new sheet automatically.
  7. Sharing: As individual Google Sheet can be shared with anyone, you can share your SMS sheet with anyone you like. This is helpful for sharing One Time Passwords as well.
  8. Free: IFTTT and Google Sheets are both free services, then why not utilize these free platforms to backup all our SMS messages.

My Experience

I use Google Sheets for my work extensively. Having all my text messages saved securely in Google Sheets, as well as having all the power of Google Sheets, makes it simply the best backup solution for my messages.

Useful Links

  1. IFTTT website
  2. IFTTT app on Play Store
  3. Received messages applet
  4. Sent messages applet
Related Post