Monday, April 8, 2013

Email Tips: Clean Up Your Inbox with a Google Apps Script


Email is undoubtedly important—and at the same time, it can be a huge time drain depending on how much email you receive a day. And if your email inbox is anything like mine, well, it’s a jungle. Ready to tidy things up a bit? We stumbled on a Google Apps script that can help you better manage your Gmail inbox—no apps or extensions required.

We live our lives on a schedule (or try to, anyway)—so why not apply the same philosophy to your inbox? The Google Apps Script lets you automatically archive or delete old emails that are clogging up your inbox based on a schedule you create. The result? Time-based events that will move, mark or label messages—and you don’t even have to open your mail client!

I can hear your excitement. You’re ready to set it up, aren’t you? Let’s dive in with a hypothetical example. Say you want to get rid of deals, promotional emails or notifications that are two days old. To accomplish this, you’ll need to follow two steps:
  1. Create a “delete me” Gmail filter and populate the search options to catch your semi-spam as it arrives.
  2. Create a script that will delete all messages from the “delete me” label older than two days.  Once your filter has been created, go to https://script.google.com and create a blank project. You’ll enter the following code, as written on John Day’s blog–head there to copy and paste the script.

google apps clean up script
Notice that, in the second line, you have the option to change the number of delay variables to specify how many days should pass before that particular matched message will be deleted from your inbox.
When you’ve filled in the variables, save the script, name your project and click Run. After that, Google will ask you to authorize the script to access your Gmail account. Your final step is the schedule the interval at which you want the script to run. Simply go to the Resources menu and select your desired interval.
google apps script
Now that you’ve cleaned up older emails, what about the rest of your inbox? Don’t worry—there’s a script for that! You can easily archive older emails from your inbox using the Google Script here:

Simply copy and paste the script into https://script.google.com, specify your intervals and you’re set!

A quick note? If you want to clean up thousands of email messages, know that it will take time for the script to fully work. If you’d rather tackle your inbox in smaller batches, follow John’s steps to process email threads in groups of 100.

What do you think? Ready to give Google Apps Script a try? 

Sunday, March 3, 2013

Research Without Leaving Your Document



Google Research Tool


The Research tool makes it easy to add information from the web to your documents and presentations. To access the tool:
  • Select the Research option from the Tools menu.
  • Use the keyboard shortcut (Ctrl + ⌘ + Shift + I on a Mac, Ctrl + Alt + Shift + Ion a PC).
  • Right-click on a specific word and select 
Research.The Research tool will appear along the right-hand side of your document or presentation. You can start a search by typing into the search bar. You can narrow your search to specific types of results (e.g. images, quotations) by using the drop-down menu in the search bar.

Researching different types of information relevant to your document or presentation


When conducting a search, the Research tool will show you different types of results — web results, images, quotations, maps, reviews, personal results, and more.

Web Results

Under the web results category, you’ll find a number of websites related to your search. If you select one of these results, you’ll see several options:
  • Select Preview to see a preview of the website. Click on the site link at the top of the preview pane to open this page in a separate window, or click the arrow on the left edge to close the preview.
  • Select Insert link to add a link to the website into the body of your document.
  • Select Cite to create a footnote citation of this web result within the body of your document.

Images

Images will appear in the general search, as well as an image search. Narrow your search results to only images by selecting “Images” from the drop-down menu in the search bar.

Quotations

Narrow your search results to only quotations by selecting “Quotes” from the drop-down menu in the search bar. Once you have selected the quotation you’d like to use in your document, click Insert to add it to your document with a footnote citation (or linked to the author’s name in a presentation).

Article Citations

Narrow your search results to only articles by selecting “Scholar” from the drop-down menu in the search bar. Once you have selected an article you’d like to read or reference, click on that entry in the search results. You will see a Web or PDF hyperlink in the upper left-hand corner of the entry that will take you to a web or PDF version of the article itself. You will see a Cited by hyperlink in the upper right-hand corner of the entry, showing how many times the article has been cited, that will direct you to the Google Scholar list of sources that have cited this article. Clicking on either of these links will open the result in another window.
To insert an article citation into your document, select the article and click Cite. In presentations, you may insert a link to the article by pressing Insert.

Places

When conducting a search in the Research tool for a geographic location, your search results may include a map. You can edit this map by selecting Edit and then zooming in/out or dragging the map. Once you have the exact map image you’d like to include in your document, click Insert. You can also drag and drop the map image into your document.

Dictionary

Use the Research tool's dictionary to search for definitions, synonyms, and usage examples. If you don't already have the Research tool open, you can access the dictionary by clicking the Tools menu and then selecting Define.


Links to short video tutorials:


Using Google docs for easy Research
from Kirk Magill on Vimeo

gogrovoGoogle Docs "Research Tool"
by gogrovo on YouTube


gogrovoGoogle Docs "Research Tool"
on Grovo.com




Wednesday, February 27, 2013

Tomorrow's Tech in Today's Schools: Google + Classrooms


Tomorrow's Tech in Today's Schools: Google + Classrooms: A year and half ago, Google released Google+ to a select few power-users and slowly opened up to the public.  It was called many names and...



Monday, February 25, 2013

Grovo - Great Online Training Videos


If you have every wanted to call your favorite "Tech Guy" because you needed to quickly find out how to use that awesome new online or cloud based service.......

Then you need to check out Grovo!  It is by far my favorite place to find high quality online training (If you can call learning it in 3 minutes flat training) with real-time video updates to the websites, mobile apps and online tools that I use the most!  AND IT'S FREE!!!

Check it out and sign up today!  Grovo | Online Training and Video Tutorials


Check how this teacher used Grovo in her class and "Students' grades improved as much as 25%"


Thursday, February 14, 2013

Use Google+ Hangouts on the iPad


Google+ hangouts on the iPad are a great way to video chat with students, staff and even other classrooms!  Download the Google+ iPad app to start hanging out!  Google Hangouts are a central part of the Google+ social network, allowing up to 10 users to video chat across devices and notebooks, without the single participant and Apple only restrictions of FaceTime.  

Want to learn more on how to use Google+ Hangouts on the iPad


Monday, February 11, 2013

Gmail - Using filtered Search



Use Filtered Search
Gmail’s search bar is very handy for finding that message you got months ago, but most people don’t realize how easy it is to access advanced search. Just click the downward facing arrow on the right-hand side of the search bar and you will be presented with a number of different search options. You can narrow your search down to the person who sent it, the subject, words used, and the dates it would have been sent.  Learn more about Gmail search

Monday, February 4, 2013

Google Drive iOS app



Upload photos faster and get more done with the Google Drive iOS app

The Drive iOS app recently got some updates to help you save time and get work done. You can now quickly upload multiple photos and videos from your last conference or team event into Google Drive to share with your team. Learn more: http://goo.gl/yJsc6

Drive on iPad is now integrated with Quickoffice to make it easy to edit Microsoft Office files you’ve stored in Drive. Simply open your Microsoft Office files in Drive, edit them using Quickoffice, and save them back to Drive.

Other new features in this release include:
+ Diagonal scroll in Sheets
+ Improved formatting in Google Sheets for decimals, currency, dates and more
+ Improvements to slideshow and animations in Slides
+ Pinch to zoom on Slides

Download Google Drive for iOS: http://goo.gl/5Zgc3
Download Quickoffice for Google App for Business: http://goo.gl/3DZ8b