[{"_1":2,"_64":-5,"_65":-5},"loaderData",{"_3":4,"_33":34,"_62":-5,"_63":-5},"root",{"_5":-5,"_6":-5,"_7":8,"_20":-5,"_21":22,"_23":24,"_27":28},"user","shoppingCartId","shoppingCart",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":12},"count",0,"free",true,"updatedAt","2026-01-09T21:40:09.155Z","paymentGateway","STRIPE","cartItems",[],"loading","toast","locale","en","constants",{"_25":26},"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","publishers",{"_29":30,"_31":32},"companies",[],"universities",[],"routes/_store+/_readers+/email_author.$slug/route",{"_35":36,"_61":-5},"book",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48},"id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMzgxMw","title","Google Sheets Programming With Google Apps Script (2015 Revision Complete)","state","retired","contactAuthorMethod","email","aboutText","

All those who buy this version and those who have bought it already will get future updates and additions for free (2015 revision is complete).

Google Spreadsheets and Google Apps Scripts (GAS) are both evolving rapidly so I want to ensure that the material presented here remains up-to-date and continues to improve. Please email me details of any errors you find or with any suggestions you have for new material.

This book provides a resource for all those wishing to develop spreadsheet applications in Google Spreadsheets. The book grew out of a blog that I have been writing since early 2011 see blog site. However, it aims to be much more comprehensive than the blog. The blog gave me a good idea of what material is of most interest to readers, thereby allowing me to concentrate on these topics. It covers the Google Apps Script sub-set of JavaScript as it applies to Google Spreadsheets. As the reader progresses through the book, they will learn how to:

Write user-defined spreadsheet functions.
Manipulate the key Google API objects.
Build user interfaces.
Interact with other Google applications and services.
Use a MySQL database running in the Cloud as a back-end data store.

Throughout there is an emphasis on practical applications.

It provides well documented code examples that can be cut-and-pasted and then modified to suit the reader's needs.

There is also an appendix for experienced Excel VBA users that shows common spreadsheet coding techniques in both VBA and Google Apps Script.

All the example code in this book is available for download as a single file at https://github.com/Rotifer/GoogleSpreadsheetProgramming_2015

Please send any feedback/queries/correction/requests for clarification to:

mick@javascript-spreadsheet-programming.com

","authors",[49],{"_37":50,"_51":52,"_5":53},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8zOTU2","name","Michael Maguire",{"_54":55},"avatar",{"_56":57,"_58":59,"_60":12},"url","https://secure.gravatar.com/avatar/969cafaf78751c1ac1b3c83c656d1ec6?r=pg&d=mm","styleName","medium","exists","currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the Author