Image by Julio César Velásquez Mejía from Pixabay

If you’re like me, you have numerous unprocessed emails in your inbox. Sometimes it’s overwhelming. What to do? Spend hours processing each email in the Gmail interface or use a simple tool like Google Apps Script to speed the process. Google Apps Script is so versatile we often forget it can perform some of the most mundane tasks like assisting with email cleanup. So simple yet so powerful.

How to Setup Email Cleanup

Step 1: Open a Google Sheet

Step 2: Open the script editor (under the Tools menu) and copy the following code replacing the code in Code.gs.

The code has four options: Archive…


PIcture by Pixabay

In a previous post, I outlined the power of Google document URLs to perform “Simple, Powerful, Work” and promised to share several tools I’ve developed to aid in building them.

The first of these tools is TSDynamicUrls — an Apps Script powered dynamic URL generator hosted in Google Forms. See this post for more information.

The second tool is TSCreateUrlCheatsheet — a Google Sheets macro for creating a Google Workspace new resources shortcuts cheatsheet. See this post for more information.

In this post I’ll introduce a companion TSDynamicUrls tool hosted in a simple App Script web application.


Image by Peggy Dyar from Pixabay

In a previous post I introduced TSChatWise … a Google Sheets and Apps Script powered Google Chat tool for teaching and learning. 🚀

This post is the third post in a TSChatWise “Getting Started” series where I’ll discuss how to get started with TSChatWise.

👉 For an introduction to TSChatWise see TSChatWise — A Google Chat Education Tool.

👉 For an installation guide see TSChatWise — Installation.


Image by Peggy Dyar from Pixabay

In a recent edition of Totally Unscripted, I discussed TSChatWise … a Google Sheets and Apps Script powered Google Chat bot for teaching and learning.

👉 For an introduction to TSChatWise see TSChatWise — A Google Chat Education Tool.

This post is the second in a TSChatWise “Getting Started” series where I’ll lay out the steps for installing and configuring TSChatWise.


Image by Alexander Stein from Pixabay

In my previous post, I introduced TSDynamicUrls — an Apps Script powered dynamic URL generator (hosted in Google Forms) which transforms Google document URLs into new resource formats.

In this post, I introduce TSCreateUrlCheatsheet — a Google Sheets macro for creating a Google Workspace new resources shortcuts cheatsheet to help leverage the power of dynamic URLs.


Image by Peggy Dyar from Pixabay

Take your G Suite organization’s education to the next level with TSChatWise … a Google Sheets and Apps Script powered Google Chat tool for teaching and learning. 🚀

This post is the first in a TSChatWise “Getting Started” series.

A Brief History

I like shortcuts! I’m in constant search of what I deem to be the most simple, efficient and effective shortcuts. I consider any tool, system or methodology which helps me streamline workflow and save precious time a shortcut. When I believe I’ve discovered (or perhaps created) a shortcut, especially a G Suite shortcut, I like to share that shortcut with others.


Image by pencil parker from Pixabay

It’s time to chat. No better way to do this in G Suite for Business or G Suite for Education than with Google Hangouts Chat.

And why not invite a few of our “friends”?

With so many recently forced into remote work, organizations are scrambling to find solutions to keep their teams safely connected.

Whether you’re a large geographically diverse team or a small local team there’s an easy G Suite solution — Google Hangouts Chat rooms.

Not only are Hangouts Chat rooms great for team conversation and communication, they enable us to get more done with a little help…


Image Gerd Altman by Pixabay

I recently had the privilege of speaking at SheetsCon on the topic of Automation with Apps Script. During the presentation, I walked through a simple approval workflow for a hypothetical small business to demonstrate the power of Apps Script to automate workflow inside G Suite. I also showcased modern ECMAScript features supported by the new Apps Script V8 Javascript runtime.

Following is an overview of the workflow covered in my presentation along with install instructions for trying it out in your G Suite domain.

Workflow Automation Use Case

Let’s assume you’re a small business owner using G Suite.

You’re a savvy entrepreneur and recognize…


Image by PublicDomainPictures from Pixabay

In my previous post, I outlined the power of Google document URLs to perform “Simple, Powerful, Work” and promised to share several tools I’ve developed to aid in building them.


Image by OpenClipart-Vectors from pixabay.com

We learn from the study of physics that a simple machine is a mechanical device with few or no moving parts which changes the direction or magnitude of a force in order to perform … Simple, Powerful, Work.

In like manner, Google Document URLs (acting as simple machines) assist G Suite users in changing the direction or magnitude of those documents to perform … Simple, Powerful, Work.

Let me explain…

Google Document URLs As Simple Machines

Laura Taylor

Google Developer Expert for G Suite passionate about Workflow Automation and Productivity — https://www.tech-streams.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store