google drive Archives - Jeff Everhart

Translate Text Selection in a Google Doc using Google Apps Script

In this quick tutorial, we’re going to build a simple little menu add-on for Google Docs that lets you translate text into another language. Some of this functionality may be baked into Google Docs at this point, but this should be a good tutorial that wraps together a few different services and methods of augmenting […]

Read More

Resetting Triggers in Google Apps Script

Occasionally, when you are running a Google Script attached to a spreadsheet or document, the triggers that run those scripts can sometimes start to malfunction. Over the last five years, I haven’t been able to identify meaningful patterns for why these triggers and the associated scripts fail, but it just happens sometimes. However, here are […]

Read More

Add Custom Menus to Google Docs, Sheets & Forms

Using custom menus can help you automate and streamline certain tasks in Google Apps Script by creating easy-to-use interfaces so other people can run and benefit from your code. In this post, we are going learn how to add custom menus to Google Docs, Sheets, and Forms using Google Apps Script. Adding custom menus allows […]

Read More

How to serve JSON using the Google Apps Script Content Service

I’ve got another Google Apps Script tutorial here for everyone, and this time we’ll be taking a look at one of the advanced services provided by Google Apps. Most of what we’ve talked about so far involves building on top of one of the existing Google Apps services, but this one is entirely new and […]

Read More

How to insert and remove rows and columns in Google Sheets

In this Google Sheets training tip, you will learn how to insert and remove rows and columns in a Google Sheet. Sometimes, when you are working with Google Sheets, you will need to shift things around and add or remove rows/columns. Check out the quick video below or read through the written explanation. Step 1: […]

Read More