Beginners

What is it Google Apps Script?
Google Apps Script is a tool that allows you to customize and automate the Google Apps suite and third-party apps that integrate with Google Apps.

What is a script?
A script is a sequence of instructions that is interpreted and executed.
Think for example to your Spreadsheet file, do you want add a custom menu? This is possible through a script!

What you can do with Google Apps Script?
with Google Apps Script you can:

  • Customize Google Apps
    Google Apps Script allows you to add a new customized menu in a Spreadsheet document or export Gmail messages with a specific label to a Google Site or update social networks directly from a Spreadsheet document by filling cells with the text you want to publish.
  • Automate processes
    Google Apps Script allows you to create automatic or timed actions for example send a production report at 12.00 of every day or clear the content of a Spreadsheet document every first of the month.
  • Create graphical user interfaces
    Google Apps Script allows you to create web based graphical user interfaces for collecting and displaying user data and save them for example in a Spreadsheet document.

Before you start, the basics

Prerequisites
You must have at least a free or business Google account and a browser.

Access to Google Apps Script

Create a script
You can create your first Google Apps Script in different ways:

from a Spreadsheet file:
Tools -> Script Editor -> Blank Project
from Google Sites:
More -> Manage Site -> Apps Scripts
from Google Drive:
Create  -> More -> Script
or through the following link
https://script.google.com

ok, let’s go to create your first Google Apps Script

Found valuable informations?

If so please consider donating to us.