Posts

Showing posts from July, 2019

How to Download your Google Slides Presentation as a Video File

Image
With Microsoft Powerpoint, you can easily convert your presentation decks into high-resolution video files for uploading to YouTube and other video sites. The exported video files can also include all the voice narrations and background audio that you may have included in the presentation. Google Slides doesn’t offer an option to save presentations as videos but there’s a new add-on in town – Creator Studio – that brings new export capabilities to your Google Slides. With Creator Studio, you’ll be able to save your decks as animated GIFs , image sequences and HD video (with audio). Watch the video tutorial   for a quick introduction. To get started, go to creatorstudio.dev and install the Google Slides add-on. It requests certain permissions as it has to read the presentation images for converting them into movies. It also requires access to creating files in your Google Drive since the exported files are automatically uploaded to your Google Drive. Once the add-on is i...

How to Copy Draft Emails in Gmail

Image
You have composed a draft email inside Gmail and would like to send the same message to multiple people, but separately. The subject, the email body, the attachments are common and the only thing that differs between each message is the recipient’s email address. Maybe you are sending your résumé  to multiple companies. How can you do this without having to copy-paste the subject and body of the draft message multiple times? Create Duplicate Email Messages in Gmail When you compose a draft email in Gmail and hit the Send button, the email is automatically removed from the Drafts folder and moved to the Sent Items folder. There are however two easy ways to create duplicate draft emails inside Gmail. You can either use Mail Merge for Gmail  or, if you are looking for a more simple one-click option, use the Duplicate Drafts feature available inside Email Studio. Here’s how to get started. Open your Gmail mailbox, compose a new email messag...

How to Email Spreadsheets Automatically on a Recurring Schedule

Image
Introducing Email Spreadsheets , a Google Sheets add-on that lets you automate the reporting of spreadsheet data and dashboards by email. If you are an office worker who has been emailing spreadsheets to colleagues manually, this add-on will save you a ton of time. And because it runs on the Google Cloud, your spreadsheet reports will be delivered even while you are offline or on vacation. With Email Spreadsheets, you can schedule reports and it will automatically send them by email on a recurring schedule. You can email entire workbooks, specific sheets inside a workbook or even range of cells. Watch the video tutorial to get started. Email Google Sheets Automatically Go to the Google add-on store and install Email Google Sheets . Next, open any Google Spreadsheet in your Google Drive, go to the Add-ons menu inside the sheet, choose Email Spreadsheets from the dropdown and then choose Rules to create your first scheduled email report. You are presented with a 3-step wizard t...

How to Track your Study Time with Google Forms and Sheets

Image
In most organizations, employees are required to fill timesheets every week so the company can track the amount of time that people have spent working on various projects and tasks. My kids are in middle/high school and I’ve been looking for a timesheet-style solution that would help me understand their studying patterns and learn how much time they spend on various subjects. There are quite a few apps available for time tracking but I was looking for something simple and Google Forms fit the bill perfectly. The multiple-choice grid question is handy for quickly marking the time that they have spent on various subjects. I also added a Linear scale question for them to self-evaluate their daily screen time on a relative scale. Here’s how the final study log form looks like: The Email Form Notifications add-on is enabled for this Google Form so parents get an instant email when the boys submit the study log form. The email contains all the form answers in a neatly formatted table...