Now playing: Apps Script for Google Docs

The Google Apps team here in New York City is a hotbed of movie fanatics. But while planning a recent movie night, we realized we spend too much time organizing our events and not enough time discussing, debating and watching movies.

To take the hard work out of planning, we turned to Google Apps Script, which lets you write short programs that automatically perform simple actions within a spreadsheet. For example, our Movie Night script figures out which movies are playing close by and invites everyone to vote on what they’d most like to see.

Google Apps Script has…