When you use Google Apps like Google Sheets or Google Docs, Google Script permits you to accomplish issues you could possibly by no means may with an analogous desktop utility.
Google Script (also referred to as Google Apps Script) is an utility improvement platform that allows you to combine the entire Google Cloud companies you utilize.
Google gives a protracted listing of APIs for every considered one of their cloud companies. By writing quite simple Google apps, you may open up a complete world of further options in every considered one of Google’s many companies.
What Can You Do With Google Script?
Studying Google Script may be very straightforward. Just some of the issues you are able to do with Google Script embody:
- Creating customized features in Google Sheets
- Integrating Google Sheets or Google Docs with Gmail
- Creating internet apps you may deploy utilizing Google Websites
- Including a customized menu to Google Docs
- Creating web traffic dashboards in Google Sheets utilizing Google Analytics information
- Sending email from Google Sheets or some other Google service
Since Google companies are all within the cloud, you may create your Google Apps script from a single script editor. From that code you may faucet into the APIs for any of Google’s companies you utilize.
This creates a flexibility that’s exhausting to search out in most different scripting platforms.
Writing Your First Google Apps Script
To see how straightforward it’s to jot down a Google Script, attempt the next instance.
Your first script will ship an e mail out of your Gmail account, with a message embedded in your Google Script.
- Open an online browser and sort script.google.com into the URL area.
- Log into your Google account in case you aren’t already.
- As soon as logged into Google Apps Script, click on on New script.
- The place it says Untitled venture, kind the title My First Script.
Delete the code within the script window, and paste the next:
Click on on the disk icon to Save the code. Then click on on the Run icon to run it.
It’s possible you’ll want to supply permission for the script to run utilizing your Google account the primary time, and to ship e mail out of your Gmail account.
You may even see a warning that the app isn’t verified. Simply click on on Superior and Go to My First Script (unsafe). Because you’re the one who wrote the app, you will be assured that it’s completely protected to run.
Right here’s what that incoming e mail will appear like:
This script used the Gmail service to ship an e mail out of your account through Google Script.
It’s only one easy instance of how a Google Apps Script can faucet into any of your Google cloud companies.
Including Extra Options to Google Companies
You’ll discover entry to Google Scripting from within lots of Google’s companies as properly.
As talked about above, this allows you to add prolonged options to these companies. For instance, within Google Sheets, you may entry your Google Script Editor by clicking on Instruments, after which clicking on Script editor.
We’ve beforehand checked out examples of creating custom functions and menus in Google Sheets. That’s a superb useful resource to get began constructing your personal.
You may entry the Google Scripts editor the identical method from Google Docs.
You may even use a Google Script to create a Gmail add-on to boost your Gmail expertise. This allows you to modify issues just like the message compose window and even writing a script that manages archiving previous emails.
To allow creating and testing Google Script add-ons, you could allow developer add-ons in your Gmail account. You are able to do this by going to Settings, then clicking on Add-ons and deciding on Allow developer add-ons for my account. You’ll must click on Allow on a pop-up window as properly.
Creating Gmail Add-ons is past the scope of this text. However in case you’re severe about diving into this, you may examine the Google Developer Guide on Building a Gmail add-on.
Accessing Google Script APIs
From inside your Google Script editor, you may entry every of your Google companies by utilizing a worldwide object. You used the GmailApp international object within the Hiya World instance above.
To entry the entire options (strategies and calls you may make from inside the Google Script editor), you simply must allow Superior Google companies for that service.
You do that from inside the Google Scripts editor by clicking on Assets and Superior Google companies.
Don’t overlook to click on on the Google Cloud Platform API Dashboard hyperlink on the backside and allow the service in that dashboard as properly.
When you’re within the Google Cloud Platform API Dashboard, click on on Allow APIs and Companies, seek for the title of the service within the API Library, choose it, after which click on on Allow.
You solely must allow the superior service as soon as for every Google account you utilize for scripting.
When you scroll down on this web page the place you’ve enabled the API Library, you’ll discover a hyperlink for Reference documentation. Save this hyperlink, as a result of it gives invaluable examples and syntax on how one can combine with that API inside your personal Google Scripts.
You may see a superb instance of integrating with Google Analytics utilizing Google Scripting in our guide to creating a website analytics dashboard.
Looking the API Library reveals simply what number of Google Companies you may combine into your scripts.
There are a whole bunch of obtainable APIs.
If you’re thinking about turning into a Google superuser, studying how one can use Google App Scripts is certainly the best way to go.
Past Google Script Fundamentals: What Now?
As you may see from the easy Hiya World instance above, studying how one can write a Google Script isn’t exhausting in any respect.
And since Google gives an intensive Google Apps Script library crammed with guides and references, you could have a stable base to start out from.
If you wish to get began on a barely extra superior Google Script utility, attempt your hand at integrating Google Forms and Gmail to rapidly apply to job openings.
Learn the complete article: What Is Google Script? How to Write Your First Google Apps Script