Google Apps Script, lets you write short programs that automatically perform simple actions within a spreadsheet. For e.g., Movie Night script figures out which movies are playing close by and invites everyone to vote on what they’d most like to see. It’s now available to all Google spreadsheets users. Apps Script can be helpful for all kinds of things, from customized party invites to sending out holiday letters — in fact Apps Script can be especially helpful for those repetitive, time consuming tasks. To help you find useful scripts, Google also launched a public gallery where you can check out our Movie Night script and browse other available scripts. To see the gallery or install a script in your spreadsheet, click on “Insert” and select “Script.” You can also write and publish your own scripts.
More info: Google Apps Script