Category Archives: Google Drive

All About Google Drive

sumall_idea_hatch_egg_bright

WorkFlows for Google Docs and Sheets

With all the recent additions to Google Drive (namely all the add-ons), it can be difficult to seperate the good from the bad.  Well I’ve found a good for you to give a whirl.  Letter Feed workflows allow you to ask for approval of a document right from within Google Drive.  No extra emails or phone calls, you can just put in the email address of the person you need approval from and Workflows does the rest.  Check out this video for a quick demo.

Org Structure

Draw.io – A Great FlowChart & Mind Mapping Tool

Draw.io is a browser based SAAS application that allows you to create Flow Charts and Diagrams in the Cloud.  It is extremely easy to use AND can be synced into your Google Drive, Dropbox and local machine!  If you are looking for a great way to create an org chart, a mind map, an office diagram… the possibilities are only limited by your imagination.  Check out the video below detailing this great service and then head over to draw.io and check it out for yourself!

Google Drive Logo

Google Drive App – Track Changes

Last week’s update to Google Drive provided a huge list of new features to Docs and Sheets.  One of my favorites so far is the Track Changes app from Letter Feed.  Similar to the same function in MS Word, Track Changes in Google Drive allows you to see all recent edits made to a document as well as who made those changes.  As the owner of the document, you can approve or reject the changes as you see fit!  This is a great tool to increase collaboration on a Google Doc.

Want to give it a try?  Go here to install.

https://chrome.google.com/webstore/detail/track-changes/pgjeblaieehjmmahlikmifaggjckpcnp

Check out this quick video detailing how this new add-on works.

Google Drive Logo

Google Docs and Sheets Get a Huge Update

Google Docs and Google Sheets got a huge update this week with the addition of “Add-ons”.  These are additional applications that work within Google Drive to give you extra functionality to your documents and spreadsheets.  Things like mail merges, label creation, tracking changes, and more!  Check out the video and then go to Drive to check out the new features and apps that are available to you now.

More info? http://googledrive.blogspot.com/2014/03/add-ons.html

Google Drive Logo

Notification Rules for Google Sheets

Notification rules are a must when using Google Sheets for collaborative work as well as for survey responses.  The rules that you can setup allow you to be notified whenever a change has been made to your spreadsheet.  Not only are these extremely useful, they are also extremely easy to set up!  Here it is in two steps!

Step 1 – In your spreadsheet, click on the tools menu and select notification rules

Notification Rule 1

Step 2 – Set up the type of notification you would like to have.  There are multiple options in this step, so use the one that works best for you!

Notification Rule 2

That’s it!  Now you will be notified via email when changes have been made to your sheet.

Note – this only works for Google Sheets, there is no option for this in Google Documents at this time.  You would need to view the Drive Activity stream to see what documents have been edited recently!

If you have any questions, don’t hesitate to ask.

Google Drive Logo

Google Drive Update Shows Pictures

A recent update to the Google Drive Web UI provides some new handy tools.  For starters, whenever you are in a folder that is shared out, you now see a picture in the upper right hand corner of all of the people with whom it is shared.

Google Drive Pictures

 

 

 

If you hover over one of the pictures, you will see what rights that person has to the folder.  This is a nice addition as it provides a quick way of seeing pertinent information about your folders and files.

Screen Shot 2013-12-18 at 8.45.58 AM

Screen Shot 2013-12-13 at 2.13.49 PM

Google Sheets Update!

Google Sheets Update

Google Sheets recently updated with a whole bunch of new features! Here are a few of the new features.  (For the official blog post from Google, Click Here)

Larger size sheets – millions of cells!

 

Formula help – Prompts show you how formulas function.  Also links to more detailed formula help.

Screen Shot 2013-12-13 at 2.13.49 PM

 

 

Conditional Formatting – Set rules to change how your data is represented.

Screen Shot 2013-12-13 at 2.20.50 PM

 

 

 

 

 

 

 

 

 

 

Colored Sheet Tabs, Custom Formatting, and many more!

GoogleSheetsCellColor

 

 

Check out the video for a great overview of all the updates!

Gmail Attachments to Google Drive

Google Drive Gmail Integration is Way Cool!

A recent update to Gmail on the web now allows you to send any and all attachments that you receive via email straight to Google Drive.  You don’t even have to leave your email. You can send it straight to My Drive or you can specify the exact folder that you want the file to be in. This is a huge timesaver for those people who receive attachments often and want to store those in their Drive.  Want to see it in action?  Check out this brief video!

For more information, head on down to the Google Drive Blog for the full rundown of the update.