2017 has been a wild year, to say the least. From waking up wondering if closed-mindedness was becoming mainstream to waking up wondering about the likelihood of nuclear war, to waking up in any one of over a dozen countries, there has been something remarkably unstable about 2017 (even for me). But amidst all the …
The three most important things I learned in 2017 Read More »
There is something so fitting about working with URLs in Google Apps Script and Google Spreadsheets. The cloud-based software works in the browser where, indeed, there are a lot of URLs to work with. Google Apps Script’s doPost, doGet, and UrlFetchApp make HTTP requests to URLs easy. Google Spreadsheets has similar functionality with IMPORTXML, IMPORTHTML, IMPORTFEED, and IMPORTDATA. If you work in web analytics, digital marketing, …
Working with URLs in Google Apps Script and Google Sheets Read More »
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 they are a great way to learn about your competition’s architecture and search strategy. I mean, they literally map out the content that your competition is trying to add to search …
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 …
