Automagic event emails

Using the Eventbrite API to automate email promotions   At Redfin, the Marketing team contacts customers all over the country about upcoming classes and events near them. We don’t send a lot of email to each recipient – nobody likes spam – but we do send a great deal of small campaigns each week, and… Read More

When importData isn’t good enough: Retrieving CSV files behind basic auth with a Google Apps Script

(This post assumes you have some familiarity with Google Spreadsheets) For CSV files that are unprotected, Google Spreadsheets provides a really handy function: importData(url). There’s a short description of it in the list of Google Spreadsheet functions. If you just use this lovely function in cell A1 and pass it the URL of a CSV file, you’ll… Read More