I’ve been spending a lot of time working with sitemaps lately. They are a critical component of getting sites indexed by search engines and a great way to learn about your competition’s architecture and search strategy. They literally map out the content that your competition is trying to add to search engine indexes and where […]
As you know, I love learning, and I am a huge advocate for self-service education. Recently, I had the honor of being interviewed on the Measureschool Youtube channel, where I got to share my path in learning and employing the technical side of digital marketing. We talked about some of the resources I mentioned in the
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 »
