Day 27: Google Docs Scripts and Power Tips
30 Days With...Google Docs: Day 27
With the month coming to a close on the 30 Days With...Google Docs project, I think we have established that Google Docs is more than adequate for creating simple documents, spreadsheets, presentations, and other content. Now, let's take a quick look at some of the features that power-users might appreciate.
For more advanced users, Google offers Google LookUp and Google Finance to automatically search for and add information to cells in your spreadsheet.By adding Google LookUp syntax to a spreadsheet cell, you can populate the cell with information stock data, country demographics, celebrity details, planets of the solar system, and more. Google says that the data can come from any Web site, but that certain sites like the CIA Factbook and Wikipedia tend to appear as sources more often than others.
To use Google LookUp, type "=GoogleLookUp("entity";"attribute")" in a cell. For example, if you want to populate a cell with "=GoogleLookUp("Michael Jordan" ; "average points per game")" Google LookUp searches to find out what Michael Jordan's average points per game was, and automatically populates the cell with "31.5".
Google Finance works in a similar way, but is specifically focused on finance and investing information. For example, "=GoogleFinance("GOOG" ; "price") fills the cell with the current share price of Google stock, or "=GoogleFinance("MSFT" ; "volume") populates the cell with the volume of shares traded today for Microsoft stock.
While these functions might save you some time from manually looking up data like Charlize Theron's birth date, it is better for information that is dynamic and may change frequently--like share price or share volume. To see what other options are available, just type "=Google" in a spreadsheet cell and a box will pop-up that lets you know how you can complete the query.
It did take me a few attempts to master the syntax. You don't need the quotes at the beginning or end of the queries that I listed, but you do have to include the quotation marks around the entity and attribute conditions so Google knows what to look up.
You can also use it to automate a mail merge with Gmail. Google told me that there is a update coming soon which will allow Google Maps to be integrated so that mail merge recipients could each receive custom driving directions from their location as well. That sound pretty cool.
These are just a couple of the power tools. At first glance, it seems obvious that Google Docs does not have the bells and whistles of Microsoft Office, but when you start to poke around you find that Google Docs actually has a fair amount of advanced features and capabilities for power users as well.
Get the complete30 Days With Google Docsseries compiled into a Kindle eBook.