Beginner's Guide to Google Apps Script 1 - Sheets (Step-By-Step Guides to Google Apps Script)

[LeeAndro]

2020 | English | B08C94RJMC | EPUB | B08C94RJMC | 4 MB

Do you want to have Google Sheets super powers​

Learn Google Apps Script and learn how to automate Google Sheets.

This step-by-step guide to using Google Apps Script with Google Sheets will show you how powerful Sheets can be and how you can automate them saving you and money!

This book assumes no knowledge of coding or of Apps Script or of JavaScript and will take you from writing your first script to using Apps Script with Sheets with confidence.

Every chapter contains numerous practical examples of scripts with every step explained along the way. It also contains links to the files used in the book. It also covers some Javascript fundamentals, like loops and arrays, relating them specifically to their use in Apps Script.

Fully updated including the latest JavaScript and the new Script Editor. This is book 1 in a series on Apps Script.
Contents
What is Google Apps Script
CHAPTER 1 - First Script
CHAPTER 2 - Variables and getting & setting values
CHAPTER 3 - Loops
CHAPTER 4 - Arrays, Logger & Executions
CHAPTER 5 - If, Prompt, Menu & OnOpen Trigger
CHAPTER 6 - SpreadsheetApp & the For In Loop
CHAPTER 7 - Spreadsheet Class
CHAPTER 8 - Sheet Class
CHAPTER 9 - Range class & Triggers
Appendix 1 - Files for each chapter
Appendix 2 - Script Editor and creating a standalone script



DOWNLOAD

https://1dl.net/bnfx6wj9dsk9/w1PGZw08__Beginners_Guide_to_Google_Apps_Script_1.rar.html