Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- The script as described in http://www.rossgoodman.com/2012/10/26/inbox-zero-and-quantified-self/ ready to copy and paste:
- function myFunction() {
- var doc = SpreadsheetApp.getActiveSheet()
- var firstEmptyRow = doc.getLastRow() + 1;
- var gmailUnread = GmailApp.getInboxUnreadCount();
- var gmailInbox = GmailApp.search('in:inbox').length
- var gmailStarred = GmailApp.search('in:starred').length
- var gmailSpam = GmailApp.search('in:spam').length
- doc.getRange(firstEmptyRow, 1, 1, 1).setValue(new Date().getYear() +"-" + ("0" + (new Date().getMonth() +1)).slice(-2) + "-" + ("0" + new Date().getDate()).slice(-2));
- doc.getRange(firstEmptyRow, 2, 1, 1).setValue(gmailUnread);
- doc.getRange(firstEmptyRow, 3, 1, 1).setValue(gmailInbox);
- doc.getRange(firstEmptyRow, 4, 1, 1).setValue(gmailStarred);
- doc.getRange(firstEmptyRow, 5, 1, 1).setValue(gmailSpam);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement