Email the Author

You can use this page to email Michael Maguire about Google Sheets Programming With Google Apps Script (2015 Revision Complete).

Please include an email address so the author can respond to your query

This message will be sent to Michael Maguire

This site is protected by reCAPTCHA and the Google  Privacy Policy and  Terms of Service apply.

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 https://github.com/Rotifer/GoogleSpreadsheetProgramming_2015

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

mick@javascript-spreadsheet-programming.com


About the Author

Michael Maguire’s avatar 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.

Logo white 96 67 2x

Publish Early, Publish Often

  • Path
  • There are many paths, but the one you're on right now on Leanpub is:
  • Googlespreadsheetprogramming › Email Author › New
    • READERS
    • Newsletters
    • Weekly Sale
    • Monthly Sale
    • Store
    • Home
    • Redeem a Token
    • Search
    • Support
    • Leanpub FAQ
    • Leanpub Author FAQ
    • Search our Help Center
    • How to Contact Us
    • FRONTMATTER PODCAST
    • Featured Episode
    • Episode List
    • MEMBERSHIPS
    • Reader Memberships
    • Department Reader Memberships
    • Author Memberships
    • Your Membership
    • COMPANY
    • About
    • About Leanpub
    • Blog
    • Contact
    • Press
    • Essays
    • AI Services
    • Imagine a world...
    • Manifesto
    • More
    • Partner Program
    • Causes
    • Accessibility
    • AUTHORS
    • Write and Publish on Leanpub
    • Create a Book
    • Create a Bundle
    • Create a Course
    • Create a Track
    • Testimonials
    • Why Leanpub
    • Services
    • TranslateAI
    • TranslateWord
    • TranslateEPUB
    • PublishWord
    • Publish on Amazon
    • CourseAI
    • GlobalAuthor
    • Marketing Packages
    • IndexAI
    • Author Newsletter
    • The Leanpub Author Update
    • Author Support
    • Author Help Center
    • Leanpub Authors Forum
    • The Leanpub Manual
    • Supported Languages
    • The LFM Manual
    • Markua Manual
    • API Docs
    • Organizations
    • Learn More
    • Sign Up
    • LEGAL
    • Terms of Service
    • Copyright Policy
    • Privacy Policy
    • Refund Policy

*   *   *

Leanpub is copyright © 2010-2025 Ruboss Technology Corp.
All rights reserved.

This site is protected by reCAPTCHA
and the Google  Privacy Policy and  Terms of Service apply.

Leanpub requires cookies in order to provide you the best experience. Dismiss