A step-by-step guide to using Google Apps Script with GOOGLE DRIVE. This book assumes no or little knowledge of coding or of Apps Script and will take you from writing your first script to using Apps Script with Drive with confidence. Every chapter contains numerous practical examples of scripts with every step explained along the way. For example, creating multiple PDFs and folders, automatically sending brochures when a form is filled out, listing all the files in your Drive, and more. It also contains links to the complete scripts, which can easily be copied and pasted into your own projects. Plus, it shows how the Drive service can be used with the Document, Spreadsheet, Slide, Map, and Form services. This is book 3 of a series on Apps Script. Updated to include changes to adding and removing files, adding shortcuts, and the new Script Editor. Contents: Introduction Standalone scripts Chapter 1 - Creating files and folders in My Drive Chapter 2 - Creating files & folders in specific folders Chapter 3 - Making copies of files and creating folders from a URL Chapter 4 - Adding and removing files and folders Chapter 5 - Adding and removing editors to/from files & folders Chapter 6 - Copying a Doc and making a PDF from it Chapter 7 - Getting contents of a Drive folder Chapter 8 - Getting files by type Chapter 9 - Creating download URLs Chapter 10 - Automatically send a brochure when a form is submitted Chapter 11 - Searching files & folders Links to the complete scripts Script editor tools JavaScript basic

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. 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 - Code from each chapter Appendix 2 - Script Editor and creating a standalone script

A step-by-step guide to using Google Apps Script with Google Forms. You will learn how to automatically create forms and quizzes, and how to use the responses from a form, and for example, automatically email the information when the form is submitted. This book assumes little knowledge of coding or of Apps Script or of JavaScript, although some previous knowledge of Apps Script with Sheets is helpful but not essential. It will take you from writing your first form script to using Apps Script with Forms 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 methods like forEach, slice, indexOf, relating them specifically to their use in Apps Script and working with Google Forms. This is book 2 in a series on Apps Script.Updated using the new script editor - 2021. CHAPTER 1 - First Forms script CHAPTER 2 - Creating & updating a Google Form CHAPTER 3 - Creating & updating a multiple question Form CHAPTER 4 - Adding different types of questions to a Form CHAPTER 5 - Using Form responses CHAPTER 6 - Form validation CHAPTER 7 - Form page navigation CHAPTER 8 - Making quizzes in Google Forms Further Reading Appendix 1 - File and code from each chapter Appendix 2 - Authorizing a script

This book is a simple step-by-step, example-oriented guide with a focus on providing the practical skills necessary to develop and customize apps with Apps Script. If you are an application developer with no knowledge of App Script, and would like to learn to build apps using Google Apps script from scratch, then this book is for you. Basic JavaScript knowledge is required.

Explore how you can create useful web apps that integrate easily within your Google Suite of Product - Basics of starting with Google Script - Course covers how to create a spreadsheet using code - How to get, set and update content within your spreadsheet - How to work with spreadsheet app class - How to create a web app within Google Apps Script - Using HTML service - Passing data from Google Script to client side - Sending data from Client side to server side Google Script - Connecting Sheet information to present to Client side web app - Sending a PDF from client side to upload and save to your Google Drive - Sending email notification on upload of PDF from user - How to create web apps with Google script Who this course is for: - Web developers - Application developers - Anyone who wants to learn more about Google Apps Script - Anyone who wants to automate Google Suite - JavaScript coders Requirements: - JavaScript, HTML and CSS - Prior programming knowledge - Solid understanding of JavaScript.

This book is a simple stepbystep, exampleoriented guide with a focus on providing the practical skills necessary to develop and customize apps with Apps Script.If you are an application developer with no knowledge of App Script, and would like to learn to build apps using Google Apps script from scratch, then this book is for you. Basic JavaScript knowledge is required.