What do you think?
Rate this book
Beginner's Guide to Google Apps Script 1 - Sheets
A step-by-step guide to using Google Apps Script with Google Sheets. You will learn how to work with and automate Sheets.
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.
This is book 1 in a series on Apps Script.
What is Google Apps Script?
CHAPTER 1 – Script Editor
CHAPTER 2 – First Script
CHAPTER 3 – Variables and getting & setting values
CHAPTER 4 – Loops
CHAPTER 5 – Arrays, Logger & Execution Transcript
CHAPTER 6 – If, Prompt, Menu & OnOpen Trigger
CHAPTER 7 – SpreadsheetApp & the For In Loop
CHAPTER 8 – Spreadsheet Class
CHAPTER 9 – Sheet Class
CHAPTER 10 – Range class & Triggers
Further Reading
About the author
Appendix 1 – Code from each chapter (Spreadsheets)
Appendix 2 – Adding Script Editor to your Google Drive and creating a standalone script
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.
This is book 1 in a series on Apps Script.
What is Google Apps Script?
CHAPTER 1 – Script Editor
CHAPTER 2 – First Script
CHAPTER 3 – Variables and getting & setting values
CHAPTER 4 – Loops
CHAPTER 5 – Arrays, Logger & Execution Transcript
CHAPTER 6 – If, Prompt, Menu & OnOpen Trigger
CHAPTER 7 – SpreadsheetApp & the For In Loop
CHAPTER 8 – Spreadsheet Class
CHAPTER 9 – Sheet Class
CHAPTER 10 – Range class & Triggers
Further Reading
About the author
Appendix 1 – Code from each chapter (Spreadsheets)
Appendix 2 – Adding Script Editor to your Google Drive and creating a standalone script
186 pages, Kindle Edition
Published September 5, 2019
20 people are currently reading
8 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.