Chat with us, powered by LiveChat

Gmail Counter with Google Apps Script

The following Google Apps Script will display the unread Gmail counter for your mailbox to anyone on the Internet with a simple URL.

The count is published as text but you may use other formats (ContentService.MimeType) like RSS, JSON or even CSV and feed this data into other system – like tweets or even another spreadsheet.


/*    Gmail Counter by Amit Agarwal   */
/*    Published on 06/17/2013         */

function doGet() {
  var cache = CacheService.getPublicCache();
  var counter = cache.get("gmail-counter");
  // Cache the counter to stay within the Apps Script quota
  if (!counter) {
    counter = GmailApp.getInboxUnreadCount();
    // Cache the counter value for 20 minutes
    cache.put("gmail-counter", counter, 1200); 
  // You can customize the output message
  counter = "There are " + counter + " unread messages in my Gmail Inbox."
  // Output the result in plain text format
  return ContentService.createTextOutput(counter)