Add custom features to Google Forms with Add-ons

With Add-ons available for Google Docs and Sheets, it was only a matter of time before these custom tools made their way to other parts of the Google Drive suite. If you happen to use Google Forms on a regular basis, you have to be thrilled that Add-ons are now available there, as well.

According to the original announcement via the Google Drive blog, “Add-ons bring handy extras to your survey building experience, like setting a survey end date, sending custom emails based on responses, storing lists of choices that you frequently add to questions, and more.”

Just like Add-ons for Docs and Sheets, these tools are available from the new Add-ons tab in your tool bar and then clicking Get add-ons.


There are sure to be a number of amazing tools available shortly in the Add-on store, but here are a few the Google Drive team noted:

formLimiter: Close your survey automatically, after a maximum number of responses is reached, or at a date and time of your choosing.


Ultradox Trigger: Create custom emails, reports, invoices, newsletters, etc., based on information that people enter into your form.


Form Values: Store and pull from lists that you use regularly in Forms, like a list of staff, students, rooms, resources or anything you want.

There are plenty of reasons to be excited about Add-ons for Forms, but simple things like being able to limit the number of responses to a Form, closing a Form at a certain time and pulling in regularly used data are huge for power users. This update is another step (and a huge one) to make Forms a viable option for nearly any survey or data collecting situation.


Google announces Inbox, a brand new way to do email

Today, Sundar Pichai (SVP of Android, Chrome & Apps) announced a huge development for email as we know it on the Official Gmail Blog. The product is called Inbox, and it is a brand new way to approach email “designed to focus on what really matters.” Inbox will be a cross-platform solution (Android, iOS and the browser) and you can actually learn more at the official Inbox website.

Want to try out Inbox by Gmail before all your friends? Enter our contest here to win an invitation for FREE!

Pichai’s blog post covers a few really interesting features that will come with Inbox, which you can check out in the GIF below. Google will begin sending out invitations to try Inbox shortly, or you can request an invitation by emailing

Inbox from Google (2)

Here are some of the key features, as explained in the original announcement:

Bundles: stay organized automatically
Inbox expands upon the categories we introduced in Gmail last year, making it easy to deal with similar types of mail all at once. For example, all your purchase receipts or bank statements are neatly grouped together so that you can quickly review and then swipe them out of the way. You can even teach Inbox to adapt to the way you work by choosing which emails you’d like to see grouped together.


Highlights: the important info at a glance
Inbox highlights the key information from important messages, such as flight itineraries, event information, and photos and documents emailed to you by friends and family. Inbox will even display useful information from the web that wasn’t in the original email, such as the real-time status of your flights and package deliveries. Highlights and Bundles work together to give you just the information you need at a glance.


Reminders, Assists, and Snooze: your to-do’s on your own terms
Inbox makes it easy to focus on your priorities by letting you add your own Reminders, from picking up the dry cleaning to giving your parents a call. No matter what you need to remember, your inbox becomes a centralized place to keep track of the things you need to get back to.


Manage Revisions in the New Google Drive

If you’re using Google Drive to store and edit Microsoft (or any other non-Google) files, it can get confusing if you’re uploading different versions of the same file. By managing versions in Drive, you can delete a file if it’s no longer relevant and make sure your collaborators are only viewing the correct file.

Manage Revisions was available in the previous version of Google Drive, but it just now made its way to the new Drive. This is great for those of you working with Office files, as well as PDFs, images and much more!


How to Disable Auto Play Video Ads in Google Chrome

I think we’re all familiar with the annoying ads that automatically play video or audio whenever you visit a website. There are a number of great extensions to get rid of these ads, but there’s actually a really easy setting in Chrome that can get the job done too.

All you need to do is go into the settings section of Google Chrome and change plugins to ‘Click to play’ rather than ‘Run automatically.’ There are a couple of other things you should keep in mind when changing this setting, so check out the video to learn more!

