a google script to send everyone who filled out a google form an email every day with a startup tip

daily_startup_tip.js

function email_one_tip_a_day() {
  // pick a tip
  var data_sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('tips');
  var num_rows = 90;
  var row_num = Math.floor((Math.random()*num_rows)+1);;
  var dataRange = data_sheet.getRange(row_num, 1, 1, 1);
  var tip = dataRange.getValues();
  
  // email it to some people
  var todays_date = Utilities.formatDate(new Date(), "EST", "d MMMM");
  var subject = 'startup tip of the day for ' + todays_date;
  
  var emails_sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('email_addresses');
  var emails_data = emails_sheet.getRange(2, 2).getValues();
  for (i in emails_data) {
    var row = emails_data[i];
    MailApp.sendEmail(row[0], subject, tip);
  }
}