Google Apps Script

1. Running a script.md

Openning the Script Editor

With a Google Docs opened, choose

Tools -> Script Editor.

For use the script it must be encapsulated in a isolated (out of a class) function.

Using

See how to use the Google Script Apps in doc.

Google Sheet API.

Running

• Just click on run -> Review permissions (to authorize the script to make changes in your document);
• In the open window choose a google account -> click on Advanced -> Access ...(unsafe) -> Allow.

Note: to access all projects access this link.

See more.

2. Working with Macro.md

Creating

On script editor of the project

• Deploy a new version as library;
  • Click on Deploy -> New deploy;
  • Click on the gear "Enable deployment types" -> choose "Library";
  • Click on "Deploy".
• Click on "Triggers" (watch icon);
  • Click on New trigger;

Note: at each new deployment a new version of the script is created. Isn't possible to change the version on edit a trigger, it will be necessary to create a new trigger.

3. Google APIs.md

Activating an Google Service API For a Project

Address.