To disable auto play video / audio ads:

  1. Open Settings in Google Chrome
  2. Click ‘Show advanced settings’
  3. Click ‘Content settings’
  4. Switch Plug-ins to ‘Click to play’ from ‘Run Automatically’

Thanks to /r/LifeProTips for this great tip!


How to Create a Works Cited with Google Docs

If your students are creating research papers in Google Docs, why not show them how to create works cited there too? With the EasyBib Add-on for Google Docs, students can easily create a bibliography and add it directly to their research paper.

EasyBib is one of our favorite Add-ons for GAFE because it makes the citation process so simple, ensuring that all sources are properly referenced. Students can search for books, journal articles and websites inside their Doc and format the citations in MLA, APA or Chicago style.

Sign up here to join The Gooru Newsletter! You’ll receive each new post as they are published + The Gooru’s Ultimate Guide to Google Apps! Sign up here.


Send Bulk Emails Through Gmail With Google Drive

We’ve covered Add-ons for Docs and Sheets in a lot of detail, but I want to go in-depth on one of our absolute favorites. Merge by MailChimp uses the power of Docs, Sheets and Gmail to send custom bulk emails.

Merge actually mirrors the functionality of a Google Apps Script, but brings it into a much more user friendly interface so anyone can use it! You can create your email in Google Docs and personalize it with merge tags from Google Sheets.

You can install Merge (and a bunch of other Add-ons) right inside your Google Doc. From there you can pull in information from a specific Google Sheet so you can send out dynamic emails in bulk.

Sign up here to join The Gooru Newsletter! You’ll receive each new post as they are published + The Gooru’s Ultimate Guide to Google Apps! Sign up here.


3 Ways To Get Support For Google Apps

Google has made a concerted effort to constantly improve support options for Google Apps, and that continues this week with the introduction of chat support. While this is only available for Admins, everyone else can get help inside of Google Apps with a really cool option covered in this video.

In addition to chatting with Google in their help center, Admins will soon have the ability to reach support by phone directly inside of Gmail, Drive, etc. And if you’re an end user just trying to figure out how to use Gmail, you can actually access popular support articles directly inside of your inbox.

P.S. If you liked this post you might enjoy the Google Gooru Newsletter. Sign up today to receive each new post, right in your inbox! Sign up here.


Spell Check in Google Sheets

When the new version of Google Sheets was introduced, many of us noticed that several features from the old version were not available. Several of those features were slowly introduced, but Spell Check has finally been added to the new Google Sheets.

Spell Check with Google Sheets behaves just the same as it does with Docs or Slides. The information is pulled in from the web so it’s always up to date, and you can add words to your dictionary so you don’t repeatedly get asked to change words.

In this video you will learn how to Spell Check with the old Google Spreadsheets, the new Google Sheets and the differences between the two. It’s great to see a missing feature finally be added to Sheets and we hope many more are soon to come!

Here’s a GIF for a quick look at adding Spell Check to Google Sheets!

P.S. If you liked this post you might enjoy the Google Gooru Newsletter. Sign up today to receive each new post, right in your inbox! Sign up here.


Adjust Color and Add Filters to Images in Google Slides

Google gave you the ability to crop and add borders to images in Slides a few months ago, and now they’re bringing even more customizability. The new ‘Image options’ button makes creating beautiful presentations even easier.

This brand-new button give you the ability to adjust the transparency, brightness and contrast of images, while still making it incredibly simple to revert back to the original version. You can also choose between 19 different filters to customize your images!

P.S. If you liked this post you might enjoy the Google Gooru Newsletter. Sign up today to receive each new post, right in your inbox! Sign up here.


5 Tips on Using Google Apps for Meetings

As technology continues to change how we work, one of the main holdovers refuses to go away. While meetings undoubtably serve a very important purpose, many people find themselves wasting time and desperately searching for alternatives. Fortunately for you, Google Apps provides a ton of options for improving the meeting experience from the planning / scheduling faze to the follow-up. Check out 5 of our favorite tips designed to save you time and let us know in the comments what you do to save time in meetings!

