Grab Certain Texts From Gmail via Google Spreadsheet (Script)

I had worked on this a few weeks back, and without any prior knowledge of using GmailApp call on Google Spreadsheet, I had to struggle for a while to get it working. The code to do this is fairly simple and can be understood by just about anyone. The problem I was trying to solve was also fairly simple. First, some background : there's a new task initiated by my college, although as ridiculous as it might sound to you, a student (based on the order of the roll number) has to send an email blast each day to other students. The email blast should contain a word, it's meaning, example of its usage etc. There's a certain format that needs to be followed, and what I wanted to do was grab just the words within the email and store them so that at some point, I'd have a database full of every words that have ever been sent. (Not really my idea, though.)

So, here's how I tackled the problem, and I hope this would be helpful to you in case you want to do something similar. What I did at first was that I went to my Gmail and assigned all the emails with the subject "word of the day", the label : "Word". Since all the email blasts followed the same format, they all had the same subject as well. The advantage of assigning a label to emails based on subject is that, it works for new emails as well. That means, any new email with the same subject, will also automatically be assigned the label "Word". I now only needed to focus on retrieving mails from the label "Word" via Google Script. And this code exactly does that :

function myFunction() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('MySpreadsheet');
  var labelObject = GmailApp.getUserLabelByName('Word');
  var threads = labelObject.getThreads();
  for (var i = 0; i < threads.length; i++) {
    var msg= threads[i].getMessages();
    var raw = msg[0].getRawContent();
    var words = raw.match('*(.*?)*');
    if (words != null) {
      sheet.getRange('A' + String(i+1)).setValue(words[1]);

read more

How To Setup .NP Domain Name For Tumblr Blog?

I assume you have already gotten yourself a .NP domain name. If not, you can read the process here.

Mercantile only lets you change Nameservers of your domain, however, services such as Google's Blogger and Tumblr, require you to change A Record and CNAME, but not the nameservers. So, if you wish to use your domain name for hosting blogger or tumblr blog, then there's only one alternative : to use third-party DNS service which supports A and CNAME records. Here's what you need to do in order to use your domain with Tumblr.

read more