Google Spreadsheets

Gen AI Classification

Using ChatGPT in Google Sheets for Classification (custom function included)

Leave a Comment / Google Apps Script, Google Spreadsheets, Tutorials /

Classification is the generative AI-based pattern I use most frequently. Why? Three reasons: It’s perfect for tackling big tasks where 80% accuracy on 100% of cases is better than 100% accuracy on just 20%. This week alone, I’ve used classification to: Since Google Sheets is one of my go-to tools for small/quick data problems, I […]

Using ChatGPT in Google Sheets for Classification (custom function included) Read More »

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

Leave a Comment / Google Spreadsheets /

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

Leave a Comment / Google Apps Script, Google Spreadsheets /

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

45 Comments / Google Spreadsheets, Tutorials /

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

7 Comments / Digital Marketing Technical Skills, Google Apps Script, Google Spreadsheets, SEO /

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

14 Comments / Google Apps Script, Google Spreadsheets, Javascript /

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

42 Comments / Google Analytics, Google Apps Script, 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 »

CONTACT
CONTACT