Tag: Google Spreadsheets

User Interface

Google Spreadsheet Button to Run Scripts in 4 Steps

If you come from Excel, you might have seen some fancy spreadsheets with clickable buttons that trigger VBA macros. Luckily, Google Spreadsheets and Google Apps Script offer the same functionality. If you are just starting out with Google Apps Script, checkout out this Google Apps Script macro tutorial for a beginners guide. This tutorial will […]

Programming & Data

How to Get, Parse, Query, and Return JSON

  JSON (JavaScript Object Notation) is a great way to pass data around the Web.¬†It is easy for humans to read and it’s easy to work with in most programming language (including Google Apps Script). This post will show you a number of useful examples of how to work with JSON with Google Apps Script. […]

User Interface

Google Apps Script Custom Menus

  It is fitting that my first post on this site is about custom menus with Google Apps Script, because, often, custom menus are your users’ first touch with your custom functionality. Your users will be surprised the first time they see the custom¬†menu on their Google App UI. And they will be delighted when […]