{"product_id":"beginners-guide-to-google-apps-script-1-sheets-paperback","title":"Beginner's Guide to Google Apps Script 1 - Sheets - Paperback","description":"\u003cp\u003eby \u003cb\u003eBarrie Roberts\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eDo you want to have Google Sheets super powers? Learn Google Apps Script and learn how to automate Google Sheets.\u003c\/p\u003e\u003cp\u003eThis 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 time and money!\u003c\/p\u003eThis 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. \u003cp\u003e\u003c\/p\u003eEvery 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. \u003cp\u003e\u003c\/p\u003eFully updated including the latest JavaScript and the new Script Editor. This is book 1 in a series on Apps Script.\u003cbr\u003eContents: \u003cbr\u003eWhat is Google Apps Script?\u003cbr\u003eCHAPTER 1 - First Script\u003cbr\u003eCHAPTER 2 - Variables and getting \u0026amp; setting values\u003cbr\u003eCHAPTER 3 - Loops\u003cbr\u003eCHAPTER 4 - Arrays, Logger \u0026amp; Executions\u003cbr\u003eCHAPTER 5 - If, Prompt, Menu \u0026amp; OnOpen Trigger\u003cbr\u003eCHAPTER 6 - SpreadsheetApp \u0026amp; the For In Loop\u003cbr\u003eCHAPTER 7 - Spreadsheet Class\u003cbr\u003eCHAPTER 8 - Sheet Class\u003cbr\u003eCHAPTER 9 - Range class \u0026amp; Triggers\u003cbr\u003eAppendix 1 - Files for each chapter\u003cbr\u003eAppendix 2 - Script Editor and creating a standalone script\u003cbr\u003eRev 11.\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 154\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.33 x 11 x 8.5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e June 30, 2020\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42727953432639,"sku":"9798662691254","price":20.23,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/5835299630d62254bf8e8d81b25d7086.webp?v=1765116716","url":"https:\/\/dhl-adrianne.myshopify.com\/products\/beginners-guide-to-google-apps-script-1-sheets-paperback","provider":"BBB","version":"1.0","type":"link"}