Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learning Google Apps Script

You're reading from   Learning Google Apps Script Customize and automate Google Applications using Apps Script

Arrow left icon
Product type Paperback
Published in Mar 2016
Publisher
ISBN-13 9781785882517
Length 232 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Ramalingam Ganapathy Ramalingam Ganapathy
Author Profile Icon Ramalingam Ganapathy
Ramalingam Ganapathy
Arrow right icon
View More author details
Toc

Table of Contents (11) Chapters Close

Preface 1. Introducing Google Apps Scripts 2. Creating Basic Elements FREE CHAPTER 3. Parsing and Sending E-mails 4. Creating Interactive Forms 5. Creating Google Calendar and Drive Applications 6. Creating Feed Reader and Translator Applications 7. Creating Interactive Webpages 8. Building a Workflow Application 9. More Tips and Tricks and Creating an Add-on Index

Building the Gmail parser application


The parseEmail function is able to check 10 latest inbox threads, extract the from field and body text from unread messages, and put the gathered data in the left-most tab of the Sheet. Create the parseEmail function as listed here:

/** 
 *  Gets content of latest unread message in Gmail inbox
 *    and puts gathered data in left most tab of Sheets.
 *
 */
function parseEmail(){

  // Left most sheet/tab
  var emailSheet = SpreadsheetApp.getActiveSpreadsheet()
      .getSheets()[0];

  // Clear the entire sheet.
  emailSheet.clear();

  // Checks maximum 10 threads
  var thread = GmailApp.getInboxThreads(0,10);

  var row = 1;

  for(var thrd in thread){
    var messages = thread[thrd].getMessages();

    for (var msg in messages) {
      var message = messages[msg];

      if(message && message.isUnread())
      emailSheet.getRange(row,1).setValue(message.getFrom());

      emailSheet.getRange(row++,2)
      .setValue(message.getPlainBody())...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime