My Favorite android apps (free)

Since HTTP links change frequently, there are no direct links included in the list below.

All apps will be easily found if searched on google play or google lucky.

Here is the list (all of them free):

Basic Setup

  1. TokikoFree
  2. QuickDial Free
  3. Google Keep
  4. Google Authenticator
  5. QR Code reader
  6. First Aid
  7. B1 archiver

Very Useful Utilities

  1. CamScanner
  2. Flash light Ad Free
  3. Pi Scientific Calculator
  4. Ultimate Stopwatch

Wifi

  1. WiFi Ruler
  2. Wifi Analyzer
  3. Advanced Spectrum Analyzer
  4. Spectroid

Multimedia

  1. Shazam
  2. SoundHound
  3. Backgrounds

System tools

  1. Advanced Task killer
  2. Permissions Explorer
  3. Sensors Multitool
  4. IP tools

Consumer

  1. Viber
  2. Viber Contact Photos
  3. Forky
  4. Athens Book
  5. OASA telematics (Greece only)

 

 

Google docs – send a doc monthly via email

Here is a small script you can attach to a document on Google docs.

Whenever run, it will attach the file and send it to you via e-mail

function monthlyBackup() {
  var formattedMonth = Utilities.formatDate(new Date(), "GMT", "MM");
  var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd' 'HH:mm:ss"); var name = SpreadsheetApp.getActiveSpreadsheet().getName() + " backup " + formattedDate;
  var ssID = SpreadsheetApp.getActiveSpreadsheet().getId(); var sheetName = SpreadsheetApp.getActiveSpreadsheet().getName(); //var email = Session.getUser().getEmail(); var email = "XXX@XXX.XXX";
  var subject = SpreadsheetApp.getActiveSpreadsheet().getName() + " backup at " + formattedDate;
  var body = "This is automated backup from google docs :)";
  var requestData = { "method": "GET", "headers":{"Authorization":"Bearer "+ScriptApp.getOAuthToken()} };
  var url = "https://docs.google.com/spreadsheets/d/"+ ssID + "/export?format=ods&id="+ssID;
  var result = UrlFetchApp.fetch(url , requestData);
  var contents = result.getContent();
  var attachedFilename = sheetName + " " + formattedMonth + ".ods";
  MailApp.sendEmail(email, subject ,body, {attachments:[{fileName:attachedFilename, content:contents, mimeType:"application//x-vnd.oasis.opendocument.spreadsheet"}]}); }

 

For more MIME types read this article:

https://developers.google.com/drive/v3/web/integrate-open

If you want to add a menu item you can also the following code:

 

function onOpen() {
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var menuEntries = [ {name: "Send Email", functionName: "monthlyBackup"}];
 ss.addMenu("Scripts", menuEntries);
};

 

References:

http://igoogledrive.blogspot.gr/2012/08/send-google-spreadsheet-sheet-to-email.html

https://webapps.stackexchange.com/questions/60445/send-an-email-with-attachment-using-google-apps-script

https://developers.google.com/drive/v3/web/integrate-open