As Schema.org JSON-LD usage spreads across the internet and its utility increases, I find myself creating a lot more JSON-LD templates for non-standard entities… and then I find myself copying them over and over for each of their sibling entities. Finally, I decided I had had enough of this and looked to solve this problem …
JSON-LD Bulk Editor and File Generator for Google Sheets Read More »
Sometimes it’s just easier to separate concerns. Just like how stylesheets and .js scripts separate the form and function of the page from the presentation of the page, the same can be done with the JSON-LD schematic markup / structured data of the page. This example shows how you can add structured data for SEO …
Using Hosted JSON-LD Files as applications/ld+json Scripts for SEO Read More »
ZIP codes are a very useful and common way to gather location data. But zip codes alone are often less useful than the city, state, latitude and longitude that correspond to the zip code. City and state/region, allow you to group the data with a pivot table while City and state/region, allow you to group and …
Zip Codes to City, Region & Geocode in Google Sheets Read More »
Business and education administration often involves an overwhelming amount of repetitive tasks. We work in cycles of days, weeks, months, and years with multiple students, clients, employees, or team members. This adds up to multiples of multiple tasks. Luckily, automating repetitive and work-intensive tasks is just one of the many things Google Apps Script was made for. In …
Copy Multiple Google Sheets with Template Variables Read More »
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, check out this Google Apps Script macro tutorial for a beginner’s guide. This tutorial will demonstrate how …
Google Spreadsheet Button to Run Scripts in 4 Steps Read More »
This post has been moved from a site that I used to run at googleappscripting.com 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 languages (including Google Apps Script). This post will show you a …
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 the functionality …
If you are new to Google Apps Script or programming in general, Google Apps Script Web Apps may seem daunting. The good news is that it is easy to understand with a little trial and error. This tutorial will give you 12 recipes to help you get started with the doGet and doPost functions and show …
Google Apps Script doGet and doPost Tutorial + 6 Web App Examples Read More »
You might be new to the whole idea of “bots” or acronyms like REST, API, HTTP, and cURL. And you probably don’t know how to code your way out of a wet paper bag. But this doesn’t mean you cannot or should not get your hands dirty and have a little fun making a customized little …
Slack Slash Commands for Everyone + 10 Free APIs Read More »
I just finished a project where I was using IPython and Pandas a lot more than spreadsheets. I found that after using Pandas, I started to think about data a little differently. When I returned to Google Spreadsheets, I realized it wasn’t capable of displaying the data in the way that I wanted to. So …
