Running Google Apps Script for the First Time: What’s with all the Warnings!

Google Apps Script

You’ve probably landed on this page because, like most of us, the first time we ran a Google Apps Script we came across a gauntlet of ever-increasing warnings asking us if we truly want to run this script. That’s cool. This is just Google trying to protect users.

Unfortunately, it does make things a little confusing for the first time Google Apps Script coder.

So what’s happening?

When we run a Google Apps Script code it often needs access to read, edit or write in certain locations, like your Google Drive, Google Sheets, Google Docs, etc. Each action that impacts you the user requires certain levels of authorisation from you to access it.

Because giving this authorisation to your code can make changes to your Google environment, Google provides a slew of warnings to ensure you are confident in what you are doing.

Sure, this is annoying for the regular Google Apps Script developer, but it is an important protection for the everyday user.

Check out the video below for a walkthrough on how to run complete the authorisation process and run your code for the first time:

Continue reading “Running Google Apps Script for the First Time: What’s with all the Warnings!”