1. Turn your scheduling into a breeze

Find a time in Google Calendar

We know how busy your days can be – with daily standups, appointments, conference calls, and other meetings cluttering your schedules at work. Your Google Calendar probably looks like a multi-colored palette of all the day’s happenings, and you’re struggling to find ‘white space’! Have no fear – your savior is here. With the “Find a time” feature on Google Calendar, you can easily schedule a meeting time that accommodates all your co-workers’ schedules, too.

When you make a new event in Google Calendar (or open an existing one), simply click on the “Find a time” tab. All you have to do is enter the email addresses of the meeting’s attendees (you can select up to 20), and their calendars will magically appear on your screen. As a result, you can easily select a time that works for everyone by complying with all their schedules (Your meeting guests will have to share their calendars with you, or make their calendars public, in order for this to work).

2. Have all the relevant files ready to go beforehand

Event Attachments in Google Calendar

How often do you waste time scrambling through your e-mail or hard drive for documents, presentations, spreadsheets, or other files during a meeting? Your time is precious – we know that. So, make it easier for yourself, and everyone else – accumulate all the necessary files for the meeting before you even begin. You can easily attach documents to your Google Calendar invite right as you’re drafting it up with the Event Attachments Lab.

The meeting attendees will see these files in the invitation e-mail they receive to the meeting, under the “More details” section in their invite. As a result, you’ll easily be able to access the files pertaining to that particular meeting not only during the meeting itself, but also in the future if you need to double-check something or track something down. All you need to do is click back to that specific date on your calendar, and you’ll see all the files.

3. Hangout with your co-workers…literally

Google Hangouts for Meetings

Video conferencing has become an increasingly popular medium for holding meetings, conference calls, and other collaborations in the workplace. However, many of the existing tools do not allow multi-person conferencing, and do not offer the ability to collaborate on tasks and/or documents during these calls. Google Hangouts is your best solution to this, and all you need is to set up a Google Apps account. Best of all, it’s free.

Google Hangouts give you the ability to create a Google Doc (or Sheet, Form, Presentation, and / or Drawing) during the Hangout itself! This could be a meeting agenda, action items, or a draft proposal of a piece that’s being discussed on the Hangout. All you have to do is click on ‘Google Drive’ on the left-hand side of your screen, and then simply choose ‘Create Shared Notes.’

4. Follow up, follow up, follow up

Share Follow up notes with Google Docs

A meeting is essentially useless if the attendees leave unaware or unclear of what has been done, and what needs to be done. In order to combat this lack of clarity, be sure to mark every agenda item in your meeting minutes as either a follow-up or an outcome. This simple distinction will increase productivity and efficiency all-around. Share the Google Doc with the rest of the meeting guests, and ensure they are easily able to tell what they need to do.

For even better clarity, you can note on the Doc who exactly needs to do what. In addition, be sure to track changes on the document if your team members will mark off what they’ve done from the follow-ups. You can also choose whether certain team members will only be able to view, comment, or edit the document. An alternative option is to use Do, which allows you to visually mark followups and see all of your meeting takeaways in one place.

5. Be resourceful

Calendar Resource in Google Apps

A little-known feature of Google Calendar is that it has the ability to not only add guests to a meeting, but resources too. This could be anything from projectors to cables to meeting rooms. When creating a meeting in Google Calendar, the individual sending out the invite can add resources to the meeting with an easy click.

Simply click on the ‘Resources’ button, next to the ‘Guests’ button on the screen which displays the event details. The information on these resources will be included on the invite email, so questions of confusion surrounding meeting locations, rooms, or equipment do not need to be answered. And that means less emails, too! (Note: Calendar Resources must first be set up by Google Apps Administrators in the Admin Console)

P.S. If you liked this post you might enjoy the Google Gooru Newsletter. Sign up today to receive each new post, right in your inbox! Sign up here.