Setting up Triggers in Google Apps for Debugging

In my previous article I wrote about setting up a workflow for users to enter data into a Google form and the information is merged into a document and a PDF is created. You can read that article here. When you are trying to diagnose issues triggers with notifications can really help your debugging problems. Lets take a look at setting up triggers in Google Apps scripting.

We are going to pickup in our script editor in Google apps (Spreadsheet – Tools – Script editor)



Here you should see your code displayed for your different functions:

To setup our trigger click Resources, Current Scripts Triggers.



A popup should come up that looks like this:

Click to add a new trigger. The options are very simple, especially for what we want to do. In your code you have to link the code to the form and this is where you do that. In the image below you can see we are running our function when the form is submitted. To receive an email click the notifications button at the end.

 When you click “notifications” you should see another popup that allows you to select immediately . This allows you to get your debug information immediately.


Now that notifications are setup you will get emails that look like this:



When there are issues.


If you have questions comment below or email me at TJ at





TJ Houston

TJ Houston

Hey everyone,
My name is TJ and I am here to help you! I am a lifelong learner that strives to help others.

Work: By day I work for Panasonic as the Sales Support Rep for the Midwest Region.
Play: I love all things photography, videography, and tech!
Home: I have a loving wife (Ashley) and an adorable German shepherd (Jynx)

You can find me on twitter @tjhouston or if you want to check out some photos, you can follow me on instagram @lumix_tjhouston!

All of the views on this site are my own and do not reflect the views of my employer.