Google Spreadsheets

A better way to LISTAGG in Google Sheets (with Pivot Tables)

The SQL LISTAGG function in Snowflake or Redshift (or STRING_AGG in BigQuery) are aggregation functions that condense textual data into easy-to-view reports. Similar to other aggregation functions (like SUM or MAX), these functions aggregate data according to the column names in a GROUP BY clause.  This is a common pattern for rolling up a column …

A better way to LISTAGG in Google Sheets (with Pivot Tables) Read More »

Pulling Reddit Metrics into Google Sheets

Reddit is a legend of the Web 2.0 transitionary time period. In that era, it was common to find rough edges around popular sites and features and Easter Eggs that could be described as “features that don’t exactly have any purpose but some people might find it cool.” (Consider Google’s “I’m feeling lucky” feature… This post …

Pulling Reddit Metrics into Google Sheets Read More »

Dynamic Gantt Charts in Google Sheets + Project Timeline Template

Google Docs and Gantt charts are a perfect match. Google Spreadsheets offers the ability to share and update spreadsheets in real-time, which is a major benefit for any project team, especially those who work in different locations or time zones. On top of that, you can’t beat the free price! Many projects are complex enough …

Dynamic Gantt Charts in Google Sheets + Project Timeline Template Read More »

JSON-LD Bulk Editor and File Generator for Google Sheets

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 »

How to Make a Google Apps Script RESTful API or Service

You know what’s cooler than calling API’s and services with Google Apps Script? Making your own API with Google Apps Script. After playing around with my first REST API with Python and Bottle, I wondered how this could be done even cheaper and quicker; without worrying about the complexities of databases and hosting. When it’s simple …

How to Make a Google Apps Script RESTful API or Service Read More »

Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets

Update: This script now allows you to copy multiple sheets within one spreadsheet to either the same spreadsheet or a different one. If you want to copy the sheet to the same spreadsheet, just input your current spreadsheet’s ID when prompted. The spreadsheet id can be found in the Spreadsheet’s URL eg: docs.google.com/spreadsheets/d/SPREADSHEETID/edit#gid=0 If you are looking …

Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets Read More »

Automate MailChimp Reporting with Google Spreadsheets

I made it! I am finally a nerd. At the top of the MailChimp API there is a clear disclaimer: “Woah, Nerds Only!” Undeterred, I scrolled on to test my nerdy medal. The following is my account of navigating the well-charted waters of the MailChimp API and a tutorial on how to automate a “BARF” …

Automate MailChimp Reporting with Google Spreadsheets Read More »