Google Sheets Programming… by Michael Maguire [PDF/iPad/Kindle]
Google Sheets Programming With Google Apps Script (2015 Revision Complete)
Google Sheets Programming With Google Apps Script (2015 Revision Complete)
Google Sheets Programming With Google Apps Script (2015 Revision Complete)

This book is 100% complete

Completed on 2015-09-29

About the Book

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

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

About the Author

Michael Maguire
Michael Maguire

I am a data manager. I used Excel VBA extensively in the past and wrote this book after learning how to program Google Spreadsheets with Google Apps Script.

The Leanpub 45-day 100% Happiness Guarantee

Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

See full terms...

Write and Publish on Leanpub

Authors and publishers use Leanpub to publish amazing in-progress and completed ebooks, just like this one. You can use Leanpub to write, publish and sell your book as well! Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks. Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. It really is that easy.

Learn more about writing on Leanpub