Google Apps Archives - Jeff Everhart

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

Using Google Sheets and Google Apps Script to Work with APIs

One of the coolest things about working with Google Apps Script is the overall versatility of the Google Apps ecosystem. I’ve written pretty extensively about how to use Google Apps Script to do a lot of more business focused things, like send an email with Google Forms submissions, sending an attachment with Google Forms submission, […]

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

Google Forms Confirmation Email with Attachments

Google Forms is a great tool to use to make quick and easy sign-up forms, but sometimes you need it to do something else a bit more complex. In this short tutorial we’ll talk about how to extend a basic Google Form script that sends confirmation email to also send attachments. If you don’t know […]

Read More

How to send a confirmation email with Google Forms

In this short tech tip, we are going to look at how to make a Google Forms send a confirmation email to the user each time they submit a form. This is just a basic template for how to make this happen, so it is worth mentioning that there are plenty of other ways to […]

Read More