Skip to main content

Official Google Blog: Now playing: Apps Script for Google Docs

Official Google Blog: 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 been available to Google Apps customers since January, and today we’re excited to bring it to everyone who uses Google spreadsheets. 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, we’ve also launched a public gallery where you can check out our Movie Night script and browse other available scripts. If you’re feeling adventurous, try your hand at writing your own script and submit it to the gallery for others to use. To see the gallery or install a script in your spreadsheet, click on “Insert” and select “Script.”

Check out the Google Docs blog for more information about Apps Script, and to learn about writing your own scripts, visit the Google Apps Developer Blog.

Popular posts from this blog

Access Gmail Offline On enabling offline access, Gmail will load in your browser even if you don't have an Internet connection. You can read messages, star, label and archive them, compose new mail and messages ready to be sent will wait in your Outbox until you're online again. It's built on the Gears platform, which has already been used to offline-enable Google Docs, Google Reader, and other third-party web  applications   To get started with offline Gmail - - Sign in to Gmail and click 'Settings'. - Click the 'Labs' tab and select 'Enable' next to 'Offline Gmail'. - Click 'Save Changes.' - In the upper righthand corner of your account, next to your username, there will be a new 'Offline' link. Click this link to start the offline synchronization process. Standard Edition users can follow these instructions immediately, while Premier and Education Edition users will first need their  domain  admins to enable Gmail Labs from...

Introducing Samsung's first Windows Phone 8 - Samsung's ATIV S

Samsung announces new range of  Windows 8 devices ATIV S, ATIV Tab, ATIV smart PC and ATIV Smart PC Pro at IFA Berlin. ATIV S is built with the latest and best Software and Hardware technologies.  ATIV S is flat and 8.7mm mobile with huge 4.8" HD Super
Big News for Music Lovers (Courtasy BBC ) Music pirates can be deterred by warnings from their internet service provider (ISP), suggests a survey. Almost 75% of music pirates would stop if told to by their ISP, the survey of 1,500 UK consumers found. The research looked at the digital habits of consumers and found that the abundance of online music services was convincing many to go straight. Just over half of those questioned said they got music from legal subscription sites, or those supported by ads. Older fans Conducted by Entertainment Media Research (EMR) the survey aimed to find out what kinds of digital media consumers like and also how media sellers can make it more palatable. The research revealed the effect of the campaign against persistent pirates conducted by the music industry. Acting on information supplied by music industry groups many ISPs have contacted customers to tell them they are suspected of illegally downloading music. "It is quite evident that an ISP-led...